RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA492280 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
5555687 5555687 PRJNA492280_P_NODE_34305_length_150_cov_3.159292_g34198_i0 PRJNA492280 34305 150 3.159292 4.738938 Deinococcus 1298 Bacteria Bacteria 78.6 5.03e-16   NR WP_160329930.1 57498 g34198 i0 60.6 2.84 71 5 96 1 4 147 7 77 WP_160329930.1 substrate-binding periplasmic protein [Deinococcus grandis] diamond 426 78.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
20853611 20853611 PRJNA492280_P_NODE_20657_length_164_cov_3.228346_g20550_i0 PRJNA492280 20657 164 3.228346 5.29448744 Deinococcus 1298 Bacteria Bacteria 75.9 2.64e-14   NR WP_088248164.1 1298 g20550 i0 67.6 2.59756097560976 71 4 95.1 1 159 4 226 296 WP_088248164.1 MULTISPECIES: sodium:solute symporter family protein [Deinococcus] diamond 426 75.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
26743842 26743842 PRJNA492280_P_NODE_29961_length_151_cov_5.236842_g29854_i0 PRJNA492280 29961 151 5.236842 7.90763142 Deinococcus 1298 Bacteria Bacteria 53.1 1.16e-6   NR WP_145999542.1 1704277 g29854 i0 95.8 4.29139072847682 24 1 47.7 0 77 148 112 135 WP_145999542.1 transposase, partial [Deinococcus sp. UR1] diamond 648 53.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. UR1
26886754 26886754 PRJNA492280_P_NODE_18321_length_164_cov_3.622047_g18214_i0 PRJNA492280 18321 164 3.622047 5.94015708 Deinococcus caeni 569127 Bacteria Bacteria 52.8 3.54e-6   NR WP_345446940.1 569127 g18214 i0 96 0.914634146341463 25 1 45.7 0 75 1 38 62 WP_345446940.1 site-specific integrase [Deinococcus caeni] diamond 150 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
27092405 27092405 PRJNA492280_P_NODE_31422_length_151_cov_3.140351_g31315_i0 PRJNA492280 31422 151 3.140351 4.74193001 Deinococcus 1298 Bacteria Bacteria 62.4 1.24e-9   NR WP_158235769.1 1704277 g31315 i0 64.9 2.26490066225166 57 12 97.4 1 2 148 11 67 WP_158235769.1 EAL domain-containing protein [Deinococcus sp. UR1] diamond 342 62.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. UR1
27092406 27092406 PRJNA492280_P_NODE_33142_length_150_cov_4.380531_g33035_i0 PRJNA492280 33142 150 4.380531 6.5707965 Thermus 270 Bacteria Bacteria 52 5.54e-6   NR WP_153185090.1 37636 g33035 i0 96 3.46 25 1 50 0 2 76 452 476 WP_153185090.1 transketolase family protein, partial [Thermus scotoductus] diamond 519 52 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
27139230 27139230 PRJNA492280_P_NODE_30782_length_151_cov_3.842105_g30675_i0 PRJNA492280 30782 151 3.842105 5.80157855 Deinococcus radiophilus 32062 Bacteria Bacteria 45.4 0.00119   NR WP_126353714.1 32062 g30675 i0 81.5 0.536423841059603 27 5 53.6 0 148 68 303 329 WP_126353714.1 transposase [Deinococcus radiophilus] diamond 81 45.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
27424272 27424272 PRJNA492280_P_NODE_33763_length_150_cov_3.672566_g33656_i0 PRJNA492280 33763 150 3.672566 5.508849 Deinococcus sp. 6GRE 47478 Bacteria Bacteria 61.6 4.97e-10   NR WP_230296116.1 2745873 g33656 i0 63 0.92 46 17 92 0 139 2 45 90 WP_230296116.1 helix-turn-helix domain-containing protein [Deinococcus sp. 6GRE01] diamond 138 61.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 6GRE01
27834409 27834409 PRJNA492280_P_NODE_32264_length_150_cov_7.336283_g32157_i0 PRJNA492280 32264 150 7.336283 11.0044245 Deinococcus 1298 Bacteria Bacteria 52.4 1.95e-6   NR WP_189063476.1 1298 g32157 i0 100 1.18 24 0 48 0 77 6 144 167 WP_189063476.1 MULTISPECIES: PsbP-related protein [Deinococcus] diamond 177 52.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
27929275 27929275 PRJNA492280_P_NODE_31225_length_151_cov_3.324561_g31118_i0 PRJNA492280 31225 151 3.324561 5.02008711 Deinococcus sp. 23YEL01 2745871 Bacteria Bacteria 84.3 3.1e-18   NR MCD0171771.1 2745871 g31118 i0 84 0.993377483443709 50 8 99.3 0 2 151 167 216 MCD0171771.1 MFS transporter [Deinococcus sp. 23YEL01] diamond 150 84.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 23YEL01
28434449 28434449 PRJNA492280_P_NODE_22706_length_164_cov_2.905512_g22599_i0 PRJNA492280 22706 164 2.905512 4.76503968 Deinococcus indicus 223556 Bacteria Bacteria 55.1 2.87e-7   NR WP_088250254.1 223556 g22599 i0 100 0.439024390243902 24 0 43.9 0 74 3 141 164 WP_088250254.1 c-type cytochrome [Deinococcus indicus] diamond 72 55.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus indicus
29019060 29019060 PRJNA492280_P_NODE_30548_length_151_cov_4.131579_g30441_i0 PRJNA492280 30548 151 4.131579 6.23868429 Deinococcus 1298 Bacteria Bacteria 57.8 3.84e-9   NR WP_172418051.1 223556 g30441 i0 100 2.98013245033113 25 0 49.7 0 148 74 28 52 WP_172418051.1 transposase, partial [Deinococcus indicus] diamond 450 57.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus indicus
29050467 29050467 PRJNA492280_P_NODE_32868_length_150_cov_4.876106_g32761_i0 PRJNA492280 32868 150 4.876106 7.314159 Deinococcus 1298 Bacteria Bacteria 58.9 2.02e-8   NR WP_345447749.1 569127 g32761 i0 100 6.24 24 0 48 0 76 147 223 246 WP_345447749.1 transposase [Deinococcus caeni] diamond 936 58.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
29366123 29366123 PRJNA492280_P_NODE_32249_length_150_cov_7.460177_g32142_i0 PRJNA492280 32249 150 7.460177 11.1902655 Deinococcus 1298 Bacteria Bacteria 68.6 8.01e-12   NR WP_304524292.1 2745871 g32142 i0 60.8 8.88 74 3 96 1 146 3 851 924 WP_304524292.1 beta strand repeat-containing protein [Deinococcus sp. 23YEL01] diamond 1332 68.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. 23YEL01
30455915 30455915 PRJNA492280_P_NODE_18173_length_164_cov_3.661417_g18066_i0 PRJNA492280 18173 164 3.661417 6.00472388 Deinococcus sp. UR1 1704277 Bacteria Bacteria 52.4 2.77e-6   NR PIG95930.1 1704277 g18066 i0 100 0.841463414634146 23 0 42.1 0 74 6 144 166 PIG95930.1 hypothetical protein AMD26_019015 [Deinococcus sp. UR1] diamond 138 52.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. UR1
30518727 30518727 PRJNA492280_P_NODE_27253_length_162_cov_5.752000_g27146_i0 PRJNA492280 27253 162 5.752 9.31824 Thermus sp. 2.9 1577051 Bacteria Bacteria 52.8 1.95e-6   NR WP_039457130.1 1577051 g27146 i0 83.3 0.555555555555556 30 5 55.6 0 5 94 155 184 WP_039457130.1 ParA family protein [Thermus sp. 2.9] diamond 90 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. 2.9
30866203 30866203 PRJNA492280_P_NODE_13754_length_164_cov_5.204724_g13647_i0 PRJNA492280 13754 164 5.204724 8.53574736 Deinococcus caeni 569127 Bacteria Bacteria 47.4 1.53e-4   NR WP_380064864.1 569127 g13647 i0 100 0.439024390243902 24 0 43.9 0 4 75 129 152 WP_380064864.1 hypothetical protein [Deinococcus caeni] diamond 72 47.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus caeni
31356506 31356506 PRJNA492280_P_NODE_18496_length_164_cov_3.590551_g18389_i0 PRJNA492280 18496 164 3.590551 5.88850364 Thermus 270 Bacteria Bacteria 86.7 4.14e-18   NR WP_126187364.1 37636 g18389 i0 73.4 2.34146341463415 64 6 97 1 5 163 340 403 WP_126187364.1 hypothetical protein [Thermus scotoductus] diamond 384 86.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
31403772 31403772 PRJNA492280_P_NODE_31456_length_151_cov_3.096491_g31349_i0 PRJNA492280 31456 151 3.096491 4.67570141 Calidithermus terrae 1408545 Bacteria Bacteria 67 3.63e-12   NR WP_119314418.1 1408545 g31349 i0 66.1 1.11258278145695 56 12 97.4 2 150 4 9 64 WP_119314418.1 hypothetical protein [Calidithermus terrae] diamond 168 67 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus terrae
32479445 32479445 PRJNA492280_P_NODE_21539_length_164_cov_3.055118_g21432_i0 PRJNA492280 21539 164 3.0551179999999998 5.01039352 unclassified Deinococcus 2623546 Bacteria Bacteria 52.8 1.34e-6   NR WP_078301753.1 2623546 g21432 i0 100 0.878048780487805 24 0 43.9 0 5 76 92 115 WP_078301753.1 MULTISPECIES: hypothetical protein [unclassified Deinococcus] diamond 144 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
32857479 32857479 PRJNA492280_P_NODE_24380_length_164_cov_2.677165_g24273_i0 PRJNA492280 24380 164 2.677165 4.3905506 Deinococcus carri 1211323 Bacteria Bacteria 91.3 5.47e-21   NR WP_345463034.1 1211323 g24273 i0 68.6 1.28048780487805 70 6 98.8 1 164 3 4 73 WP_345463034.1 TnsA endonuclease N-terminal domain-containing protein [Deinococcus carri] diamond 210 91.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus carri

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