contig_metadata
12 rows where bioproject = "PRJNA898105" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6348226 | 6348226 | PRJNA898105_P_NODE_4785_length_276_cov_1.320197_g4585_i0 | PRJNA898105 | 4785 | 276 | 1.320197 | 3.64374372 | Thermus | 270 | Bacteria | Bacteria | 499 | 7.54e-137 | NTclustered | gi|320149275|gb|CP001962.1| | 743525 | g4585 | i0 | 99.275 | 56.1268115942029 | 276 | 2 | 100 | 0 | 1 | 276 | 1166085 | 1166360 | Thermus scotoductus SA-01, complete genome | blastn | 15491 | 499 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 7251965 | 7251965 | PRJNA898105_P_NODE_4486_length_281_cov_1.413462_g4286_i0 | PRJNA898105 | 4486 | 281 | 1.413462 | 3.97182822 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 442 | 1.3199999999999993e-119 | NTclustered | gi|389546625|gb|JQ401553.1| | 158789 | g4286 | i0 | 95.018 | 105.174377224199 | 281 | 14 | 100 | 0 | 1 | 281 | 638 | 358 | Uncultured Deinococcus sp. clone CNY_01678 16S ribosomal RNA gene, partial sequence | blastn | 29554 | 442 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 8526635 | 8526635 | PRJNA898105_P_NODE_3267_length_323_cov_2.208000_g3067_i0 | PRJNA898105 | 3267 | 323 | 2.208 | 7.13184 | Jonquetella anthropi | 428712 | Bacteria | Bacteria | 398 | 3.3799999999999996e-106 | NTclustered | gi|194410714|gb|EU840722.1| | 428712 | g3067 | i0 | 98.661 | 975.628482972136 | 224 | 3 | 69 | 0 | 1 | 224 | 2406 | 2183 | Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence | blastn | 315128 | 398 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi | ||
| 9801734 | 9801734 | PRJNA898105_P_NODE_6548_length_249_cov_0.875000_g6348_i0 | PRJNA898105 | 6548 | 249 | 0.875 | 2.17875 | Deinococcus peraridilitoris | 432329 | Bacteria | Bacteria | 99.4 | 2.4399999999999999e-23 | NR | WP_015235812.1 | 432329 | g6348 | i0 | 59.7 | 2.67469879518072 | 72 | 29 | 86.7 | 0 | 218 | 3 | 75 | 146 | WP_015235812.1 3-hydroxybutyrate dehydrogenase [Deinococcus peraridilitoris] | diamond | 666 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 12723806 | 12723806 | PRJNA898105_P_NODE_7730_length_244_cov_0.900585_g7530_i0 | PRJNA898105 | 7730 | 244 | 0.900585 | 2.1974274 | Fervidobacterium | 2422 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|383108560|gb|CP003260.1| | 771875 | g7530 | i0 | 100 | 3 | 244 | 0 | 100 | 0 | 1 | 244 | 1120332 | 1120089 | Fervidobacterium pennivorans DSM 9078, complete genome | blastn | 732 | 451 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium pennivorans | ||
| 16546751 | 16546751 | PRJNA898105_P_NODE_5393_length_265_cov_1.333333_g5193_i0 | PRJNA898105 | 5393 | 265 | 1.333333 | 3.53333245 | Deinococcus | 1298 | Bacteria | Bacteria | 484 | 2.0199999999999998e-132 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g5193 | i0 | 99.623 | 28.622641509434 | 265 | 1 | 100 | 0 | 1 | 265 | 873446 | 873182 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 7585 | 484 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 18725278 | 18725278 | PRJNA898105_P_NODE_4155_length_286_cov_1.840376_g3955_i0 | PRJNA898105 | 4155 | 286 | 1.840376 | 5.26347536 | Jonquetella anthropi | 428712 | Bacteria | Bacteria | 368 | 2.31e-97 | NTclustered | gi|194410714|gb|EU840722.1| | 428712 | g3955 | i0 | 100 | 147.716783216783 | 199 | 0 | 70 | 0 | 1 | 199 | 813 | 615 | Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence | blastn | 42247 | 368 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi | ||
| 19095761 | 19095761 | PRJNA898105_P_NODE_5275_length_267_cov_1.463918_g5075_i0 | PRJNA898105 | 5275 | 267 | 1.463918 | 3.90866106 | Deinococcus | 1298 | Bacteria | Bacteria | 488 | 1.5699999999999998e-133 | NTclustered | gi|470488003|ref|NR_076846.1| | 55148 | g5075 | i0 | 99.625 | 249.483146067416 | 267 | 1 | 100 | 0 | 1 | 267 | 1013 | 747 | Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence | blastn | 66612 | 488 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 23825967 | 23825967 | PRJNA898105_P_NODE_1479_length_503_cov_2.237209_g1281_i0 | PRJNA898105 | 1479 | 503 | 2.237209 | 11.25316127 | Jonquetella anthropi | 428712 | Bacteria | Bacteria | 918 | 0 | NTclustered | gi|194410714|gb|EU840722.1| | 428712 | g1281 | i0 | 99.602 | 92.0178926441352 | 503 | 2 | 100 | 0 | 1 | 503 | 27 | 529 | Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence | blastn | 46285 | 918 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi | ||
| 25470979 | 25470979 | PRJNA898105_P_NODE_880_length_697_cov_3.243590_g693_i0 | PRJNA898105 | 880 | 697 | 3.24359 | 22.6078223 | Truepera | 332248 | Bacteria | Bacteria | 902 | 0 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g693 | i0 | 90.762 | 182.691535150646 | 682 | 53 | 97 | 8 | 2 | 677 | 1920 | 1243 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 127336 | 902 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 30150290 | 30150290 | PRJNA898105_P_NODE_5752_length_258_cov_1.291892_g5552_i0 | PRJNA898105 | 5752 | 258 | 1.291892 | 3.33308136 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 127 | 6.479999999999998e-35 | NR | WP_027464351.1 | 317577 | g5552 | i0 | 70.6 | 0.988372093023256 | 85 | 25 | 98.8 | 0 | 256 | 2 | 19 | 103 | WP_027464351.1 hypothetical protein [Deinococcus ficus] | diamond | 255 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 32015572 | 32015572 | PRJNA898105_P_NODE_7758_length_244_cov_0.900585_g7558_i0 | PRJNA898105 | 7758 | 244 | 0.900585 | 2.1974274 | Thermus sp. | 275 | Bacteria | Bacteria | 114 | 2.38e-27 | NR | MEN2982684.1 | 275 | g7558 | i0 | 98.2 | 0.700819672131147 | 57 | 1 | 70.1 | 0 | 72 | 242 | 1 | 57 | MEN2982684.1 type IV secretory system conjugative DNA transfer family protein [Thermus sp.] | diamond | 171 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus 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);;