contig_metadata
6 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2339213 | 2339213 | PRJNA312615_P_NODE_39582_length_195_cov_1.273973_g39431_i0 | PRJNA312615 | 39582 | 195 | 1.273973 | 2.48424735 | Deinococcus | 1298 | Bacteria | Bacteria | 350 | 5.34e-92 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g39431 | i0 | 98.98 | 198.594871794872 | 196 | 0 | 100 | 2 | 1 | 195 | 2341747 | 2341553 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 38726 | 350 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 4891629 | 4891629 | PRJNA312615_P_NODE_22544_length_257_cov_1.048077_g22393_i0 | PRJNA312615 | 22544 | 257 | 1.048077 | 2.69355789 | root | 1 | Root_unresolved | Root_unresolved | 436 | 5.52e-118 | NTclustered | gi|145033|gb|M21413.1|DEIRGDA | 1299 | g22393 | i0 | 97.287 | 132.821011673152 | 258 | 5 | 100 | 2 | 1 | 257 | 850 | 594 | D.radiodurans 16S ribosomal RNA gene | blastn | 34135 | 436 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiodurans | ||
| 11857217 | 11857217 | PRJNA312615_P_NODE_49710_length_169_cov_1.616667_g49559_i0 | PRJNA312615 | 49710 | 169 | 1.616667 | 2.73216723 | Thermus thermophilus | 274 | Bacteria | Bacteria | 217 | 4.73e-52 | NTclustered | gi|2074862630|dbj|AP024931.1| | 274 | g49559 | i0 | 91.358 | 7.1715976331360904 | 162 | 8 | 93 | 4 | 1 | 157 | 148926 | 149086 | Thermus thermophilus AA2-2 plasmid pAA2-2c DNA, complete sequence | blastn | 1212 | 217 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 14407643 | 14407643 | PRJNA312615_P_NODE_59132_length_153_cov_2.644231_g58981_i0 | PRJNA312615 | 59132 | 153 | 2.644231 | 4.04567343 | Thermus parvatiensis | 456163 | Bacteria | Bacteria | 244 | 1.93e-60 | NTclustered | gi|982539283|gb|CP014141.1| | 456163 | g58981 | i0 | 95.425 | 38.6928104575163 | 153 | 7 | 100 | 0 | 1 | 153 | 1595129 | 1594977 | Thermus parvatiensis strain RL, complete genome | blastn | 5920 | 244 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus parvatiensis | ||
| 18230201 | 18230201 | PRJNA312615_P_NODE_46735_length_177_cov_1.218750_g46584_i0 | PRJNA312615 | 46735 | 177 | 1.21875 | 2.1571875 | Deinococcus radiophilus | 32062 | Bacteria | Bacteria | 254 | 3.82e-63 | NTclustered | gi|2152123021|gb|CP086380.1| | 32062 | g46584 | i0 | 92.655 | 194.457627118644 | 177 | 11 | 99 | 2 | 2 | 176 | 1814848 | 1815024 | Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome | blastn | 34419 | 254 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiophilus | ||
| 30611255 | 30611255 | PRJNA312615_P_NODE_13513_length_335_cov_2.104895_g13362_i0 | PRJNA312615 | 13513 | 335 | 2.104895 | 7.05139825 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 45.8 | 0.00722 | NR | MCL4407461.1 | 2053689 | g13362 | i0 | 48.1 | 0.483582089552239 | 54 | 26 | 46.6 | 1 | 230 | 75 | 107 | 160 | MCL4407461.1 DUF4382 domain-containing protein [Thermotogota bacterium] | diamond | 162 | 45.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium |
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);;