contig_metadata
9 rows where bioproject = "PRJNA980587" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1269596 | 1269596 | PRJNA980587_P_NODE_72001_length_265_cov_1.552083_g71208_i0 | PRJNA980587 | 72001 | 265 | 1.552083 | 4.11301995 | Deinococcus | 1298 | Bacteria | Bacteria | 466 | 7.2999999999999995e-127 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g71208 | i0 | 98.491 | 226.637735849057 | 265 | 2 | 99 | 2 | 2 | 265 | 1791865 | 1792128 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 60059 | 466 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 4784556 | 4784556 | PRJNA980587_P_NODE_93784_length_242_cov_0.911243_g92991_i0 | PRJNA980587 | 93784 | 242 | 0.911243 | 2.20520806 | Deinococcus sp. D7000 | 2755035 | Bacteria | Bacteria | 233 | 7.25e-57 | NTclustered | gi|1868561018|gb|CP058534.1| | 2755035 | g92991 | i0 | 84.167 | 9.57438016528926 | 240 | 38 | 99 | 0 | 2 | 241 | 947017 | 946778 | Deinococcus sp. D7000 chromosome, complete genome | blastn | 2317 | 233 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. D7000 | ||
| 7333952 | 7333952 | PRJNA980587_P_NODE_84666_length_247_cov_0.885057_g83873_i0 | PRJNA980587 | 84666 | 247 | 0.885057 | 2.18609079 | Thermus scotoductus | 37636 | Bacteria | Bacteria | 344 | 3.29e-90 | NTclustered | gi|320149275|gb|CP001962.1| | 743525 | g83873 | i0 | 92.827 | 21.1943319838057 | 237 | 17 | 96 | 0 | 1 | 237 | 1388644 | 1388408 | Thermus scotoductus SA-01, complete genome | blastn | 5235 | 344 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 9884220 | 9884220 | PRJNA980587_P_NODE_78328_length_251_cov_1.258427_g77535_i0 | PRJNA980587 | 78328 | 251 | 1.258427 | 3.15865177 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 268 | 2.07e-67 | NTclustered | gi|2621701816|emb|OY759346.1| | 2026798 | g77535 | i0 | 86 | 111.91235059761 | 250 | 35 | 99 | 0 | 1 | 250 | 3600067 | 3599818 | MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 | blastn | 28090 | 268 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 12434715 | 12434715 | PRJNA980587_P_NODE_34150_length_407_cov_0.928144_g33357_i0 | PRJNA980587 | 34150 | 407 | 0.928144 | 3.77754608 | Deinococcus sp. QL22 | 2939437 | Bacteria | Bacteria | 667 | 0 | NTclustered | gi|2238957582|gb|CP097149.1| | 2939437 | g33357 | i0 | 96.985 | 206.223587223587 | 398 | 11 | 98 | 1 | 7 | 403 | 1508449 | 1508052 | Deinococcus sp. QL22 chromosome, complete genome | blastn | 83933 | 667 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. QL22 | ||
| 29741694 | 29741694 | PRJNA980587_P_NODE_83250_length_248_cov_0.880000_g82457_i0 | PRJNA980587 | 83250 | 248 | 0.88 | 2.1824 | Thermosipho sp. (in: thermotogales) | 1968895 | Bacteria | Bacteria | 67 | 4.16e-11 | NR | MBO8139004.1 | 1968895 | g82457 | i0 | 47.4 | 1.875 | 78 | 38 | 93.1 | 2 | 8 | 238 | 125 | 200 | MBO8139004.1 diaminopimelate epimerase [Thermosipho sp. (in: thermotogales)] | diamond | 465 | 67 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho sp. (in: thermotogales) | ||
| 31163383 | 31163383 | PRJNA980587_P_NODE_85335_length_247_cov_0.885057_g84542_i0 | PRJNA980587 | 85335 | 247 | 0.885057 | 2.18609079 | Fretibacterium sp. | 2699746 | Bacteria | Bacteria | 43.1 | 0.0282 | NR | MBQ9526865.1 | 2699746 | g84542 | i0 | 41.2 | 0.619433198380567 | 51 | 29 | 61.9 | 1 | 197 | 45 | 281 | 330 | MBQ9526865.1 DUF3536 domain-containing protein [Fretibacterium sp.] | diamond | 153 | 43.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. | ||
| 31643980 | 31643980 | PRJNA980587_P_NODE_53536_length_313_cov_1.587500_g52743_i0 | PRJNA980587 | 53536 | 313 | 1.5875 | 4.968875 | PVC group | 1783257 | Bacteria | Bacteria | 167 | 1.1599999999999999e-47 | NR | WP_350243929.1 | 309891 | g52743 | i0 | 73.5 | 65.4153354632588 | 102 | 27 | 97.8 | 0 | 308 | 3 | 181 | 282 | WP_350243929.1 acyl-CoA dehydrogenase [Deinococcus sonorensis] | diamond | 20475 | 167 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sonorensis | ||
| 32087091 | 32087091 | PRJNA980587_P_NODE_82018_length_249_cov_0.875000_g81225_i0 | PRJNA980587 | 82018 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 117 | 1.14e-29 | NR | WP_027463593.1 | 317577 | g81225 | i0 | 69.5 | 8.89156626506024 | 82 | 24 | 98.8 | 1 | 3 | 248 | 237 | 317 | WP_027463593.1 malate dehydrogenase [Deinococcus ficus] | diamond | 2214 | 117 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus |
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);;