contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA766854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8398178 | 8398178 | PRJNA766854_P_NODE_767_length_460_cov_1.109049_g658_i0 | PRJNA766854 | 767 | 460 | 1.109049 | 5.1016254 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 71.3 | 1.23e-7 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g658 | i0 | 89.286 | 0.121739130434783 | 56 | 6 | 12 | 0 | 197 | 252 | 1552203 | 1552148 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 56 | 71.3 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 11409776 | 11409776 | PRJNA766854_P_NODE_1549_length_333_cov_3.282895_g1424_i0 | PRJNA766854 | 1549 | 333 | 3.282895 | 10.93204035 | Fervidobacteriaceae | 1643950 | Bacteria | Bacteria | 122 | 2.3599999999999998e-23 | NTclustered | gi|61657861|emb|AJ876542.1| | 2424 | g1424 | i0 | 94.872 | 46 | 78 | 4 | 44 | 0 | 256 | 333 | 96 | 19 | Fervidobacterium nodosum partial 23S rRNA gene | blastn | 15318 | 122 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium nodosum | ||
| 16508870 | 16508870 | PRJNA766854_P_NODE_1713_length_318_cov_1.920415_g1588_i0 | PRJNA766854 | 1713 | 318 | 1.920415 | 6.1069197 | Deinococcus | 1298 | Bacteria | Bacteria | 119 | 2.9e-22 | NTclustered | gi|730601855|gb|CP010028.1| | 57497 | g1588 | i0 | 100 | 70.3584905660377 | 64 | 0 | 20 | 0 | 255 | 318 | 70536 | 70599 | Deinococcus swuensis strain DY59, complete genome | blastn | 22374 | 119 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 17323287 | 17323287 | PRJNA766854_P_NODE_2374_length_279_cov_3.428000_g2248_i0 | PRJNA766854 | 2374 | 279 | 3.428 | 9.56412 | Deinococcus actinosclerus | 1768108 | Bacteria | Bacteria | 438 | 1.6899999999999996e-118 | NTclustered | gi|972944657|gb|CP013910.1| | 1768108 | g2248 | i0 | 94.982 | 481.598566308244 | 279 | 14 | 100 | 0 | 1 | 279 | 74588 | 74310 | Deinococcus actinosclerus strain BM2 chromosome, complete genome | blastn | 134366 | 438 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus actinosclerus | ||
| 18596652 | 18596652 | PRJNA766854_P_NODE_1615_length_326_cov_4.781145_g1490_i0 | PRJNA766854 | 1615 | 326 | 4.781145 | 15.5865327 | Thermosipho ferrireducens | 2571116 | Bacteria | Bacteria | 156 | 2.27e-33 | NTclustered | gi|2006729518|gb|CP071446.1| | 2571116 | g1490 | i0 | 96.774 | 54.9110429447853 | 93 | 3 | 44 | 0 | 173 | 265 | 420069 | 420161 | Thermosipho ferrireducens strain JL129W03 chromosome, complete genome | blastn | 17901 | 156 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho ferrireducens | ||
| 19057699 | 19057699 | PRJNA766854_P_NODE_1415_length_349_cov_2.856250_g1290_i0 | PRJNA766854 | 1415 | 349 | 2.85625 | 9.9683125 | Fervidobacterium | 2422 | Bacteria | Bacteria | 147 | 1.47e-30 | NTclustered | gi|2793125101|gb|CP126499.1| | 2423 | g1290 | i0 | 97.674 | 47.4842406876791 | 86 | 0 | 45 | 2 | 3 | 87 | 1622366 | 1622282 | Fervidobacterium islandicum strain H-21 chromosome, complete genome | blastn | 16572 | 147 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium islandicum | ||
| 22422246 | 22422246 | PRJNA766854_P_NODE_1598_length_328_cov_3.207358_g1473_i0 | PRJNA766854 | 1598 | 328 | 3.207358 | 10.52013424 | Fervidobacterium gondwanense | 44754 | Bacteria | Bacteria | 196 | 1.35e-45 | NTclustered | gi|2793121053|gb|CP126498.1| | 44754 | g1473 | i0 | 90.26 | 93.8932926829268 | 154 | 9 | 77 | 5 | 3 | 153 | 973907 | 973757 | Fervidobacterium gondwanense strain 13770 chromosome, complete genome | blastn | 30797 | 196 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium gondwanense |
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);;