RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 17 ✖

bioproject 1

  • PRJNA1233465 · 17 ✖

analysis 1

  • diamond · 17 ✖

tax_phylum 0

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
25809815 25809815 PRJNA1233465b_S_NODE_211923_length_204_cov_1.645161_g210238_i0 PRJNA1233465 211923 204 1.645161 3.35612844 Myxococcota 2818505 Bacteria Bacteria 129 4.71e-35   NR OLC74945.1 1805121 g210238 i0 85.3 4 68 10 100 0 1 204 145 212 OLC74945.1 MAG: hypothetical protein AUH83_08940 [Deltaproteobacteria bacterium 13_1_40CM_4_68_19] diamond 816 129 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_4_68_19
26083603 26083603 PRJNA1233465b_S_NODE_346589_length_165_cov_0.879310_g344904_i0 PRJNA1233465 346589 165 0.87931 1.4508615 Deltaproteobacteria bacterium 13_1_4 2026735 Bacteria Bacteria 89.4 1.84e-20   NR OLC79050.1 1805121 g344904 i0 85.7 3.65454545454545 49 7 89.1 0 18 164 4 52 OLC79050.1 MAG: guanylate kinase [Deltaproteobacteria bacterium 13_1_40CM_4_68_19] diamond 603 89.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_4_68_19
32940895 32940895 PRJNA1233465d_S_NODE_51449_length_240_cov_2.570681_g50338_i0 PRJNA1233465 51449 240 2.570681 6.1696344 Candidatus Deferrimicrobiota 3031715 Bacteria Bacteria 85.9 1.05e-17   NR OYV74383.1 1970506 g50338 i0 60.8 2.9625 79 30 98.8 1 239 3 228 305 OYV74383.1 MAG: hypothetical protein B7Z74_02400 [Deltaproteobacteria bacterium 21-66-5] diamond 711 86.7 0.990772779700115 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 21-66-5
32950188 32950188 PRJNA1233465d_S_NODE_6450_length_563_cov_2.990272_g5441_i0 PRJNA1233465 6450 563 2.990272 16.83523136 Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12 1797906 Bacteria Bacteria 68.6 9.88e-11   NR OGQ95250.1 1797906 g5441 i0 40 0.452930728241563 85 49 45.3 2 259 5 23 105 OGQ95250.1 MAG: hypothetical protein A2521_03700 [Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12] diamond 255 68.6 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12
32950916 32950916 PRJNA1233465f_S_NODE_10442_length_605_cov_7.343525_g8489_i0 PRJNA1233465 10442 605 7.343525 44.42832625 Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12 1797906 Bacteria Bacteria 64.3 5.14e-9   NR OGQ95250.1 1797906 g8489 i0 39.5 0.401652892561983 81 47 40.2 2 363 605 23 101 OGQ95250.1 MAG: hypothetical protein A2521_03700 [Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12] diamond 243 64.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12
32958165 32958165 PRJNA1233465e_S_NODE_5930_length_620_cov_3.464098_g4817_i0 PRJNA1233465 5930 620 3.464098 21.4774076 Pseudomonadota 1224 Bacteria Bacteria 67 5.64e-10   NR OGQ95250.1 1797906 g4817 i0 40 0.812903225806452 85 49 41.1 2 310 564 23 105 OGQ95250.1 MAG: hypothetical protein A2521_03700 [Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12] diamond 504 67 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_57_12
32982878 32982878 PRJNA1233465a_S_NODE_127787_length_208_cov_1.698113_g126513_i0 PRJNA1233465 127787 208 1.698113 3.53207504 Deltaproteobacteria bacterium 13_1_4 2026735 Bacteria Bacteria 67 3.07e-11   NR OLC78994.1 1805121 g126513 i0 83.3 0.519230769230769 36 6 51.9 0 110 3 1 36 OLC78994.1 MAG: serine/threonine protein phosphatase [Deltaproteobacteria bacterium 13_1_40CM_4_68_19] diamond 108 67 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_4_68_19
32991934 32991934 PRJNA1233465a_S_NODE_190915_length_177_cov_1.007812_g189641_i0 PRJNA1233465 190915 177 1.007812 1.78382724 Myxococcota 2818505 Bacteria Bacteria 105 9.08e-25   NR OLC17979.1 1805123 g189641 i0 79.7 10 59 12 100 0 1 177 100 158 OLC17979.1 MAG: threonine--tRNA ligase, partial [Deltaproteobacteria bacterium 13_1_40CM_68_24] diamond 1770 106 0.990566037735849 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_68_24
33026219 33026219 PRJNA1233465b_S_NODE_269508_length_184_cov_1.059259_g267823_i0 PRJNA1233465 269508 184 1.059259 1.94903656 Bacteria 2 Bacteria Bacteria 92 5.08e-21   NR OLD06831.1 1805116 g267823 i0 74.6 3.84782608695652 59 15 96.2 0 6 182 144 202 OLD06831.1 MAG: hypothetical protein AUI90_11890 [Deltaproteobacteria bacterium 13_1_40CM_3_69_14] diamond 708 92 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_3_69_14
33026515 33026515 PRJNA1233465f_S_NODE_137564_length_208_cov_1.440252_g135284_i0 PRJNA1233465 137564 208 1.440252 2.99572416 Myxococcota 2818505 Bacteria Bacteria 99.4 1.36e-22   NR OLC17527.1 1805123 g135284 i0 91.1 12.9230769230769 56 5 80.8 0 175 8 1 56 OLC17527.1 MAG: type II secretion system protein GspE, partial [Deltaproteobacteria bacterium 13_1_40CM_68_24] diamond 2688 100 0.994 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_68_24
33043006 33043006 PRJNA1233465a_S_NODE_259044_length_153_cov_2.451923_g257770_i0 PRJNA1233465 259044 153 2.451923 3.75144219 Myxococcota 2818505 Bacteria Bacteria 75.9 2.22e-14   NR OQB11662.1 1852869 g257770 i0 76 4.88235294117647 50 12 98 0 151 2 158 207 OQB11662.1 MAG: Type II secretion system protein E [Deltaproteobacteria bacterium ADurb.Bin207] diamond 747 76.3 0.99475753604194 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207
33077468 33077468 PRJNA1233465e_S_NODE_38981_length_286_cov_1.510549_g37671_i0 PRJNA1233465 38981 286 1.510549 4.32017014 Bacteria 2 Bacteria Bacteria 93.6 2.65e-20   NR KPJ77124.1 1703398 g37671 i0 48.1 11.6538461538462 79 41 82.9 0 247 11 263 341 KPJ77124.1 MAG: cyclopropane-fatty-acyl-phospholipid synthase [Deltaproteobacteria bacterium SG8_13] diamond 3333 94 0.995744680851064 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium SG8_13
33094225 33094225 PRJNA1233465a_S_NODE_189598_length_177_cov_1.679688_g188324_i0 PRJNA1233465 189598 177 1.679688 2.97304776 Myxococcota 2818505 Bacteria Bacteria 67 4.14e-11   NR OGQ78413.1 1797894 g188324 i0 78.6 5.57627118644068 42 9 71.2 0 2 127 862 903 OGQ78413.1 MAG: hypothetical protein A3F90_04690 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19] diamond 987 67.4 0.99406528189911 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
33094403 33094403 PRJNA1233465b_S_NODE_342942_length_165_cov_1.646552_g341257_i0 PRJNA1233465 342942 165 1.646552 2.7168108 Bacteria 2 Bacteria Bacteria 48.1 1.58e-4   NR OIP36441.1 1805126 g341257 i0 60 1.98181818181818 40 15 70.9 1 154 38 219 258 OIP36441.1 MAG: hypothetical protein AUK47_15070 [Deltaproteobacteria bacterium CG2_30_63_29] diamond 327 48.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG2_30_63_29
33104332 33104332 PRJNA1233465e_S_NODE_66638_length_228_cov_1.569832_g65328_i0 PRJNA1233465 66638 228 1.569832 3.57921696 uncultured delta proteobacterium 34034 Bacteria Bacteria 59.3 1.74e-8   NR SBW10784.1 34034 g65328 i0 52.2 1.81578947368421 69 32 89.5 1 25 228 7 75 SBW10784.1 conserved membrane hypothetical protein [uncultured delta proteobacterium] diamond 414 59.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
33145888 33145888 PRJNA1233465f_S_NODE_147135_length_202_cov_1.823529_g144855_i0 PRJNA1233465 147135 202 1.823529 3.68352858 Myxococcota 2818505 Bacteria Bacteria 80.1 3.73e-16   NR OLC78575.1 1805121 g144855 i0 64.6 3.8168316831683202 65 23 96.5 0 201 7 170 234 OLC78575.1 MAG: hypothetical protein AUH83_02130 [Deltaproteobacteria bacterium 13_1_40CM_4_68_19] diamond 771 80.9 0.990111248454882 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium 13_1_40CM_4_68_19
33153672 33153672 PRJNA1233465a_S_NODE_45448_length_305_cov_1.492188_g44174_i0 PRJNA1233465 45448 305 1.492188 4.5511734 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 154 7.73e-44   NR OGQ14178.1 1797848 g44174 i0 80.6 3.57049180327869 93 18 91.5 0 304 26 189 281 OGQ14178.1 MAG: 2-oxo acid dehydrogenase [Deltaproteobacteria bacterium RBG_16_71_12] diamond 1089 154 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12

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