RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA966993" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA966993 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_clade 0

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
15293565 15293565 PRJNA966993_P_NODE_46132_length_318_cov_1.551020_g45680_i0 PRJNA966993 46132 318 1.55102 4.9322436 Mesotoga sp. 2053577 Bacteria Bacteria 165 5.65e-46   NR MCB1222954.1 2053577 g45680 i0 74.3 1.9811320754717 105 27 99.1 0 1 315 115 219 MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.] diamond 630 165 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Mesotoga Mesotoga sp.
27089234 27089234 PRJNA966993_P_NODE_84462_length_250_cov_0.870056_g84010_i0 PRJNA966993 84462 250 0.870056 2.17514 Calidithermus timidus 307124 Bacteria Bacteria 160 6.25e-46   NR WP_018466515.1 307124 g84010 i0 100 0.996 83 0 99.6 0 249 1 167 249 WP_018466515.1 FAD-binding protein [Calidithermus timidus] diamond 249 160 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus timidus
29173484 29173484 PRJNA966993_P_NODE_80189_length_254_cov_1.348066_g79737_i0 PRJNA966993 80189 254 1.348066 3.42408764 Deinococcus taklimakanensis 536443 Bacteria Bacteria 158 2.64e-46   NR WP_386842737.1 536443 g79737 i0 100 0.992125984251969 84 0 99.2 0 3 254 24 107 WP_386842737.1 hypothetical protein [Deinococcus taklimakanensis] diamond 252 158 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
29899685 29899685 PRJNA966993_P_NODE_65111_length_277_cov_1.818627_g64659_i0 PRJNA966993 65111 277 1.818627 5.03759679 Synergistaceae bacterium 2053624 Bacteria Bacteria 72 9.18e-13   NR MEG1502261.1 2053624 g64659 i0 62.5 0.693140794223827 64 22 67.1 1 187 2 1 64 MEG1502261.1 hypothetical protein [Synergistaceae bacterium] diamond 192 72 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
32112309 32112309 PRJNA966993_P_NODE_49258_length_309_cov_1.631356_g48806_i0 PRJNA966993 49258 309 1.631356 5.04089004 uncultured Truepera sp. 543023 Bacteria Bacteria 114 3.3700000000000004e-27   NR CAA9578840.1 543023 g48806 i0 57 2.69902912621359 93 38 90.3 1 31 309 70 160 CAA9578840.1 MAG: Beta-lactamase class C-like and penicillin binding proteins (PBPs) superfamily / DUF3471 domain [uncultured Truepera sp.] diamond 834 114 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera uncultured Truepera sp.
32112314 32112314 PRJNA966993_P_NODE_56258_length_290_cov_1.382488_g55806_i0 PRJNA966993 56258 290 1.382488 4.0092152 Deinococcus fonticola 2528713 Bacteria Bacteria 189 6.229999999999999e-56   NR WP_135229030.1 2528713 g55806 i0 99 0.993103448275862 96 1 99.3 0 3 290 110 205 WP_135229030.1 replication initiator protein A [Deinococcus fonticola] diamond 288 189 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
32397189 32397189 PRJNA966993_P_NODE_91839_length_245_cov_2.046512_g91387_i0 PRJNA966993 91839 245 2.046512 5.0139544 Deinococcus soli (ex Cha et al. 2 1309411 Bacteria Bacteria 124 3.64e-32   NR WP_188846534.1 1309411 g91387 i0 82.7 0.991836734693878 81 13 99.2 1 3 245 170 249 WP_188846534.1 hypothetical protein [Deinococcus soli (ex Cha et al. 2016)] diamond 243 124 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
32838613 32838613 PRJNA966993_P_NODE_92920_length_245_cov_0.895349_g92468_i0 PRJNA966993 92920 245 0.895349 2.19360505 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 114 4.1e-30   NR AXH00669.1 980427 g92468 i0 68.8 1.95918367346939 80 25 98 0 6 245 18 97 AXH00669.1 hypothetical protein DVJ83_16060 [Deinococcus wulumuqiensis] diamond 480 114 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;