contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 | ||||
| 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 |
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);;