RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA846486 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
833351 833351 PRJNA846486_P_NODE_78001_length_168_cov_1.453782_g77905_i0 PRJNA846486 78001 168 1.453782 2.44235376 Bacteria 2 Bacteria Bacteria 73.6 1.8e-13   NR HRN54239.1 2026741 g77905 i0 66.7 2.57142857142857 48 16 85.7 0 2 145 456 503 HRN54239.1 GMC family oxidoreductase N-terminal domain-containing protein [Gemmatimonadaceae bacterium] diamond 432 73.9 0.995940460081191 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
23785559 23785559 PRJNA846486_P_NODE_51359_length_196_cov_1.210884_g51263_i0 PRJNA846486 51359 196 1.210884 2.37333264 FCB group 1783270 Bacteria Bacteria 121 8.069999999999999e-34   NR MBA3585577.1 2026742 g51263 i0 89.8 20.7551020408163 59 6 90.3 0 194 18 13 71 MBA3585577.1 alpha/beta hydrolase [Gemmatimonadota bacterium] diamond 4068 122 0.991803278688525 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
25059434 25059434 PRJNA846486_P_NODE_31920_length_235_cov_1.817204_g31824_i0 PRJNA846486 31920 235 1.817204 4.2704294 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 141 4.46e-38   NR MDQ3520896.1 2026742 g31824 i0 84.6 3.98297872340426 78 12 99.6 0 2 235 116 193 MDQ3520896.1 L-fuconate dehydratase [Gemmatimonadota bacterium] diamond 936 141 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
26865196 26865196 PRJNA846486_P_NODE_76541_length_169_cov_0.866667_g76445_i0 PRJNA846486 76541 169 0.866667 1.46466723 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 75.5 2.54e-15   NR HEU4642560.1 2026741 g76445 i0 65.5 3.90532544378698 55 19 97.6 0 166 2 22 76 HEU4642560.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium] diamond 660 75.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27117761 27117761 PRJNA846486_P_NODE_85942_length_165_cov_0.896552_g85846_i0 PRJNA846486 85942 165 0.896552 1.4793108 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 75.1 2e-15   NR HXG70575.1 2026741 g85846 i0 58.5 0.963636363636364 53 22 96.4 0 165 7 68 120 HXG70575.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 159 75.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27180996 27180996 PRJNA846486_P_NODE_13662_length_338_cov_1.564014_g13566_i0 PRJNA846486 13662 338 1.564014 5.28636732 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 41.2 0.0454   NR MDQ3522059.1 2026742 g13566 i0 51.1 0.417159763313609 47 23 41.7 0 332 192 20 66 MDQ3522059.1 hypothetical protein [Gemmatimonadota bacterium] diamond 141 41.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27276130 27276130 PRJNA846486_P_NODE_93923_length_162_cov_0.920354_g93827_i0 PRJNA846486 93923 162 0.920354 1.49097348 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 86.3 1.19e-19   NR HEU6453219.1 2026741 g93827 i0 81.6 3.62962962962963 49 9 90.7 0 147 1 1 49 HEU6453219.1 6,7-dimethyl-8-ribityllumazine synthase [Gemmatimonadaceae bacterium] diamond 588 86.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28286284 28286284 PRJNA846486_P_NODE_93686_length_162_cov_0.920354_g93590_i0 PRJNA846486 93686 162 0.920354 1.49097348 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 41.6 0.0316   NR MBW3533676.1 2026742 g93590 i0 47.7 0.814814814814815 44 20 81.5 1 6 137 56 96 MBW3533676.1 amidohydrolase family protein [Gemmatimonadota bacterium] diamond 132 41.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28760024 28760024 PRJNA846486_P_NODE_83927_length_166_cov_0.888889_g83831_i0 PRJNA846486 83927 166 0.888889 1.47555574 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 49.3 3.69e-5   NR MFO0270407.1 2026742 g83831 i0 46.2 0.939759036144578 52 27 92.2 1 12 164 68 119 MFO0270407.1 hypothetical protein [Gemmatimonadota bacterium] diamond 156 49.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29991636 29991636 PRJNA846486_P_NODE_84151_length_166_cov_0.888889_g84055_i0 PRJNA846486 84151 166 0.888889 1.47555574 Longimicrobiales bacterium 2910168 Bacteria Bacteria 42.7 0.0129   NR MEQ9569239.1 2910168 g84055 i0 52.7 2.94578313253012 55 19 88.6 2 20 166 116 169 MEQ9569239.1 response regulator transcription factor [Longimicrobiales bacterium] diamond 489 42.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
30528641 30528641 PRJNA846486_P_NODE_84073_length_166_cov_0.888889_g83977_i0 PRJNA846486 84073 166 0.888889 1.47555574 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 67.4 2.49e-13   NR MBK8246051.1 2026742 g83977 i0 100 0.560240963855422 31 0 56 0 74 166 1 31 MBK8246051.1 hypothetical protein [Gemmatimonadota bacterium] diamond 93 67.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31286948 31286948 PRJNA846486_P_NODE_76655_length_169_cov_0.866667_g76559_i0 PRJNA846486 76655 169 0.866667 1.46466723 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 42 0.026   NR HIF05655.1 2026742 g76559 i0 46.7 0.798816568047337 45 24 79.9 0 5 139 117 161 HIF05655.1 metal transporter [Gemmatimonadota bacterium] diamond 135 42 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31453775 31453775 PRJNA846486_P_NODE_41356_length_213_cov_0.951220_g41260_i0 PRJNA846486 41356 213 0.95122 2.0260986 Pseudomonadati 3379134 Bacteria Bacteria 63.2 7.52e-10   NR MDQ3521785.1 2026742 g41260 i0 50.7 1.91549295774648 69 33 95.8 1 2 205 66 134 MDQ3521785.1 hypothetical protein [Gemmatimonadota bacterium] diamond 408 63.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31485482 31485482 PRJNA846486_P_NODE_72236_length_172_cov_1.626016_g72140_i0 PRJNA846486 72236 172 1.626016 2.79674752 Pseudomonadati 3379134 Bacteria Bacteria 75.1 7.44e-15   NR MCC6774699.1 2026741 g72140 i0 71.7 3.73255813953488 53 15 92.4 0 9 167 94 146 MCC6774699.1 RNA polymerase sigma factor SigZ [Gemmatimonadaceae bacterium] diamond 642 75.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31824614 31824614 PRJNA846486_P_NODE_76817_length_169_cov_0.866667_g76721_i0 PRJNA846486 76817 169 0.866667 1.46466723 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 96.7 1.43e-23   NR MBK8249758.1 2026742 g76721 i0 81.8 1.97041420118343 55 10 97.6 0 166 2 87 141 MBK8249758.1 RsmD family RNA methyltransferase [Gemmatimonadota bacterium] diamond 333 96.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31864610 31864610 PRJNA846486_P_NODE_83897_length_166_cov_0.888889_g83801_i0 PRJNA846486 83897 166 0.888889 1.47555574 Gemmatimonas 173479 Bacteria Bacteria 42 0.0167   NR WP_291163538.1 1946568 g83801 i0 72.7 2.81927710843373 22 6 39.8 0 2 67 144 165 WP_291163538.1 LEA type 2 family protein [Gemmatimonas sp. UBA7669] diamond 468 42.4 0.990566037735849 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp. UBA7669
32236469 32236469 PRJNA846486_P_NODE_76898_length_169_cov_0.866667_g76802_i0 PRJNA846486 76898 169 0.866667 1.46466723 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 65.9 9.32e-12   NR NIQ99206.1 2448054 g76802 i0 58.5 1.86390532544379 53 21 94.1 1 7 165 1 52 NIQ99206.1 hypothetical protein [Gemmatimonadales bacterium] diamond 315 65.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32615563 32615563 PRJNA846486_P_NODE_84360_length_166_cov_0.888889_g84264_i0 PRJNA846486 84360 166 0.888889 1.47555574 Gemmatimonas sp. 1962908 Bacteria Bacteria 78.2 4.07e-15   NR WP_409949018.1 1962908 g84264 i0 81.6 0.885542168674699 49 9 88.6 0 3 149 363 411 WP_409949018.1 bifunctional DNA primase/polymerase [Gemmatimonas sp.] diamond 147 78.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.

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