RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB30004", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 16 ✖

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJEB30004 · 16 ✖

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
1302938 1302938 PRJEB30004_P_NODE_141262_length_488_cov_2.599109_g125728_i0 PRJEB30004 141262 488 2.599109 12.68365192 Desulfuromonas sp. DDH964 1823759 Bacteria Bacteria 167 1.63e-36   NTclustered gi|1015516084|gb|CP015080.1| 1823759 g125728 i0 82.383 12.3319672131148 193 32 39 2 297 488 2214223 2214032 Desulfuromonas sp. DDH964 chromosome, complete genome blastn 6018 167 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964
19160879 19160879 PRJEB30004_P_NODE_289736_length_289_cov_1.748000_g274109_i0 PRJEB30004 289736 289 1.748 5.05172 Geopsychrobacteraceae bacterium 3065857 Bacteria Bacteria 335 2.369999999999999e-87   NTclustered gi|2621701823|emb|OY759353.1| 3065857 g274109 i0 87.543 4 289 36 100 0 1 289 4680457 4680745 MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1 blastn 1156 335 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae   Geopsychrobacteraceae bacterium
26906735 26906735 PRJEB30004_P_NODE_565102_length_174_cov_2.422222_g549475_i0 PRJEB30004 565102 174 2.422222 4.21466628 Desulfobacter hydrogenophilus 2291 Bacteria Bacteria 106 6.28e-28   NR WP_282959083.1 2291 g549475 i0 100 0.982758620689655 57 0 98.3 0 4 174 62 118 WP_282959083.1 histidine kinase dimerization/phospho-acceptor domain-containing protein, partial [Desulfobacter hydrogenophilus] diamond 171 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter hydrogenophilus
27500899 27500899 PRJEB30004_P_NODE_519383_length_186_cov_1.530612_g503756_i0 PRJEB30004 519383 186 1.530612 2.84693832 Desulfobacterales 213118 Bacteria Bacteria 102 1.37e-23   NR SPD72452.1 201089 g503756 i0 77 7.87096774193548 61 14 98.4 0 3 185 252 312 SPD72452.1 putative transcriptional regulator [uncultured Desulfobacterium sp.] diamond 1464 103 0.990291262135922 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
27697080 27697080 PRJEB30004_P_NODE_624024_length_162_cov_1.333333_g608397_i0 PRJEB30004 624024 162 1.333333 2.15999946 Mailhella sp. 1981029 Bacteria Bacteria 53.5 1.37e-6   NR MBQ5727724.1 1981029 g608397 i0 41.5 1.96296296296296 53 31 98.1 0 160 2 95 147 MBQ5727724.1 DotI/IcmL/TraM family protein [Mailhella sp.] diamond 318 53.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella Mailhella sp.
28328047 28328047 PRJEB30004_P_NODE_427126_length_216_cov_1.389831_g411499_i0 PRJEB30004 427126 216 1.389831 3.00203496 Syntrophus sp. (in: bacteria) 48412 Bacteria Bacteria 68.6 2.06e-11   NR MEI7637697.1 48412 g411499 i0 46.4 0.958333333333333 69 35 93.1 1 9 209 684 752 MEI7637697.1 protein DpdF [Syntrophus sp. (in: bacteria)] diamond 207 68.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus sp. (in: bacteria)
28801611 28801611 PRJEB30004_P_NODE_663448_length_154_cov_2.643478_g647821_i0 PRJEB30004 663448 154 2.643478 4.07095612 Desulfovibrio sp. 885 Bacteria Bacteria 64.3 2.51e-10   NR MBR3663036.1 885 g647821 i0 73.3 1.75324675324675 45 11 87.7 1 20 154 128 171 MBR3663036.1 hypothetical protein [Desulfovibrio sp.] diamond 270 64.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
29023158 29023158 PRJEB30004_P_NODE_415828_length_220_cov_2.038674_g400201_i0 PRJEB30004 415828 220 2.038674 4.4850828 Desulfobacterium sp. 4572_2 2067988 Bacteria Bacteria 79.7 1.31e-15   NR OQY16229.1 1971621 g400201 i0 52.1 0.968181818181818 71 34 96.8 0 218 6 73 143 OQY16229.1 MAG: hypothetical protein B6I32_03970 [Desulfobacterium sp. 4572_20] diamond 213 79.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium Desulfobacterium sp. 4572_20
29174323 29174323 PRJEB30004_P_NODE_248569_length_323_cov_2.404930_g232942_i0 PRJEB30004 248569 323 2.40493 7.7679239 Pseudomonadati 3379134 Bacteria Bacteria 110 1.18e-25   NR WCB48155.1 881 g232942 i0 48.6 1.98761609907121 107 55 99.4 0 323 3 689 795 WCB48155.1 hypothetical protein PH214_16050 [Nitratidesulfovibrio vulgaris] diamond 642 111 0.990990990990991 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio vulgaris
30089831 30089831 PRJEB30004_P_NODE_296012_length_284_cov_2.893878_g280385_i0 PRJEB30004 296012 284 2.893878 8.21861352 Desulfovibrionaceae 194924 Bacteria Bacteria 86.7 4.71e-18   NR MBQ9405913.1 885 g280385 i0 45.2 3.92957746478873 93 50 97.2 1 2 277 190 282 MBQ9405913.1 hypothetical protein [Desulfovibrio sp.] diamond 1116 87 0.996551724137931 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30507274 30507274 PRJEB30004_P_NODE_612473_length_164_cov_1.640000_g596846_i0 PRJEB30004 612473 164 1.64 2.6896 Syntrophotalea acetylenica 29542 Bacteria Bacteria 66.2 6.39e-11   NR MDD4456268.1 29542 g596846 i0 48.1 0.98780487804878 54 28 98.8 0 162 1 28 81 MDD4456268.1 YqaJ viral recombinase family protein [Syntrophotalea acetylenica] diamond 162 66.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea acetylenica
30981334 30981334 PRJEB30004_P_NODE_409634_length_223_cov_1.336957_g394007_i0 PRJEB30004 409634 223 1.336957 2.98141411 Desulfovibrio sp. 885 Bacteria Bacteria 40 0.043   NR MBO4684258.1 885 g394007 i0 31.7 0.807174887892377 60 36 74 1 54 218 5 64 MBO4684258.1 hypothetical protein [Desulfovibrio sp.] diamond 180 40 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31297187 31297187 PRJEB30004_P_NODE_622255_length_162_cov_1.869919_g606628_i0 PRJEB30004 622255 162 1.869919 3.02926878 uncultured Desulfobacter sp. 240139 Bacteria Bacteria 43.5 0.00114   NR WP_321495063.1 240139 g606628 i0 62.1 0.537037037037037 29 11 53.7 0 157 71 54 82 WP_321495063.1 hypothetical protein [uncultured Desulfobacter sp.] diamond 87 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter uncultured Desulfobacter sp.
31859859 31859859 PRJEB30004_P_NODE_521177_length_185_cov_2.910959_g505550_i0 PRJEB30004 521177 185 2.910959 5.38527415 Pseudomonadati 3379134 Bacteria Bacteria 65.5 1.39e-11   NR WP_335339853.1 1823759 g505550 i0 66.7 3.5027027027027 45 15 73 0 138 4 1 45 WP_335339853.1 Cd(II)/Pb(II)-responsive transcriptional regulator [Desulfuromonas sp. DDH964] diamond 648 65.9 0.993930197268589 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964
31898171 31898171 PRJEB30004_P_NODE_526117_length_184_cov_1.731034_g510490_i0 PRJEB30004 526117 184 1.731034 3.18510256 Nitratidesulfovibrio vulgaris 881 Bacteria Bacteria 65.9 6.41e-11   NR WCB48144.1 881 g510490 i0 52.5 1.94021739130435 61 29 99.5 0 2 184 198 258 WCB48144.1 type IV secretory system conjugative DNA transfer family protein [Nitratidesulfovibrio vulgaris] diamond 357 65.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio vulgaris
31993099 31993099 PRJEB30004_P_NODE_640338_length_159_cov_1.058333_g624711_i0 PRJEB30004 640338 159 1.058333 1.68274947 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 80.1 9.38e-17   NR HVP80271.1 2202153 g624711 i0 71.2 2.94339622641509 52 15 98.1 0 3 158 126 177 HVP80271.1 alpha/beta hydrolase [Thermodesulfobacteriota bacterium] diamond 468 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota 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);;