contig_metadata
11 rows where bioproject = "PRJNA642647", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3710342 | 3710342 | PRJNA642647_P_NODE_2043_length_241_cov_4.872549_g1993_i0 | PRJNA642647 | 2043 | 241 | 4.872549 | 11.74284309 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 435 | 1.84e-117 | NTclustered | gi|399764177|gb|JQ271688.1| | 5778 | g1993 | i0 | 100 | 97.49377593361 | 235 | 0 | 98 | 0 | 4 | 238 | 139 | 373 | Hartmannella vermiformis strain ECH26 18S ribosomal RNA gene, partial sequence | blastn | 23496 | 435 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4445677 | 4445677 | PRJNA642647_P_NODE_3544_length_188_cov_3.238411_g3494_i0 | PRJNA642647 | 3544 | 188 | 3.238411 | 6.08821268 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 309 | 8.66e-80 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3494 | i0 | 97.253 | 1.91489361702128 | 182 | 5 | 97 | 0 | 4 | 185 | 7048 | 6867 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 360 | 309 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4445679 | 4445679 | PRJNA642647_P_NODE_4064_length_179_cov_1.077465_g4014_i0 | PRJNA642647 | 4064 | 179 | 1.077465 | 1.92866235 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 326 | 8.09e-85 | NTclustered | gi|2517949732|gb|OR125031.1| | 1165352 | g4014 | i0 | 100 | 24.4692737430168 | 176 | 0 | 98 | 0 | 4 | 179 | 199 | 374 | Cryptodifflugia oviformis isolate strain_6 small subunit ribosomal RNA gene, partial sequence | blastn | 4380 | 326 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 6996540 | 6996540 | PRJNA642647_P_NODE_266_length_685_cov_21.387346_g228_i0 | PRJNA642647 | 266 | 685 | 21.387346 | 146.5033201 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 427 | 9.72e-115 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g228 | i0 | 80.2 | 19.5445255474453 | 601 | 94 | 86 | 25 | 91 | 682 | 1 | 585 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 13388 | 427 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 9546603 | 9546603 | PRJNA642647_P_NODE_6008_length_156_cov_0.932773_g5958_i0 | PRJNA642647 | 6008 | 156 | 0.932773 | 1.45512588 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 252 | 1.18e-62 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g5958 | i0 | 99.281 | 46.8589743589744 | 139 | 1 | 89 | 0 | 16 | 154 | 26595 | 26457 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 7310 | 252 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10087068 | 10087068 | PRJNA642647_P_NODE_3468_length_190_cov_2.111111_g3418_i0 | PRJNA642647 | 3468 | 190 | 2.111111 | 4.0111109 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 182 | 2e-41 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g3418 | i0 | 91.667 | 73.3315789473684 | 132 | 9 | 69 | 2 | 57 | 187 | 2040 | 1910 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 13933 | 182 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13372018 | 13372018 | PRJNA642647_P_NODE_3411_length_191_cov_4.454545_g3361_i0 | PRJNA642647 | 3411 | 191 | 4.454545 | 8.50818095 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 348 | 1.87e-91 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3361 | i0 | 100 | 87.8534031413613 | 188 | 0 | 98 | 0 | 1 | 188 | 4857 | 4670 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 16780 | 348 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17736456 | 17736456 | PRJNA642647_P_NODE_2034_length_242_cov_2.360976_g1984_i0 | PRJNA642647 | 2034 | 242 | 2.360976 | 5.71356192 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 261 | 3.33e-65 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g1984 | i0 | 86.722 | 88.8264462809917 | 241 | 24 | 96 | 4 | 10 | 242 | 352 | 592 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 21496 | 261 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 19744843 | 19744843 | PRJNA642647_P_NODE_296_length_652_cov_27.918699_g253_i0 | PRJNA642647 | 296 | 652 | 27.918699 | 182.02991748 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 566 | 1.87e-156 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g253 | i0 | 85.231 | 25.2085889570552 | 562 | 70 | 85 | 13 | 91 | 646 | 1 | 555 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16436 | 566 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 22295044 | 22295044 | PRJNA642647_P_NODE_118_length_1011_cov_10.422998_g99_i0 | PRJNA642647 | 118 | 1011 | 10.422998 | 105.37650978 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1029 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g99 | i0 | 97.512 | 25.6864490603363 | 603 | 13 | 99 | 2 | 409 | 1010 | 3861 | 4462 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 25969 | 1029 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25384931 | 25384931 | PRJNA642647_P_NODE_260_length_693_cov_9.434451_g222_i0 | PRJNA642647 | 260 | 693 | 9.434451 | 65.38074543 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1236 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g222 | i0 | 98.986 | 99.5007215007215 | 690 | 7 | 99 | 0 | 1 | 690 | 5574 | 4885 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 68954 | 1236 | 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);;