contig_metadata
16 rows where bioproject = "PRJNA966993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6045101 | 6045101 | PRJNA966993_P_NODE_100125_length_237_cov_2.792683_g99673_i0 | PRJNA966993 | 100125 | 237 | 2.792683 | 6.61865871 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 300 | 6.88e-77 | NTclustered | gi|2905211496|gb|CP179945.1| | 3385567 | g99673 | i0 | 89.54 | 24.1392405063291 | 239 | 21 | 100 | 3 | 1 | 237 | 1245697 | 1245461 | Deinococcus sp. VB343 chromosome 1, complete sequence | blastn | 5721 | 300 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 6045477 | 6045477 | PRJNA966993_P_NODE_52505_length_299_cov_1.548673_g52053_i0 | PRJNA966993 | 52505 | 299 | 1.548673 | 4.63053227 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 553 | 6.25e-153 | NTclustered | gi|94554390|gb|CP000359.1| | 319795 | g52053 | i0 | 100 | 231.755852842809 | 299 | 0 | 100 | 0 | 1 | 299 | 2375574 | 2375276 | Deinococcus geothermalis DSM 11300, complete genome | blastn | 69295 | 553 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 8595487 | 8595487 | PRJNA966993_P_NODE_81867_length_251_cov_1.730337_g81415_i0 | PRJNA966993 | 81867 | 251 | 1.730337 | 4.34314587 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 453 | 5.34e-123 | NTclustered | gi|2905211496|gb|CP179945.1| | 3385567 | g81415 | i0 | 99.203 | 20.5019920318725 | 251 | 2 | 100 | 0 | 1 | 251 | 1728247 | 1727997 | Deinococcus sp. VB343 chromosome 1, complete sequence | blastn | 5146 | 453 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 12744902 | 12744902 | PRJNA966993_P_NODE_70530_length_269_cov_2.020408_g70078_i0 | PRJNA966993 | 70530 | 269 | 2.020408 | 5.43489752 | Deinococcus | 1298 | Bacteria | Bacteria | 486 | 5.699999999999999e-133 | NTclustered | gi|2264081587|gb|CP094462.1| | 1299 | g70078 | i0 | 99.257 | 15 | 269 | 2 | 100 | 0 | 1 | 269 | 546758 | 546490 | Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence | blastn | 4035 | 486 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiodurans | ||
| 15293565 | 15293565 | PRJNA966993_P_NODE_46132_length_318_cov_1.551020_g45680_i0 | PRJNA966993 | 46132 | 318 | 1.55102 | 4.9322436 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 165 | 5.65e-46 | NR | MCB1222954.1 | 2053577 | g45680 | i0 | 74.3 | 1.9811320754717 | 105 | 27 | 99.1 | 0 | 1 | 315 | 115 | 219 | MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.] | diamond | 630 | 165 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 16245253 | 16245253 | PRJNA966993_P_NODE_72413_length_266_cov_2.787565_g71961_i0 | PRJNA966993 | 72413 | 266 | 2.787565 | 7.4149229 | Thermotoga caldifontis | 1508419 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|597439397|dbj|AP014509.1| | 1408159 | g71961 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 83 | 110 | 829004 | 829031 | Thermotoga caldifontis AZM44c09 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga caldifontis | ||
| 17843223 | 17843223 | PRJNA966993_P_NODE_87914_length_248_cov_0.880000_g87462_i0 | PRJNA966993 | 87914 | 248 | 0.88 | 2.1824 | Deinococcus | 1298 | Bacteria | Bacteria | 438 | 1.4699999999999995e-118 | NTclustered | gi|2706837832|gb|CP149782.1| | 3112952 | g87462 | i0 | 98.79 | 14.9193548387097 | 248 | 0 | 100 | 1 | 1 | 248 | 1162850 | 1162606 | Deinococcus sp. VB142 chromosome 1, complete sequence | blastn | 3700 | 438 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 18794065 | 18794065 | PRJNA966993_P_NODE_56075_length_290_cov_1.700461_g55623_i0 | PRJNA966993 | 56075 | 290 | 1.700461 | 4.9313369 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 508 | 1.33e-139 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g55623 | i0 | 98.276 | 192.572413793103 | 290 | 5 | 100 | 0 | 1 | 290 | 2342310 | 2342021 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 55846 | 508 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 25492125 | 25492125 | PRJNA966993_P_NODE_65700_length_276_cov_2.147783_g65248_i0 | PRJNA966993 | 65700 | 276 | 2.147783 | 5.92788108 | Deinococcus | 1298 | Bacteria | Bacteria | 510 | 3.48e-140 | NTclustered | gi|2706840606|gb|CP149783.1| | 3112952 | g65248 | i0 | 100 | 17.768115942029 | 276 | 0 | 100 | 0 | 1 | 276 | 121519 | 121794 | Deinococcus sp. VB142 chromosome 2, complete sequence | blastn | 4904 | 510 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 27089234 | 27089234 | PRJNA966993_P_NODE_84462_length_250_cov_0.870056_g84010_i0 | PRJNA966993 | 84462 | 250 | 0.870056 | 2.17514 | Calidithermus timidus | 307124 | Bacteria | Bacteria | 160 | 6.25e-46 | NR | WP_018466515.1 | 307124 | g84010 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 249 | 1 | 167 | 249 | WP_018466515.1 FAD-binding protein [Calidithermus timidus] | diamond | 249 | 160 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus timidus | ||
| 29173484 | 29173484 | PRJNA966993_P_NODE_80189_length_254_cov_1.348066_g79737_i0 | PRJNA966993 | 80189 | 254 | 1.348066 | 3.42408764 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 158 | 2.64e-46 | NR | WP_386842737.1 | 536443 | g79737 | i0 | 100 | 0.992125984251969 | 84 | 0 | 99.2 | 0 | 3 | 254 | 24 | 107 | WP_386842737.1 hypothetical protein [Deinococcus taklimakanensis] | diamond | 252 | 158 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis | ||
| 29899685 | 29899685 | PRJNA966993_P_NODE_65111_length_277_cov_1.818627_g64659_i0 | PRJNA966993 | 65111 | 277 | 1.818627 | 5.03759679 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 72 | 9.18e-13 | NR | MEG1502261.1 | 2053624 | g64659 | i0 | 62.5 | 0.693140794223827 | 64 | 22 | 67.1 | 1 | 187 | 2 | 1 | 64 | MEG1502261.1 hypothetical protein [Synergistaceae bacterium] | diamond | 192 | 72 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 32112309 | 32112309 | PRJNA966993_P_NODE_49258_length_309_cov_1.631356_g48806_i0 | PRJNA966993 | 49258 | 309 | 1.631356 | 5.04089004 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 114 | 3.3700000000000004e-27 | NR | CAA9578840.1 | 543023 | g48806 | i0 | 57 | 2.69902912621359 | 93 | 38 | 90.3 | 1 | 31 | 309 | 70 | 160 | CAA9578840.1 MAG: Beta-lactamase class C-like and penicillin binding proteins (PBPs) superfamily / DUF3471 domain [uncultured Truepera sp.] | diamond | 834 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 32112314 | 32112314 | PRJNA966993_P_NODE_56258_length_290_cov_1.382488_g55806_i0 | PRJNA966993 | 56258 | 290 | 1.382488 | 4.0092152 | Deinococcus fonticola | 2528713 | Bacteria | Bacteria | 189 | 6.229999999999999e-56 | NR | WP_135229030.1 | 2528713 | g55806 | i0 | 99 | 0.993103448275862 | 96 | 1 | 99.3 | 0 | 3 | 290 | 110 | 205 | WP_135229030.1 replication initiator protein A [Deinococcus fonticola] | diamond | 288 | 189 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus fonticola | ||
| 32397189 | 32397189 | PRJNA966993_P_NODE_91839_length_245_cov_2.046512_g91387_i0 | PRJNA966993 | 91839 | 245 | 2.046512 | 5.0139544 | Deinococcus soli (ex Cha et al. 2 | 1309411 | Bacteria | Bacteria | 124 | 3.64e-32 | NR | WP_188846534.1 | 1309411 | g91387 | i0 | 82.7 | 0.991836734693878 | 81 | 13 | 99.2 | 1 | 3 | 245 | 170 | 249 | WP_188846534.1 hypothetical protein [Deinococcus soli (ex Cha et al. 2016)] | diamond | 243 | 124 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 32838613 | 32838613 | PRJNA966993_P_NODE_92920_length_245_cov_0.895349_g92468_i0 | PRJNA966993 | 92920 | 245 | 0.895349 | 2.19360505 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 114 | 4.1e-30 | NR | AXH00669.1 | 980427 | g92468 | i0 | 68.8 | 1.95918367346939 | 80 | 25 | 98 | 0 | 6 | 245 | 18 | 97 | AXH00669.1 hypothetical protein DVJ83_16060 [Deinococcus wulumuqiensis] | diamond | 480 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis |
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);;