contig_metadata
6 rows where bioproject = "PRJNA788929", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7147888 | 7147888 | PRJNA788929_P_NODE_32826_length_273_cov_8.020000_g32165_i0 | PRJNA788929 | 32826 | 273 | 8.02 | 21.8946 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 455 | 1.6300000000000002e-123 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g32165 | i0 | 99.206 | 13.0842490842491 | 252 | 2 | 92 | 0 | 1 | 252 | 514 | 263 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 3572 | 455 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 10973475 | 10973475 | PRJNA788929_P_NODE_37349_length_252_cov_32.122905_g36688_i0 | PRJNA788929 | 37349 | 252 | 32.122905 | 80.9497206 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 281 | 2.68e-71 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g36688 | i0 | 89.908 | 20.6388888888889 | 218 | 22 | 87 | 0 | 34 | 251 | 144 | 361 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5201 | 281 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 13523332 | 13523332 | PRJNA788929_P_NODE_44151_length_233_cov_9.612500_g43490_i0 | PRJNA788929 | 44151 | 233 | 9.6125 | 22.397125 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 346 | 8.54e-91 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g43490 | i0 | 96.667 | 1.80257510729614 | 210 | 3 | 90 | 1 | 24 | 233 | 1626 | 1831 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 420 | 346 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 19066093 | 19066093 | PRJNA788929_P_NODE_50035_length_198_cov_5.648000_g49374_i0 | PRJNA788929 | 50035 | 198 | 5.648 | 11.18304 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 246 | 7.34e-61 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g49374 | i0 | 91.667 | 43.7222222222222 | 180 | 11 | 89 | 4 | 1 | 177 | 1510 | 1332 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 8657 | 246 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 23722246 | 23722246 | PRJNA788929_P_NODE_34859_length_263_cov_16.726316_g34198_i0 | PRJNA788929 | 34859 | 263 | 16.726316 | 43.99021108 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 243 | 1.33e-59 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g34198 | i0 | 85.185 | 13.0760456273764 | 243 | 29 | 91 | 7 | 24 | 263 | 15 | 253 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 3439 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 30916185 | 30916185 | PRJNA788929_P_NODE_1454_length_1722_cov_39.215282_g1262_i0 | PRJNA788929 | 1454 | 1722 | 39.215282 | 675.28715604 | root | 1 | Root_unresolved | Root_unresolved | 348 | 1.4099999999999998e-110 | NR | ABD46557.1 | 5778 | g1262 | i0 | 40.4 | 5.77003484320557 | 460 | 257 | 79.3 | 6 | 158 | 1522 | 1 | 448 | ABD46557.1 sodium:galactoside symporter-like protein, partial [Vermamoeba vermiformis] | diamond | 9936 | 348 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;