Project banner

Editor - Genome table

PDO

phpMyEdit error: Invalid SQL: [SELECT `PMEtable0`.`ID` AS `qf0`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) AS `qf1`,`PMEtable0`.`T_NO` AS `qf1_idx`,`PMEtable0`.`G_TAXID` AS `qf2`,`PMEtable0`.`G_SEQID` AS `qf3`,`PMEtable0`.`G_SEQ_TYPE` AS `qf4`,`PMEtable0`.`G_SEQ_TYPE` AS `qf4_idx`,`PMEtable0`.`G_DESCRIPTION` AS `qf5`,`PMEtable0`.`G_SEQUENCE` AS `qf6`,CONCAT(IFNULL(CAST(`PMEjoin7`.`B_AUTHOR` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin7`.`B_YEAR` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin7`.`B_SEQUENCE` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin7`.`B_TITLE` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin7`.`B_DETAIL` AS CHAR),"")) AS `qf7`,`PMEtable0`.`B_NO` AS `qf7_idx` FROM `genome` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) LEFT OUTER JOIN `bibliography` AS `PMEjoin7` ON (`PMEjoin7`.`B_NO` = `PMEtable0`.`B_NO`) ORDER BY `PMEtable0`.`G_TAXID`,`PMEtable0`.`G_SEQID`,`PMEtable0`.`G_SEQ_TYPE`,`PMEtable0`.`G_DESCRIPTION` LIMIT 0, 15] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'PMEtable0.G_SEQID' in 'field list'

phpMyEdit error code: 42S22

MySQL error


phpMyEdit error: invalid SQL query 1


SELECT `PMEtable0`.`ID` AS `qf0`,CONCAT(IFNULL(CAST(`PMEjoin1`.`T_GENUS` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SPECIES` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin1`.`T_SUBSP` AS CHAR),"")) AS `qf1`,`PMEtable0`.`T_NO` AS `qf1_idx`,`PMEtable0`.`G_TAXID` AS `qf2`,`PMEtable0`.`G_SEQID` AS `qf3`,`PMEtable0`.`G_SEQ_TYPE` AS `qf4`,`PMEtable0`.`G_SEQ_TYPE` AS `qf4_idx`,`PMEtable0`.`G_DESCRIPTION` AS `qf5`,`PMEtable0`.`G_SEQUENCE` AS `qf6`,CONCAT(IFNULL(CAST(`PMEjoin7`.`B_AUTHOR` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin7`.`B_YEAR` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin7`.`B_SEQUENCE` AS CHAR),"")," ",IFNULL(CAST(`PMEjoin7`.`B_TITLE` AS CHAR),""),". ",IFNULL(CAST(`PMEjoin7`.`B_DETAIL` AS CHAR),"")) AS `qf7`,`PMEtable0`.`B_NO` AS `qf7_idx` FROM `genome` AS `PMEtable0` LEFT OUTER JOIN `taxa` AS `PMEjoin1` ON (`PMEjoin1`.`T_NO` = `PMEtable0`.`T_NO`) LEFT OUTER JOIN `bibliography` AS `PMEjoin7` ON (`PMEjoin7`.`B_NO` = `PMEtable0`.`B_NO`) ORDER BY `PMEtable0`.`G_TAXID`,`PMEtable0`.`G_SEQID`,`PMEtable0`.`G_SEQ_TYPE`,`PMEtable0`.`G_DESCRIPTION` LIMIT 0, 15

phpMyEdit error code: 42S22

Download as: Excel | CSV | FASTA


Powered by ACACIA

Taxon name TaxId SeqId Sequence type Sequence description Sequence Reference