contig_metadata
11 rows where bioproject = "PRJNA556992", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6904341 | 6904341 | PRJNA556992_P_NODE_269406_length_296_cov_9.784753_g267217_i0 | PRJNA556992 | 269406 | 296 | 9.784753 | 28.96286888 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 547 | 2.8799999999999986e-151 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g267217 | i0 | 100 | 32.3074324324324 | 296 | 0 | 100 | 0 | 1 | 296 | 1215 | 1510 | 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 | 9563 | 547 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8175139 | 8175139 | PRJNA556992_P_NODE_1048507_length_225_cov_5.111842_g1046317_i0 | PRJNA556992 | 1048507 | 225 | 5.111842 | 11.5016445 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 267 | 6.559999999999999e-67 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g1046317 | i0 | 88.688 | 0.982222222222222 | 221 | 21 | 98 | 3 | 1 | 221 | 489 | 705 | 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 | 221 | 267 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9458463 | 9458463 | PRJNA556992_P_NODE_537708_length_264_cov_1.612565_g535519_i0 | PRJNA556992 | 537708 | 264 | 1.612565 | 4.2571716 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 459 | 1.22e-124 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g535519 | i0 | 98.099 | 26.5871212121212 | 263 | 5 | 99 | 0 | 1 | 263 | 6757 | 7019 | 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 | 7019 | 459 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10738495 | 10738495 | PRJNA556992_P_NODE_89209_length_419_cov_6.104046_g87027_i0 | PRJNA556992 | 89209 | 419 | 6.104046 | 25.57595274 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 728 | 0 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g87027 | i0 | 98.091 | 77.7923627684964 | 419 | 7 | 100 | 1 | 1 | 419 | 600 | 1017 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 32595 | 728 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 17110303 | 17110303 | PRJNA556992_P_NODE_750654_length_248_cov_3.708571_g748465_i0 | PRJNA556992 | 750654 | 248 | 3.708571 | 9.19725608 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 195 | 3.52e-45 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g748465 | i0 | 81.148 | 59.1048387096774 | 244 | 45 | 98 | 1 | 4 | 247 | 27275 | 27517 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 14658 | 195 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19661949 | 19661949 | PRJNA556992_P_NODE_998116_length_230_cov_7.713376_g995926_i0 | PRJNA556992 | 998116 | 230 | 7.713376 | 17.7407648 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 403 | 4.92e-108 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g995926 | i0 | 98.253 | 62.5608695652174 | 229 | 4 | 99 | 0 | 2 | 230 | 355 | 127 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 14389 | 403 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 22803044 | 22803044 | PRJNA556992_P_NODE_33678_length_600_cov_1.943074_g31561_i0 | PRJNA556992 | 33678 | 600 | 1.943074 | 11.658444 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1090 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g31561 | i0 | 99.499 | 60.31 | 599 | 3 | 99 | 0 | 2 | 600 | 2926 | 2328 | 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 | 36186 | 1090 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24752831 | 24752831 | PRJNA556992_P_NODE_279900_length_293_cov_1.845455_g277711_i0 | PRJNA556992 | 279900 | 293 | 1.845455 | 5.40718315 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 157 | 1.0399999999999997e-42 | NR | AKT93967.1 | 5778 | g277711 | i0 | 89.8 | 1.80204778156997 | 88 | 9 | 90.1 | 0 | 1 | 264 | 395 | 482 | AKT93967.1 NADH dehydrogenase subunit 5 [Vermamoeba vermiformis] | diamond | 528 | 157 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24760461 | 24760461 | PRJNA556992_P_NODE_882280_length_241_cov_6.648810_g880090_i0 | PRJNA556992 | 882280 | 241 | 6.64881 | 16.0236321 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 99 | 2.75e-16 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g880090 | i0 | 80.8 | 0.518672199170125 | 125 | 24 | 52 | 0 | 18 | 142 | 41420 | 41544 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 125 | 99 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31722204 | 31722204 | PRJNA556992_P_NODE_866237_length_242_cov_3.502959_g864047_i0 | PRJNA556992 | 866237 | 242 | 3.502959 | 8.47716078 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 120 | 5.55e-32 | NR | ABD46545.1 | 5778 | g864047 | i0 | 96.6 | 0.731404958677686 | 59 | 2 | 73.1 | 0 | 65 | 241 | 138 | 196 | ABD46545.1 aldehyde dehydrogenase, partial [Vermamoeba vermiformis] | diamond | 177 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32133630 | 32133630 | PRJNA556992_P_NODE_772638_length_247_cov_2.741379_g770448_i0 | PRJNA556992 | 772638 | 247 | 2.741379 | 6.77120613 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 145 | 1.03e-42 | NR | AKT93944.1 | 5778 | g770448 | i0 | 84.1 | 1.9919028340081 | 82 | 13 | 99.6 | 0 | 247 | 2 | 33 | 114 | AKT93944.1 ribosomal protein S8 [Vermamoeba vermiformis] | diamond | 492 | 145 | 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);;