contig_metadata
9 rows where bioproject = "PRJNA608894" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3135979 | 3135979 | PRJNA608894_P_NODE_18943_length_476_cov_1.744417_g18447_i0 | PRJNA608894 | 18943 | 476 | 1.744417 | 8.30342492 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 249 | 4.42e-77 | NR | MCB1222954.1 | 2053577 | g18447 | i0 | 74.1 | 4.97899159663866 | 158 | 41 | 99.6 | 0 | 476 | 3 | 121 | 278 | MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.] | diamond | 2370 | 249 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 4413152 | 4413152 | PRJNA608894_P_NODE_4424_length_1473_cov_10.222143_g2531_i2 | PRJNA608894 | 4424 | 1473 | 10.222143 | 150.57216639 | Deinococcus grandis | 57498 | Bacteria | Bacteria | 2058 | 0 | NTclustered | gi|1751874559|dbj|AP021851.1| | 57498 | g2531 | i2 | 92.011 | 323.082824168364 | 1477 | 101 | 99 | 12 | 4 | 1473 | 116907 | 115441 | Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome | blastn | 475901 | 2058 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 5689478 | 5689478 | PRJNA608894_P_NODE_54465_length_246_cov_2.190751_g53966_i0 | PRJNA608894 | 54465 | 246 | 2.190751 | 5.38924746 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 204 | 5.799999999999998e-48 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g53966 | i0 | 88.372 | 5.67479674796748 | 172 | 17 | 69 | 3 | 77 | 246 | 1060450 | 1060280 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 1396 | 204 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 5689519 | 5689519 | PRJNA608894_P_NODE_57285_length_244_cov_0.900585_g56786_i0 | PRJNA608894 | 57285 | 244 | 0.900585 | 2.1974274 | Deinococcus fonticola | 2528713 | Bacteria | Bacteria | 159 | 2.5299999999999992e-43 | NR | WP_135230405.1 | 2528713 | g56786 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 244 | 2 | 160 | 240 | WP_135230405.1 RelA/SpoT family protein [Deinococcus fonticola] | diamond | 243 | 159 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus fonticola | ||
| 13339734 | 13339734 | PRJNA608894_P_NODE_47291_length_258_cov_1.691892_g46792_i0 | PRJNA608894 | 47291 | 258 | 1.691892 | 4.36508136 | Thermus sp. NEB1569 | 2918899 | Bacteria | Bacteria | 477 | 3.2699999999999985e-130 | NTclustered | gi|2199052145|gb|CP092445.1| | 2918899 | g46792 | i0 | 100 | 32.406976744186 | 258 | 0 | 100 | 0 | 1 | 258 | 636875 | 637132 | Thermus sp. NEB1569 chromosome, complete genome | blastn | 8361 | 477 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. NEB1569 | ||
| 13339777 | 13339777 | PRJNA608894_P_NODE_49531_length_252_cov_1.195531_g49032_i0 | PRJNA608894 | 49531 | 252 | 1.195531 | 3.01273812 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 438 | 1.5e-118 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g49032 | i0 | 98.016 | 101.107142857143 | 252 | 5 | 100 | 0 | 1 | 252 | 1840352 | 1840603 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 25479 | 438 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 20987963 | 20987963 | PRJNA608894_P_NODE_45777_length_263_cov_1.621053_g45278_i0 | PRJNA608894 | 45777 | 263 | 1.621053 | 4.26336939 | Deinococcus gobiensis | 502394 | Bacteria | Bacteria | 315 | 2.77e-81 | NTclustered | gi|379998737|gb|CP002191.1| | 745776 | g45278 | i0 | 88.213 | 11.5893536121673 | 263 | 31 | 100 | 0 | 1 | 263 | 2287044 | 2287306 | Deinococcus gobiensis I-0, complete genome | blastn | 3048 | 315 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus gobiensis | ||
| 29258808 | 29258808 | PRJNA608894_P_NODE_53889_length_247_cov_0.885057_g53390_i0 | PRJNA608894 | 53889 | 247 | 0.885057 | 2.18609079 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 142 | 2.1599999999999996e-37 | NR | WP_353542509.1 | 457454 | g53390 | i0 | 100 | 0.801619433198381 | 66 | 0 | 80.2 | 0 | 2 | 199 | 596 | 661 | WP_353542509.1 AfsR/SARP family transcriptional regulator [Deinococcus xinjiangensis] | diamond | 198 | 142 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 31185691 | 31185691 | PRJNA608894_P_NODE_44675_length_267_cov_1.371134_g44176_i0 | PRJNA608894 | 44675 | 267 | 1.371134 | 3.66092778 | Deinococcus cavernae | 2320857 | Bacteria | Bacteria | 89 | 2.21e-19 | NR | WP_158591659.1 | 2320857 | g44176 | i0 | 97.8 | 0.50561797752809 | 45 | 1 | 50.6 | 0 | 229 | 95 | 1 | 45 | WP_158591659.1 cytochrome c [Deinococcus cavernae] | diamond | 135 | 89 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cavernae |
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);;