RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1031674 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
166694 166694 PRJNA1031674_P_NODE_21781_length_251_cov_2.685393_g21570_i0 PRJNA1031674 21781 251 2.685393 6.74033643 Deinococcus aquiradiocola 393059 Bacteria Bacteria 164 4.63e-45   NR WP_188960430.1 393059 g21570 i0 98.8 0.99203187250996006 83 1 99.2 0 249 1 755 837 WP_188960430.1 ATP-dependent chaperone ClpB [Deinococcus aquiradiocola] diamond 249 164 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
21843674 21843674 PRJNA1031674_P_NODE_26738_length_243_cov_0.905882_g26527_i0 PRJNA1031674 26738 243 0.905882 2.20129326 Deinococcus taklimakanensis 536443 Bacteria Bacteria 150 1.79e-41   NR WP_386841902.1 536443 g26527 i0 98.8 0.987654320987654 80 1 98.8 0 242 3 161 240 WP_386841902.1 S8 family serine peptidase [Deinococcus taklimakanensis] diamond 240 150 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taklimakanensis
26654979 26654979 PRJNA1031674_P_NODE_25981_length_244_cov_1.801170_g25770_i0 PRJNA1031674 25981 244 1.80117 4.3948548 Deinococcales bacterium 2478479 Bacteria Bacteria 60.1 2.49e-8   NR MFN3266341.1 2478479 g25770 i0 69.2 0.479508196721311 39 12 48 0 121 237 7 45 MFN3266341.1 carbohydrate ABC transporter permease [Deinococcales bacterium] diamond 117 60.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales     Deinococcales bacterium
27793380 27793380 PRJNA1031674_P_NODE_19564_length_260_cov_2.465241_g19353_i0 PRJNA1031674 19564 260 2.465241 6.4096266 Deinococcus caeni 569127 Bacteria Bacteria 164 7.66e-49   NR WP_380064706.1 569127 g19353 i0 100 1.98461538461538 86 0 99.2 0 259 2 50 135 WP_380064706.1 PRC and DUF2382 domain-containing protein [Deinococcus caeni] diamond 516 164 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
28645900 28645900 PRJNA1031674_P_NODE_17347_length_269_cov_1.566327_g17136_i0 PRJNA1031674 17347 269 1.566327 4.21341963 Calidithermus roseus 1644118 Bacteria Bacteria 160 9.04e-45   NR WP_119280589.1 1644118 g17136 i0 97.8 0.992565055762082 89 2 99.3 0 267 1 374 462 WP_119280589.1 xylulokinase [Calidithermus roseus] diamond 267 160 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus roseus
28771999 28771999 PRJNA1031674_P_NODE_17427_length_269_cov_1.260204_g17216_i0 PRJNA1031674 17427 269 1.260204 3.38994876 Deinococcus grandis 57498 Bacteria Bacteria 150 1.47e-42   NR WP_174518667.1 57498 g17216 i0 91 2.96654275092937 89 8 99.3 0 267 1 108 196 WP_174518667.1 hypothetical protein [Deinococcus grandis] diamond 798 150 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
30595704 30595704 PRJNA1031674_P_NODE_21353_length_253_cov_2.261111_g21142_i0 PRJNA1031674 21353 253 2.261111 5.72061083 Deinococcus 1298 Bacteria Bacteria 91.7 3.58e-22   NR WP_291432267.1 47478 g21142 i0 97.9 1.13833992094862 48 1 56.9 0 251 108 33 80 WP_291432267.1 hypothetical protein [Deinococcus sp.] diamond 288 91.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
30761894 30761894 PRJNA1031674_P_NODE_13174_length_283_cov_1.466667_g12963_i0 PRJNA1031674 13174 283 1.466667 4.15066761 Deinococcus arboris 2682977 Bacteria Bacteria 144 9.95e-42   NR WP_157460696.1 2682977 g12963 i0 79.3 0.975265017667845 92 19 97.5 0 3 278 12 103 WP_157460696.1 hypothetical protein [Deinococcus arboris] diamond 276 144 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus arboris
31449334 31449334 PRJNA1031674_P_NODE_19956_length_259_cov_1.591398_g19745_i0 PRJNA1031674 19956 259 1.591398 4.12172082 Deinococcus 1298 Bacteria Bacteria 78.6 5.83e-16   NR WP_380064184.1 569127 g19745 i0 100 0.88030888030888 38 0 44 0 32 145 134 171 WP_380064184.1 hypothetical protein [Deinococcus caeni] diamond 228 78.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
31868249 31868249 PRJNA1031674_P_NODE_14797_length_278_cov_1.268293_g14586_i0 PRJNA1031674 14797 278 1.268293 3.52585454 Calidithermus timidus 307124 Bacteria Bacteria 110 1.4e-26   NR WP_018465883.1 307124 g14586 i0 100 0.571942446043165 53 0 57.2 0 119 277 1 53 WP_018465883.1 amidohydrolase family protein [Calidithermus timidus] diamond 159 110 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus timidus

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