contig_metadata
9 rows where bioproject = "PRJEB28589", tax_clade = "Opisthokonta" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988038 | 988038 | PRJEB28589_S_NODE_8381_length_271_cov_2.816964_g8273_i0 | PRJEB28589 | 8381 | 271 | 2.816964 | 7.63397244 | Metazoa | 33208 | Annelida | Annelida | 123 | 2.31e-30 | NR | CAH1785876.1 | 6347 | g8273 | i0 | 67.1 | 6.3542435424354196 | 82 | 27 | 90.8 | 0 | 25 | 270 | 530 | 611 | CAH1785876.1 unnamed protein product [Owenia fusiformis] | diamond | 1722 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 3852179 | 3852179 | PRJEB28589_S_NODE_9664_length_253_cov_1.485437_g9556_i0 | PRJEB28589 | 9664 | 253 | 1.485437 | 3.75815561 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g9556 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 143 | 170 | 11211248 | 11211221 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6404199 | 6404199 | PRJEB28589_S_NODE_5666_length_313_cov_3.338346_g5558_i0 | PRJEB28589 | 5666 | 313 | 3.338346 | 10.44902298 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g5558 | i0 | 100 | 1.10543130990415 | 29 | 0 | 9 | 0 | 169 | 197 | 6367232 | 6367204 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 346 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7678244 | 7678244 | PRJEB28589_S_NODE_6847_length_295_cov_2.508065_g6739_i0 | PRJEB28589 | 6847 | 295 | 2.508065 | 7.39879175 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g6739 | i0 | 94.286 | 0.11864406779661 | 35 | 1 | 12 | 1 | 34 | 68 | 2788993 | 2788960 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20426688 | 20426688 | PRJEB28589_S_NODE_5357_length_318_cov_6.501845_g5249_i0 | PRJEB28589 | 5357 | 318 | 6.501845 | 20.6758671 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.78e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g5249 | i0 | 97.143 | 0.374213836477987 | 35 | 1 | 11 | 0 | 2 | 36 | 7219464 | 7219498 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 119 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20426697 | 20426697 | PRJEB28589_S_NODE_6337_length_303_cov_4.117188_g6229_i0 | PRJEB28589 | 6337 | 303 | 4.117188 | 12.47507964 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 63.9 | 1.3e-5 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g6229 | i0 | 84.615 | 0.214521452145215 | 65 | 8 | 21 | 2 | 10 | 73 | 8310892 | 8310829 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 65 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20426714 | 20426714 | PRJEB28589_S_NODE_8137_length_275_cov_1.679825_g8029_i0 | PRJEB28589 | 8137 | 275 | 1.679825 | 4.61951875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5.43e-4 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g8029 | i0 | 92.683 | 0.250909090909091 | 41 | 2 | 15 | 1 | 150 | 189 | 9030536 | 9030576 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 69 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21702734 | 21702734 | PRJEB28589_S_NODE_5058_length_324_cov_3.238267_g4950_i0 | PRJEB28589 | 5058 | 324 | 3.238267 | 10.49198508 | Metazoa | 33208 | Annelida | Annelida | 99.4 | 1.3700000000000002e-21 | NR | CAH1786368.1 | 6347 | g4950 | i0 | 58.5 | 8.01851851851852 | 82 | 28 | 70.4 | 1 | 7 | 234 | 892 | 973 | CAH1786368.1 unnamed protein product [Owenia fusiformis] | diamond | 2598 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32619085 | 32619085 | PRJEB28589_S_NODE_16560_length_173_cov_2.484127_g16452_i0 | PRJEB28589 | 16560 | 173 | 2.484127 | 4.29753971 | Metazoa | 33208 | Annelida | Annelida | 89 | 6.19e-19 | NR | KAK2174450.1 | 27915 | g16452 | i0 | 84.8 | 3.22543352601156 | 46 | 7 | 79.8 | 0 | 143 | 6 | 397 | 442 | KAK2174450.1 hypothetical protein NP493_801g02052 [Ridgeia piscesae] | diamond | 558 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;