contig_metadata
12 rows where bioproject = "PRJNA493244", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1729616 | 1729616 | PRJNA493244_P_NODE_1066982_length_378_cov_5.675079_g1043865_i0 | PRJNA493244 | 1066982 | 378 | 5.675079 | 21.45179862 | Thermotoga profunda | 1508420 | Bacteria | Bacteria | 134 | 1.25e-26 | NTclustered | gi|597439398|dbj|AP014510.1| | 1408160 | g1043865 | i0 | 91 | 23.5449735449735 | 100 | 8 | 26 | 1 | 123 | 222 | 2163821 | 2163723 | Thermotoga profunda AZM34c06 DNA, complete genome | blastn | 8900 | 134 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga profunda | ||
| 13853416 | 13853416 | PRJNA493244_P_NODE_1464271_length_251_cov_3.363158_g1441146_i0 | PRJNA493244 | 1464271 | 251 | 3.363158 | 8.44152658 | Bacteria | 2 | Bacteria | Bacteria | 453 | 5.34e-123 | NTclustered | gi|2793119032|gb|CP126501.1| | 44754 | g1441146 | i0 | 99.203 | 30 | 251 | 2 | 100 | 0 | 1 | 251 | 769975 | 770225 | Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome | blastn | 7530 | 453 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium gondwanense | ||
| 19581535 | 19581535 | PRJNA493244_P_NODE_1436636_length_258_cov_7.791878_g1413511_i0 | PRJNA493244 | 1436636 | 258 | 7.791878 | 20.10304524 | Fervidobacterium nodosum | 2424 | Bacteria | Bacteria | 414 | 2.5999999999999995e-111 | NTclustered | gi|154152641|gb|CP000771.1| | 381764 | g1413511 | i0 | 99.13 | 0.891472868217054 | 230 | 2 | 89 | 0 | 19 | 248 | 680374 | 680603 | Fervidobacterium nodosum Rt17-B1, complete genome | blastn | 230 | 414 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium nodosum | ||
| 26886831 | 26886831 | PRJNA493244_P_NODE_1559401_length_229_cov_2.214286_g1536276_i0 | PRJNA493244 | 1559401 | 229 | 2.214286 | 5.07071494 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 159 | 4.19e-45 | NR | MEN6515317.1 | 1871331 | g1536276 | i0 | 98.7 | 3.9825327510917 | 76 | 1 | 99.6 | 0 | 2 | 229 | 169 | 244 | MEN6515317.1 ABC transporter substrate-binding protein [Fervidobacterium sp.] | diamond | 912 | 159 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27060795 | 27060795 | PRJNA493244_P_NODE_1441902_length_257_cov_1.959184_g1418777_i0 | PRJNA493244 | 1441902 | 257 | 1.959184 | 5.03510288 | Thermotogales | 2419 | Bacteria | Bacteria | 160 | 2.2799999999999993e-43 | NR | HRD21027.1 | 1871331 | g1418777 | i0 | 98.8 | 2.83657587548638 | 81 | 0 | 93.4 | 1 | 241 | 2 | 786 | 866 | HRD21027.1 hypothetical protein [Fervidobacterium sp.] | diamond | 729 | 160 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27518864 | 27518864 | PRJNA493244_P_NODE_713423_length_560_cov_1.801603_g691089_i0 | PRJNA493244 | 713423 | 560 | 1.801603 | 10.0889768 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 175 | 9.66e-50 | NR | MDM7320303.1 | 1871331 | g691089 | i0 | 81.2 | 0.541071428571429 | 101 | 19 | 54.1 | 0 | 245 | 547 | 17 | 117 | MDM7320303.1 DEAD/DEAH box helicase [Fervidobacterium sp.] | diamond | 303 | 175 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 27992598 | 27992598 | PRJNA493244_P_NODE_890165_length_458_cov_11.768262_g867224_i0 | PRJNA493244 | 890165 | 458 | 11.768262 | 53.89863996 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 103 | 1.18e-22 | NR | HQQ18382.1 | 1871331 | g867224 | i0 | 72.5 | 0.524017467248908 | 80 | 22 | 52.4 | 0 | 447 | 208 | 435 | 514 | HQQ18382.1 ATP-binding cassette domain-containing protein [Fervidobacterium sp.] | diamond | 240 | 103 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28434519 | 28434519 | PRJNA493244_P_NODE_1699586_length_204_cov_0.895105_g1676461_i0 | PRJNA493244 | 1699586 | 204 | 0.895105 | 1.8260142 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 52.8 | 2.79e-6 | NR | MDM7320314.1 | 1871331 | g1676461 | i0 | 80.8 | 0.382352941176471 | 26 | 5 | 38.2 | 0 | 80 | 3 | 14 | 39 | MDM7320314.1 hypothetical protein [Fervidobacterium sp.] | diamond | 78 | 52.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 28750212 | 28750212 | PRJNA493244_P_NODE_1583927_length_224_cov_1.441718_g1560802_i0 | PRJNA493244 | 1583927 | 224 | 1.441718 | 3.22944832 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 130 | 1.02e-34 | NR | MDM7321177.1 | 1871331 | g1560802 | i0 | 89.9 | 0.924107142857143 | 69 | 7 | 92.4 | 0 | 18 | 224 | 291 | 359 | MDM7321177.1 hypothetical protein [Fervidobacterium sp.] | diamond | 207 | 130 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30202596 | 30202596 | PRJNA493244_P_NODE_1587772_length_223_cov_1.580247_g1564647_i0 | PRJNA493244 | 1587772 | 223 | 1.580247 | 3.52395081 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 101 | 2.86e-24 | NR | MDM7321175.1 | 1871331 | g1564647 | i0 | 86.4 | 0.79372197309417 | 59 | 8 | 79.4 | 0 | 179 | 3 | 109 | 167 | MDM7321175.1 hypothetical protein [Fervidobacterium sp.] | diamond | 177 | 101 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30518801 | 30518801 | PRJNA493244_P_NODE_1709453_length_203_cov_0.901408_g1686328_i0 | PRJNA493244 | 1709453 | 203 | 0.901408 | 1.82985824 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 122 | 8.2e-34 | NR | MDM7321179.1 | 1871331 | g1686328 | i0 | 86.8 | 1.00492610837438 | 68 | 8 | 99 | 1 | 3 | 203 | 45 | 112 | MDM7321179.1 hypothetical protein [Fervidobacterium sp.] | diamond | 204 | 122 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 31846406 | 31846406 | PRJNA493244_P_NODE_1747177_length_186_cov_5.288000_g1724052_i0 | PRJNA493244 | 1747177 | 186 | 5.288 | 9.83568 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 103 | 1.4500000000000002e-26 | NR | MDM7320281.1 | 1871331 | g1724052 | i0 | 88.1 | 0.951612903225806 | 59 | 7 | 95.2 | 0 | 10 | 186 | 1 | 59 | MDM7320281.1 hypothetical protein [Fervidobacterium sp.] | diamond | 177 | 103 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium 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);;