contig_metadata
12 rows where bioproject = "PRJNA764222", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4572893 | 4572893 | PRJNA764222_S_NODE_14824_length_234_cov_2.235294_g14666_i0 | PRJNA764222 | 14824 | 234 | 2.235294 | 5.23058796 | Macrostomum poznaniense | 2614303 | Platyhelminthes | Platyhelminthes | 433 | 6.41e-117 | NTclustered | gi|1837893560|gb|MT429061.1| | 2614303 | g14666 | i0 | 100 | 100.705128205128 | 234 | 0 | 100 | 0 | 1 | 234 | 332 | 565 | Macrostomum poznaniense voucher MTP_LS_2365 large subunit ribosomal RNA gene, partial sequence | blastn | 23565 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum poznaniense | |
| 10134427 | 10134427 | PRJNA764222_S_NODE_8668_length_272_cov_16.702222_g8510_i0 | PRJNA764222 | 8668 | 272 | 16.702222 | 45.43004384 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 418 | 2.14e-112 | NTclustered | gi|926460157|gb|KR132223.1| | 282301 | g8510 | i0 | 94.485 | 71.3198529411765 | 272 | 14 | 100 | 1 | 1 | 272 | 5245 | 5515 | Macrostomum lignano clone c100550_g1_i1 mRNA sequence | blastn | 19399 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 13498492 | 13498492 | PRJNA764222_S_NODE_28851_length_173_cov_2.238095_g28693_i0 | PRJNA764222 | 28851 | 173 | 2.238095 | 3.87190435 | Macrostomum balticum | 683707 | Platyhelminthes | Platyhelminthes | 320 | 3.61e-83 | NTclustered | gi|261873745|gb|FJ715310.1| | 683707 | g28693 | i0 | 100 | 100.086705202312 | 173 | 0 | 100 | 0 | 1 | 173 | 534 | 706 | Macrostomum balticum voucher MTP LS 144 18S small subunit ribosomal RNA gene, partial sequence | blastn | 17315 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum balticum | |
| 17783365 | 17783365 | PRJNA764222_S_NODE_18454_length_216_cov_3.366864_g18296_i0 | PRJNA764222 | 18454 | 216 | 3.366864 | 7.27242624 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 396 | 7.6399999999999955e-106 | NTclustered | gi|848094824|gb|KP730496.1| | 52054 | g18296 | i0 | 100 | 94.7175925925926 | 214 | 0 | 99 | 0 | 1 | 214 | 223 | 10 | Macrostomum tuba voucher MTP LS 586 18S ribosomal RNA gene, partial sequence | blastn | 20459 | 399 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum tuba | |
| 18596318 | 18596318 | PRJNA764222_S_NODE_1855_length_429_cov_28.486911_g1697_i0 | PRJNA764222 | 1855 | 429 | 28.486911 | 122.20884819 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 307 | 8e-79 | NTclustered | gi|1241842076|gb|MF361131.1| | 282301 | g1697 | i0 | 84.049 | 52.0559440559441 | 326 | 45 | 75 | 6 | 36 | 358 | 3816 | 3495 | Macrostomum lignano strain DV1 mitochondrion, complete genome | blastn | 22332 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 21147174 | 21147174 | PRJNA764222_S_NODE_19277_length_212_cov_4.012121_g19119_i0 | PRJNA764222 | 19277 | 212 | 4.012121 | 8.50569652 | Macrostomum sp. CEL-2014 | 1468207 | Platyhelminthes | Platyhelminthes | 370 | 4.53e-98 | NTclustered | gi|588313885|gb|KC869843.1| | 1468207 | g19119 | i0 | 98.113 | 101.084905660377 | 212 | 4 | 100 | 0 | 1 | 212 | 2693 | 2904 | Macrostomum sp. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 21430 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum sp. CEL-2014 | |
| 22421819 | 22421819 | PRJNA764222_S_NODE_11918_length_250_cov_2.438424_g11760_i0 | PRJNA764222 | 11918 | 250 | 2.438424 | 6.09606 | Temnosewellia dendyi | 1856489 | Platyhelminthes | Platyhelminthes | 226 | 1.26e-54 | NTclustered | gi|1034624732|gb|KX095327.1| | 1856489 | g11760 | i0 | 83.673 | 65.428 | 245 | 34 | 97 | 6 | 7 | 248 | 313 | 554 | Temnosewellia dendyi isolate KBS672 cytochrome c oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 16357 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Temnocephalidae | Temnosewellia | Temnosewellia dendyi | |
| 27337793 | 27337793 | PRJNA764222_S_NODE_4503_length_318_cov_1.461255_g4345_i0 | PRJNA764222 | 4503 | 318 | 1.461255 | 4.6467909 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 86.7 | 1.03e-19 | NR | PAA56754.1 | 282301 | g4345 | i0 | 80.5 | 0.386792452830189 | 41 | 8 | 38.7 | 0 | 317 | 195 | 48 | 88 | PAA56754.1 hypothetical protein BOX15_Mlig011635g4 [Macrostomum lignano] | diamond | 123 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27432691 | 27432691 | PRJNA764222_S_NODE_32343_length_162_cov_3.582609_g32185_i0 | PRJNA764222 | 32343 | 162 | 3.582609 | 5.80382658 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 69.7 | 2.06e-13 | NR | PAA67750.1 | 282301 | g32185 | i0 | 97.1 | 0.648148148148148 | 35 | 1 | 64.8 | 0 | 162 | 58 | 101 | 135 | PAA67750.1 hypothetical protein BOX15_Mlig022537g2, partial [Macrostomum lignano] | diamond | 105 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28600797 | 28600797 | PRJNA764222_S_NODE_12087_length_249_cov_2.430693_g11929_i0 | PRJNA764222 | 12087 | 249 | 2.430693 | 6.05242557 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 56.6 | 6.58e-8 | NR | PAA53801.1 | 282301 | g11929 | i0 | 56.1 | 0.493975903614458 | 41 | 18 | 49.4 | 0 | 5 | 127 | 86 | 126 | PAA53801.1 hypothetical protein BOX15_Mlig023736g2, partial [Macrostomum lignano] | diamond | 123 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28600800 | 28600800 | PRJNA764222_S_NODE_25787_length_185_cov_1.847826_g25629_i0 | PRJNA764222 | 25787 | 185 | 1.847826 | 3.4184781 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 105 | 4.86e-27 | NR | PAA58262.1 | 282301 | g25629 | i0 | 89.3 | 1.81621621621622 | 56 | 6 | 90.8 | 0 | 3 | 170 | 121 | 176 | PAA58262.1 hypothetical protein BOX15_Mlig017433g2 [Macrostomum lignano] | diamond | 336 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30684996 | 30684996 | PRJNA764222_S_NODE_32953_length_160_cov_2.008850_g32795_i0 | PRJNA764222 | 32953 | 160 | 2.00885 | 3.21416 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 92.4 | 3.75e-22 | NR | PAA45962.1 | 282301 | g32795 | i0 | 93.6 | 0.88125 | 47 | 3 | 88.1 | 0 | 1 | 141 | 107 | 153 | PAA45962.1 hypothetical protein BOX15_Mlig032769g3, partial [Macrostomum lignano] | diamond | 141 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;