contig_metadata
7 rows where bioproject = "PRJNA674048", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8296385 | 8296385 | PRJNA674048_P_NODE_21267_length_190_cov_6.588652_g21064_i0 | PRJNA674048 | 21267 | 190 | 6.588652 | 12.5184388 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 340 | 3.1099999999999993e-89 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g21064 | i0 | 98.947 | 42.6631578947368 | 190 | 2 | 100 | 0 | 1 | 190 | 1844 | 2033 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8106 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 17221250 | 17221250 | PRJNA674048_P_NODE_5314_length_452_cov_5.615385_g5111_i0 | PRJNA674048 | 5314 | 452 | 5.615385 | 25.3815402 | Stenostomum sp. 'island' | 570256 | Platyhelminthes | Platyhelminthes | 747 | 0 | NTclustered | gi|209968693|gb|FJ384856.1| | 570256 | g5111 | i0 | 96.468 | 58.3716814159292 | 453 | 15 | 100 | 1 | 1 | 452 | 790 | 338 | Stenostomum sp. 'island' isolate K04_93 28S ribosomal RNA gene, partial sequence | blastn | 26384 | 747 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sp. 'island' | |||
| 18495563 | 18495563 | PRJNA674048_P_NODE_9435_length_309_cov_1.196154_g9232_i0 | PRJNA674048 | 9435 | 309 | 1.196154 | 3.69611586 | Stenostomum cf. simplex AW-2018 | 2495572 | Platyhelminthes | Platyhelminthes | 545 | 1.0899999999999999e-150 | NTclustered | gi|1532673575|gb|MH663467.1| | 2495572 | g9232 | i0 | 98.697 | 0.993527508090615 | 307 | 4 | 99 | 0 | 1 | 307 | 86 | 392 | Stenostomum cf. simplex AW-2018 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 307 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum cf. simplex AW-2018 | |||
| 19769933 | 19769933 | PRJNA674048_P_NODE_18616_length_205_cov_1.897436_g18413_i0 | PRJNA674048 | 18616 | 205 | 1.897436 | 3.8897438 | Bresslauilla relicta | 1311963 | Platyhelminthes | Platyhelminthes | 86.1 | 1.77e-12 | NTclustered | gi|588313927|gb|KC869885.1| | 1311963 | g18413 | i0 | 81.081 | 0.819512195121951 | 111 | 17 | 54 | 2 | 16 | 126 | 1606 | 1712 | Bresslauilla relicta 28S ribosomal RNA genes, partial sequence | blastn | 168 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Graffillidae | Bresslauilla | Bresslauilla relicta | |
| 22320443 | 22320443 | PRJNA674048_P_NODE_26978_length_169_cov_0.866667_g26775_i0 | PRJNA674048 | 26978 | 169 | 0.866667 | 1.46466723 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 5.37e-20 | NR | VDM26248.1 | 6205 | g26775 | i0 | 79.6 | 76.0828402366864 | 54 | 11 | 95.9 | 0 | 1 | 162 | 73 | 126 | VDM26248.1 unnamed protein product, partial [Hydatigera taeniaeformis] | diamond | 12858 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 23595905 | 23595905 | PRJNA674048_P_NODE_18079_length_208_cov_2.320755_g17876_i0 | PRJNA674048 | 18079 | 208 | 2.320755 | 4.8271704 | Stenostomum cf. simplex AW-2018 | 2495572 | Platyhelminthes | Platyhelminthes | 374 | 3.4199999999999996e-99 | NTclustered | gi|1532673575|gb|MH663467.1| | 2495572 | g17876 | i0 | 99.038 | 2 | 208 | 2 | 100 | 0 | 1 | 208 | 566 | 773 | Stenostomum cf. simplex AW-2018 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 416 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum cf. simplex AW-2018 | |||
| 30504491 | 30504491 | PRJNA674048_P_NODE_25093_length_175_cov_1.650794_g24890_i0 | PRJNA674048 | 25093 | 175 | 1.650794 | 2.8888895 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 61.6 | 3.12e-9 | NR | CAH8620869.1 | 57078 | g24890 | i0 | 52.1 | 3.37714285714286 | 48 | 20 | 82.3 | 1 | 15 | 158 | 333 | 377 | CAH8620869.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 591 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;