RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA832865", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA832865 · 15 ✖

analysis 1

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
4652320 4652320 PRJNA832865_S_NODE_9384_length_1552_cov_2.829615_g6774_i0 PRJNA832865 9384 1552 2.829615 43.9156248 Desulfovermiculus sp. 2821143 Bacteria Bacteria 145 5.13e-38   NR MFO7802529.1 2821143 g6774 i0 100 0.137242268041237 71 0 13.7 0 1339 1551 1 71 MFO7802529.1 hypothetical protein [Desulfovermiculus sp.] diamond 213 145 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
26865033 26865033 PRJNA832865_S_NODE_60061_length_321_cov_1.552419_g54975_i0 PRJNA832865 60061 321 1.552419 4.98326499 Desulfocapsa sp. 2066021 Bacteria Bacteria 52.4 3.74e-5   NR RUM41879.1 2066021 g54975 i0 44 0.700934579439252 75 37 65.4 2 214 5 498 572 RUM41879.1 MAG: hypothetical protein DSY80_08180 [Desulfocapsa sp.] diamond 225 52.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfocapsa Desulfocapsa sp.
26896605 26896605 PRJNA832865_S_NODE_81621_length_271_cov_3.191919_g76535_i0 PRJNA832865 81621 271 3.191919 8.65010049 Desulfovermiculus sp. 2821143 Bacteria Bacteria 53.1 5.68e-7   NR MFO7876311.1 2821143 g76535 i0 96 0.276752767527675 25 1 27.7 0 84 158 24 48 MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] diamond 75 53.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
27781262 27781262 PRJNA832865_S_NODE_50424_length_357_cov_1.183099_g45338_i0 PRJNA832865 50424 357 1.183099 4.22366343 Desulfobacterales bacterium 2044940 Bacteria Bacteria 44.3 0.0328   NR MCP4682635.1 2044940 g45338 i0 38.9 0.605042016806723 72 30 48.7 3 323 150 130 201 MCP4682635.1 tRNA epoxyqueuosine(34) reductase QueG [Desulfobacterales bacterium] diamond 216 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27939117 27939117 PRJNA832865_S_NODE_34765_length_470_cov_1.511335_g29684_i0 PRJNA832865 34765 470 1.511335 7.1032745 Desulfovibrionales bacterium 2448050 Bacteria Bacteria 85.5 7.8e-19   NR MFO7816224.1 2448050 g29684 i0 95.1 0.261702127659574 41 2 26.2 0 195 73 1 41 MFO7816224.1 hypothetical protein [Desulfovibrionales bacterium] diamond 123 85.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales     Desulfovibrionales bacterium
28412691 28412691 PRJNA832865_S_NODE_113866_length_215_cov_4.260563_g108780_i0 PRJNA832865 113866 215 4.260563 9.16021045 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 42.4 0.0361   NR MBQ7608481.1 2049043 g108780 i0 34.4 0.893023255813953 64 42 89.3 0 1 192 167 230 MBQ7608481.1 isoleucine--tRNA ligase [Desulfovibrionaceae bacterium] diamond 192 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
28602192 28602192 PRJNA832865_S_NODE_99047_length_248_cov_0.880000_g93961_i0 PRJNA832865 99047 248 0.88 2.1824 Syntrophorhabdaceae bacterium 2660714 Bacteria Bacteria 126 1.5099999999999999e-32   NR HOJ70945.1 2660714 g93961 i0 68.8 3.89516129032258 80 25 96.8 0 241 2 228 307 HOJ70945.1 4-alpha-glucanotransferase [Syntrophorhabdaceae bacterium] diamond 966 126 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium
29139080 29139080 PRJNA832865_S_NODE_111589_length_239_cov_2.650602_g106503_i0 PRJNA832865 111589 239 2.650602 6.33493878 Desulfovermiculus sp. 2821143 Bacteria Bacteria 43.1 0.00342   NR MFO7876311.1 2821143 g106503 i0 83.3 0.301255230125523 24 4 30.1 0 237 166 26 49 MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] diamond 72 43.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
29328180 29328180 PRJNA832865_S_NODE_22609_length_697_cov_2.224359_g17773_i0 PRJNA832865 22609 697 2.224359 15.50378223 Desulfovermiculus sp. 2821143 Bacteria Bacteria 47 0.00226   NR MFO7876311.1 2821143 g17773 i0 84.6 0.111908177905308 26 4 11.2 0 112 35 24 49 MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] diamond 78 47 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
30149181 30149181 PRJNA832865_S_NODE_39132_length_426_cov_3.733711_g34047_i0 PRJNA832865 39132 426 3.733711 15.90560886 Desulfovermiculus sp. 2821143 Bacteria Bacteria 48.5 1.56e-4   NR MFO7876311.1 2821143 g34047 i0 92 0.176056338028169 25 2 17.6 0 98 24 24 48 MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] diamond 75 48.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
30402559 30402559 PRJNA832865_S_NODE_105653_length_244_cov_0.900585_g100567_i0 PRJNA832865 105653 244 0.900585 2.1974274 Syntrophorhabdaceae bacterium PtaU1.Bin 2660714 Bacteria Bacteria 42.4 0.0485   NR OPY62193.1 1811715 g100567 i0 34.6 0.959016393442623 78 45 93.4 2 12 239 284 357 OPY62193.1 MAG: putative metallophosphoesterase [Syntrophorhabdaceae bacterium PtaU1.Bin034] diamond 234 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophorhabdia Syntrophorhabdales Syntrophorhabdaceae   Syntrophorhabdaceae bacterium PtaU1.Bin034
30718010 30718010 PRJNA832865_S_NODE_71614_length_291_cov_3.160550_g66528_i0 PRJNA832865 71614 291 3.16055 9.1972005 Desulfovibrionales bacterium 2448050 Bacteria Bacteria 53.9 2.92e-7   NR MFO7816224.1 2448050 g66528 i0 63 0.474226804123711 46 15 45.4 1 279 148 2 47 MFO7816224.1 hypothetical protein [Desulfovibrionales bacterium] diamond 138 53.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales     Desulfovibrionales bacterium
30970978 30970978 PRJNA832865_S_NODE_21014_length_753_cov_2.261765_g16281_i0 PRJNA832865 21014 753 2.261765 17.03109045 Desulfovermiculus sp. 2821143 Bacteria Bacteria 54.7 4.15e-6   NR MFO7876311.1 2821143 g16281 i0 73.2 0.163346613545817 41 8 16.3 1 281 159 24 61 MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] diamond 123 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
31318486 31318486 PRJNA832865_S_NODE_82475_length_270_cov_1.172589_g77389_i0 PRJNA832865 82475 270 1.172589 3.1659903 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.5 0.0253   NR MCF8067473.1 2044940 g77389 i0 40.8 0.544444444444444 49 28 54.4 1 9 155 1 48 MCF8067473.1 peptidoglycan DD-metalloendopeptidase family protein [Desulfobacterales bacterium] diamond 147 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32236277 32236277 PRJNA832865_S_NODE_70578_length_294_cov_0.945701_g65492_i0 PRJNA832865 70578 294 0.945701 2.78036094 Desulfovermiculus sp. 2821143 Bacteria Bacteria 107 4.66e-28   NR MFO7802529.1 2821143 g65492 i0 100 0.510204081632653 50 0 51 0 2 151 53 102 MFO7802529.1 hypothetical protein [Desulfovermiculus sp.] diamond 150 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus 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);;