contig_metadata
8 rows where bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3682009 | 3682009 | PRJNA561212_P_NODE_19183_length_259_cov_215.231183_g18972_i0 | PRJNA561212 | 19183 | 259 | 215.231183 | 557.44876397 | Deinococcus | 1298 | Bacteria | Bacteria | 217 | 7.9e-52 | NTclustered | gi|485099143|ref|NR_102538.1| | 432329 | g18972 | i0 | 83.817 | 386.274131274131 | 241 | 25 | 89 | 10 | 13 | 243 | 256 | 20 | Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence | blastn | 100045 | 217 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 6923351 | 6923351 | PRJNA561212_P_NODE_16286_length_280_cov_1.429952_g16075_i0 | PRJNA561212 | 16286 | 280 | 1.429952 | 4.0038656 | Deinococcus sp. KNUC1210 | 2917691 | Bacteria | Bacteria | 333 | 8.23e-87 | NTclustered | gi|2197029603|gb|CP092190.1| | 2917691 | g16075 | i0 | 93.392 | 196.821428571429 | 227 | 12 | 81 | 2 | 20 | 245 | 1426655 | 1426431 | Deinococcus sp. KNUC1210 chromosome, complete genome | blastn | 55110 | 333 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. KNUC1210 | ||
| 14574195 | 14574195 | PRJNA561212_P_NODE_10132_length_346_cov_11.040293_g9921_i0 | PRJNA561212 | 10132 | 346 | 11.040293 | 38.19941378 | Deinococcus sp. KNUC1210 | 2917691 | Bacteria | Bacteria | 440 | 5.979999999999997e-119 | NTclustered | gi|2197029603|gb|CP092190.1| | 2917691 | g9921 | i0 | 90.208 | 212.661849710983 | 337 | 33 | 97 | 0 | 10 | 346 | 1427412 | 1427076 | Deinococcus sp. KNUC1210 chromosome, complete genome | blastn | 73581 | 440 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. KNUC1210 | ||
| 20947425 | 20947425 | PRJNA561212_P_NODE_1337_length_934_cov_27.349593_g1171_i0 | PRJNA561212 | 1337 | 934 | 27.349593 | 255.44519862 | Deinococcus maricopensis | 309887 | Bacteria | Bacteria | 547 | 9.879999999999999e-151 | NTclustered | gi|319753907|gb|CP002454.1| | 709986 | g1171 | i0 | 83.07 | 135.541755888651 | 632 | 78 | 99 | 27 | 312 | 925 | 640709 | 640089 | Deinococcus maricopensis DSM 21211, complete genome | blastn | 126596 | 547 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus maricopensis | ||
| 28626780 | 28626780 | PRJNA561212_P_NODE_8147_length_384_cov_1.877814_g7936_i0 | PRJNA561212 | 8147 | 384 | 1.877814 | 7.21080576 | Deinococcus koreensis | 2054903 | Bacteria | Bacteria | 47 | 0.00558 | NR | WP_103312724.1 | 2054903 | g7936 | i0 | 46.6 | 0.8671875 | 58 | 26 | 45.3 | 2 | 368 | 195 | 306 | 358 | WP_103312724.1 elongation factor G [Deinococcus koreensis] | diamond | 333 | 47 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus koreensis | ||
| 29384419 | 29384419 | PRJNA561212_P_NODE_22609_length_248_cov_1.285714_g22398_i0 | PRJNA561212 | 22609 | 248 | 1.285714 | 3.18857072 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 47 | 0.00117 | NR | HLV13062.1 | 2026798 | g22398 | i0 | 43.9 | 1.53629032258065 | 57 | 31 | 69 | 1 | 179 | 9 | 83 | 138 | HLV13062.1 TspO/MBR family protein [Trueperaceae bacterium] | diamond | 381 | 47 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 29731397 | 29731397 | PRJNA561212_P_NODE_9250_length_362_cov_1.231834_g9039_i0 | PRJNA561212 | 9250 | 362 | 1.231834 | 4.45923908 | Fervidobacterium pennivorans | 93466 | Bacteria | Bacteria | 51.6 | 1.03e-4 | NR | MFN3328904.1 | 93466 | g9039 | i0 | 40.7 | 0.671270718232044 | 81 | 39 | 60.5 | 3 | 6 | 224 | 81 | 160 | MFN3328904.1 LIM domain-containing protein [Fervidobacterium pennivorans] | diamond | 243 | 51.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium pennivorans | ||
| 30124385 | 30124385 | PRJNA561212_P_NODE_11592_length_326_cov_0.889328_g11381_i0 | PRJNA561212 | 11592 | 326 | 0.889328 | 2.89920928 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.01e-26 | NR | WP_229365136.1 | 274 | g11381 | i0 | 61.2 | 10.4539877300613 | 103 | 30 | 94.8 | 2 | 317 | 9 | 76 | 168 | WP_229365136.1 S8 family peptidase [Thermus thermophilus] | diamond | 3408 | 112 | 0.991071428571429 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus |
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);;