RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Giovannoniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Giovannoniibacteriota · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA340009 · 18 ✖

analysis 1

  • diamond · 18 ✖

tax_kingdom 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
26648570 26648570 PRJNA340009_P_NODE_51401_length_181_cov_2.318182_g51094_i0 PRJNA340009 51401 181 2.318182 4.19590942 Bacteria 2 Bacteria Bacteria 91.3 2.69e-20   NR OGF61851.1 1798327 g51094 i0 71.7 8.95027624309392 60 17 99.4 0 180 1 186 245 OGF61851.1 MAG: hypothetical protein A2662_01215 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_33] diamond 1620 91.3 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_33
27060341 27060341 PRJNA340009_P_NODE_44362_length_192_cov_4.993007_g44055_i0 PRJNA340009 44362 192 4.993007 9.58657344 Bacteria 2 Bacteria Bacteria 92.8 3.8e-20   NR KKT20619.1 1618656 g44055 i0 76.2 1.953125 63 15 98.4 0 2 190 422 484 KKT20619.1 MAG: PolyA polymerase family protein [Candidatus Giovannonibacteria bacterium GW2011_GWC2_43_8] diamond 375 93.2 0.995708154506438 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWC2_43_8
27264461 27264461 PRJNA340009_P_NODE_62783_length_167_cov_0.864407_g62476_i0 PRJNA340009 62783 167 0.864407 1.44355969 Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ 2053557 Bacteria Bacteria 60.1 2.58e-9   NR OGF61731.1 1798325 g62476 i0 63.4 5.91017964071856 41 15 73.7 0 125 3 134 174 OGF61731.1 MAG: hypothetical protein A2834_00825 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23] diamond 987 60.1 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23
27390945 27390945 PRJNA340009_P_NODE_14563_length_309_cov_109.996154_g14256_i0 PRJNA340009 14563 309 109.996154 339.88811586 Candidatus Giovannonibacteria bacterium GW2 2053557 Bacteria Bacteria 59.3 1.34e-8   NR KKU04111.1 1618649 g14256 i0 73.5 0.912621359223301 34 9 33 0 286 185 25 58 KKU04111.1 MAG: hypothetical protein UX06_C0027G0004 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21] diamond 282 59.3 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21
27408243 27408243 PRJNA340009_P_NODE_56863_length_173_cov_2.782258_g56556_i0 PRJNA340009 56863 173 2.782258 4.81330634 Bacteria 2 Bacteria Bacteria 112 1.7300000000000003e-27   NR KKT59543.1 1618645 g56556 i0 98.2 3.88439306358381 56 1 97.1 0 171 4 252 307 KKT59543.1 MAG: hypothetical protein UW53_C0011G0072, partial [Candidatus Giovannonibacteria bacterium GW2011_GWA1_44_25] diamond 672 112 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWA1_44_25
27675186 27675186 PRJNA340009_P_NODE_33924_length_215_cov_15.680723_g33617_i0 PRJNA340009 33924 215 15.680723 33.71355445 Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ 2053557 Bacteria Bacteria 90.5 2.97e-20   NR OGF62470.1 1798325 g33617 i0 63.6 0.92093023255814 66 24 92.1 0 213 16 169 234 OGF62470.1 MAG: hypothetical protein A2834_03320 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23] diamond 198 90.5 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_23
27675190 27675190 PRJNA340009_P_NODE_39524_length_202_cov_2.333333_g39217_i0 PRJNA340009 39524 202 2.333333 4.71333266 Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ 2053557 Bacteria Bacteria 140 1.31e-39   NR OGF64655.1 1798326 g39217 i0 93.9 0.98019801980198 66 4 98 0 200 3 136 201 OGF64655.1 MAG: hypothetical protein A2661_02520 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_24] diamond 198 140 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_45_24
28085356 28085356 PRJNA340009_P_NODE_76025_length_161_cov_0.910714_g75718_i0 PRJNA340009 76025 161 0.910714 1.46624954 Candidatus Giovannonibacteria bacterium 2053557 Bacteria Bacteria 89.4 3.03e-19   NR MDP3934719.1 2053557 g75718 i0 88.2 2.83229813664596 51 6 95 0 1 153 342 392 MDP3934719.1 type II secretion system F family protein [Candidatus Giovannonibacteria bacterium] diamond 456 89.4 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium
28148670 28148670 PRJNA340009_P_NODE_23125_length_253_cov_7.901961_g22818_i0 PRJNA340009 23125 253 7.901961 19.99196133 Candidatus Giovannonibacteria bacterium GW2 2053557 Bacteria Bacteria 78.6 5.28e-17   NR KKU05117.1 1618649 g22818 i0 61.8 0.806324110671937 68 26 80.6 0 49 252 1 68 KKU05117.1 MAG: hypothetical protein UX06_C0003G0021 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21] diamond 204 78.6 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWA2_45_21
28148695 28148695 PRJNA340009_P_NODE_64325_length_166_cov_0.871795_g64018_i0 PRJNA340009 64325 166 0.871795 1.4471797 Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ 2053557 Bacteria Bacteria 95.1 3.51e-21   NR OGF68833.1 1798333 g64018 i0 81.8 1.98795180722892 55 10 99.4 0 1 165 284 338 OGF68833.1 MAG: UDP-N-acetylmuramoylalanine--D-glutamate ligase [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_44_11] diamond 330 95.1 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_44_11
28386748 28386748 PRJNA340009_P_NODE_5426_length_462_cov_3.619855_g5119_i0 PRJNA340009 5426 462 3.619855 16.7237301 Bacteria 2 Bacteria Bacteria 178 6.659999999999999e-52   NR KKW34491.1 1618650 g5119 i0 56 15.7597402597403 150 66 97.4 0 456 7 169 318 KKW34491.1 MAG: hypothetical protein UY81_C0073G0006 [Candidatus Giovannonibacteria bacterium GW2011_GWA2_53_7] diamond 7281 179 0.994413407821229 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWA2_53_7
28874683 28874683 PRJNA340009_P_NODE_24568_length_247_cov_4.398990_g24261_i0 PRJNA340009 24568 247 4.39899 10.8655053 Candidatus Giovannonibacteria bacterium GW2 2053557 Bacteria Bacteria 149 3.77e-40   NR KKS96871.1 1618651 g24261 i0 91.4 0.983805668016194 81 7 98.4 0 247 5 121 201 KKS96871.1 MAG: hypothetical protein UV72_C0001G0170 [Candidatus Giovannonibacteria bacterium GW2011_GWB1_43_13] diamond 243 149 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWB1_43_13
29113095 29113095 PRJNA340009_P_NODE_49388_length_184_cov_3.162963_g49081_i0 PRJNA340009 49388 184 3.162963 5.81985192 Bacteria 2 Bacteria Bacteria 86.3 7.08e-18   NR OGF68360.1 1798339 g49081 i0 66.7 1.80978260869565 54 18 88 0 22 183 156 209 OGF68360.1 MAG: hypothetical protein A3D61_00560 [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_48_15] diamond 333 87 0.991954022988506 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_48_15
29569300 29569300 PRJNA340009_P_NODE_24550_length_247_cov_5.030303_g24243_i0 PRJNA340009 24550 247 5.030303 12.42484841 Candidatus Giovannonibacteria bacterium GW2 2053557 Bacteria Bacteria 113 6.32e-30   NR KKT57411.1 1618652 g24243 i0 81.6 0.923076923076923 76 14 92.3 0 2 229 22 97 KKT57411.1 MAG: Transcription elongation factor GreA [Candidatus Giovannonibacteria bacterium GW2011_GWB1_44_23] diamond 228 113 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWB1_44_23
29600691 29600691 PRJNA340009_P_NODE_70930_length_163_cov_1.394737_g70623_i0 PRJNA340009 70930 163 1.394737 2.27342131 Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ 2053557 Bacteria Bacteria 95.5 3.13e-22   NR OGF65564.1 1798328 g70623 i0 84.9 0.975460122699387 53 8 97.5 0 160 2 143 195 OGF65564.1 MAG: glutamate racemase [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_48_47] diamond 159 95.5 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_01_FULL_48_47
30169325 30169325 PRJNA340009_P_NODE_29732_length_228_cov_1.608939_g29425_i0 PRJNA340009 29732 228 1.608939 3.66838092 Candidatus Giovannonibacteria bacterium GW2 2053557 Bacteria Bacteria 117 5.72e-29   NR KKT57889.1 1618652 g29425 i0 85.3 0.986842105263158 75 11 98.7 0 3 227 111 185 KKT57889.1 MAG: hypothetical protein UW49_C0001G0073 [Candidatus Giovannonibacteria bacterium GW2011_GWB1_44_23] diamond 225 117 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium GW2011_GWB1_44_23
30232653 30232653 PRJNA340009_P_NODE_22892_length_254_cov_21.560976_g22585_i0 PRJNA340009 22892 254 21.560976 54.76487904 Candidatus Giovannonibacteria bacterium 2053557 Bacteria Bacteria 51.6 8.89e-6   NR MBI4059532.1 2053557 g22585 i0 89.3 0.330708661417323 28 3 33.1 0 106 189 3 30 MBI4059532.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Giovannonibacteria bacterium] diamond 84 51.6 1 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium
30628843 30628843 PRJNA340009_P_NODE_67773_length_165_cov_0.879310_g67466_i0 PRJNA340009 67773 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 78.6 7.34e-16   NR MBI4059616.1 2053557 g67466 i0 74.5 2.96363636363636 55 14 100 0 165 1 130 184 MBI4059616.1 ABC transporter ATP-binding protein [Candidatus Giovannonibacteria bacterium] diamond 489 79 0.994936708860759 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium

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