contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508536 | 508536 | PRJNA541476_P_NODE_16881_length_297_cov_10.312500_g16675_i0 | PRJNA541476 | 16881 | 297 | 10.3125 | 30.628125 | Deinococcus proteolyticus | 55148 | Bacteria | Bacteria | 499 | 8.2e-137 | NTclustered | gi|324314064|gb|CP002536.1| | 693977 | g16675 | i0 | 96.98 | 207.542087542088 | 298 | 8 | 100 | 1 | 1 | 297 | 174031 | 173734 | Deinococcus proteolyticus MRP, complete genome | blastn | 61640 | 499 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 1783801 | 1783801 | PRJNA541476_P_NODE_12062_length_335_cov_2.297710_g11856_i0 | PRJNA541476 | 12062 | 335 | 2.29771 | 7.6973285 | Deinococcus radiophilus | 32062 | Bacteria | Bacteria | 326 | 1.69e-84 | NTclustered | gi|2152123021|gb|CP086380.1| | 32062 | g11856 | i0 | 85.897 | 62.8149253731343 | 312 | 36 | 92 | 8 | 25 | 333 | 940098 | 939792 | Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome | blastn | 21043 | 326 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiophilus | ||
| 2394023 | 2394023 | PRJNA541476_P_NODE_38002_length_244_cov_0.766082_g37796_i0 | PRJNA541476 | 38002 | 244 | 0.766082 | 1.86924008 | Truepera | 332248 | Bacteria | Bacteria | 200 | 7.4299999999999985e-47 | NTclustered | gi|2573973991|gb|CP133611.1| | 332249 | g37796 | i0 | 82.128 | 4.65983606557377 | 235 | 40 | 96 | 2 | 1 | 234 | 843291 | 843058 | Truepera radiovictrix strain CIP 108686 chromosome, complete genome | blastn | 1137 | 200 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 6222124 | 6222124 | PRJNA541476_P_NODE_11945_length_336_cov_4.589354_g11739_i0 | PRJNA541476 | 11945 | 336 | 4.589354 | 15.42022944 | Deinococcus | 1298 | Bacteria | Bacteria | 374 | 5.959999999999998e-99 | NTclustered | gi|2152123021|gb|CP086380.1| | 32062 | g11739 | i0 | 86.804 | 38.3779761904762 | 341 | 37 | 100 | 8 | 1 | 336 | 2087031 | 2086694 | Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome | blastn | 12895 | 374 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiophilus | ||
| 7496653 | 7496653 | PRJNA541476_P_NODE_13926_length_318_cov_1.081633_g13720_i0 | PRJNA541476 | 13926 | 318 | 1.081633 | 3.43959294 | Deinococcus | 1298 | Bacteria | Bacteria | 549 | 8.669999999999997e-152 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g13720 | i0 | 97.799 | 36.1194968553459 | 318 | 7 | 100 | 0 | 1 | 318 | 426506 | 426823 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 11486 | 549 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 18970046 | 18970046 | PRJNA541476_P_NODE_18635_length_288_cov_5.986047_g18429_i0 | PRJNA541476 | 18635 | 288 | 5.986047 | 17.23981536 | Deinococcus | 1298 | Bacteria | Bacteria | 527 | 3.63e-145 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g18429 | i0 | 99.653 | 193.850694444444 | 288 | 1 | 100 | 0 | 1 | 288 | 1636414 | 1636127 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 55829 | 532 | 0.990601503759398 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 24070513 | 24070513 | PRJNA541476_P_NODE_25119_length_262_cov_5.015873_g24913_i0 | PRJNA541476 | 25119 | 262 | 5.015873 | 13.14158726 | Deinococcus | 1298 | Bacteria | Bacteria | 484 | 1.99e-132 | NTclustered | gi|2113031129|gb|OK500351.1| | 47478 | g24913 | i0 | 100 | 104 | 262 | 0 | 100 | 0 | 1 | 262 | 482 | 743 | Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence | blastn | 27248 | 484 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. |
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);;