contig_metadata
8 rows where bioproject = "PRJNA1174207", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315959 | 315959 | PRJNA1174207_P_NODE_41021_length_241_cov_3.386905_g40492_i0 | PRJNA1174207 | 41021 | 241 | 3.386905 | 8.16244105 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 412 | 8.64e-111 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g40492 | i0 | 97.51 | 1.94605809128631 | 241 | 6 | 100 | 0 | 1 | 241 | 6817 | 7057 | 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 | 469 | 412 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6693241 | 6693241 | PRJNA1174207_P_NODE_13426_length_398_cov_3.664615_g12898_i0 | PRJNA1174207 | 13426 | 398 | 3.664615 | 14.5851677 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 695 | 0 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g12898 | i0 | 98.241 | 76.3894472361809 | 398 | 6 | 100 | 1 | 1 | 398 | 594 | 990 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 30403 | 695 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 15618687 | 15618687 | PRJNA1174207_P_NODE_43673_length_206_cov_7.902256_g43144_i0 | PRJNA1174207 | 43673 | 206 | 7.902256 | 16.27864736 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 374 | 3.3799999999999997e-99 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g43144 | i0 | 99.512 | 58.995145631068 | 205 | 1 | 99 | 0 | 1 | 205 | 1279 | 1483 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 12153 | 374 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 16892722 | 16892722 | PRJNA1174207_P_NODE_28574_length_270_cov_2.182741_g28045_i0 | PRJNA1174207 | 28574 | 270 | 2.182741 | 5.8934007 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 399 | 7.669999999999998e-107 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g28045 | i0 | 93.358 | 44.9925925925926 | 271 | 17 | 100 | 1 | 1 | 270 | 1231 | 961 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 12148 | 399 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 16893015 | 16893015 | PRJNA1174207_P_NODE_43434_length_219_cov_6.568493_g42905_i0 | PRJNA1174207 | 43434 | 219 | 6.568493 | 14.38499967 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 383 | 6.05e-102 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g42905 | i0 | 98.165 | 50.662100456621 | 218 | 4 | 99 | 0 | 1 | 218 | 126 | 343 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 11095 | 383 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 16893041 | 16893041 | PRJNA1174207_P_NODE_5494_length_721_cov_1.848765_g4990_i0 | PRJNA1174207 | 5494 | 721 | 1.848765 | 13.32959565 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 907 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4990 | i0 | 89.365 | 35.8959778085992 | 724 | 74 | 100 | 1 | 1 | 721 | 2298 | 3021 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25881 | 907 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 20166828 | 20166828 | PRJNA1174207_P_NODE_19796_length_318_cov_3.134694_g19267_i0 | PRJNA1174207 | 19796 | 318 | 3.134694 | 9.96832692 | Cryptodifflugia | 1078833 | Tubulinea | other_Eukaryota | 553 | 6.699999999999998e-153 | NTclustered | gi|345294024|gb|JF694280.1| | 1078836 | g19267 | i0 | 98.107 | 85.6761006289308 | 317 | 6 | 99 | 0 | 2 | 318 | 1803 | 1487 | Cryptodifflugia operculata small subunit ribosomal RNA gene, partial sequence | blastn | 27245 | 553 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 23992832 | 23992832 | PRJNA1174207_P_NODE_29239_length_267_cov_5.896907_g28710_i0 | PRJNA1174207 | 29239 | 267 | 5.896907 | 15.74474169 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 483 | 7.31e-132 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g28710 | i0 | 99.251 | 39.1198501872659 | 267 | 2 | 100 | 0 | 1 | 267 | 3608 | 3874 | 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 | 10445 | 483 | 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);;