RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA667863", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA667863 · 7 ✖

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
18486374 18486374 PRJNA667863_P_NODE_18695_length_226_cov_2.013072_g18661_i0 PRJNA667863 18695 226 2.013072 4.54954272 Candidatus Electronema halotolerans 3036122 Bacteria Bacteria 130 9.03e-26   NTclustered gi|2322424479|emb|OW818675.1| 3036122 g18661 i0 84.058 79.8805309734513 138 18 60 4 1 136 110188 110053 Candidatus Electronema halotolerans isolate LOGT-cMAG genome assembly, chromosome: 1 blastn 18053 130 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electronema Candidatus Electronema halotolerans
26986546 26986546 PRJNA667863_P_NODE_2682_length_362_cov_1.996540_g2648_i0 PRJNA667863 2682 362 1.99654 7.2274748 Desulfobacterales bacterium 2044940 Bacteria Bacteria 123 3.9e-30   NR MBI5551554.1 2044940 g2648 i0 54.7 3.52209944751381 106 47 87.8 1 320 3 144 248 MBI5551554.1 MBL fold metallo-hydrolase [Desulfobacterales bacterium] diamond 1275 123 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
28072677 28072677 PRJNA667863_P_NODE_18205_length_230_cov_2.764331_g18171_i0 PRJNA667863 18205 230 2.764331 6.3579613 Pseudomonadati 3379134 Bacteria Bacteria 67.8 9.31e-13   NR WP_028587017.1 399548 g18171 i0 49.3 6.58695652173913 69 35 90 0 2 208 19 87 WP_028587017.1 RNA recognition motif domain-containing protein [Desulfocurvus vexinensis] diamond 1515 67.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvus Desulfocurvus vexinensis
28629259 28629259 PRJNA667863_P_NODE_9707_length_259_cov_2.446237_g9673_i0 PRJNA667863 9707 259 2.446237 6.33575383 Desulforegulaceae bacterium 3069247 Bacteria Bacteria 43.5 0.025   NR MDY0362168.1 3069247 g9673 i0 38 1.74903474903475 50 30 56.8 1 10 156 528 577 MDY0362168.1 conjugal transfer protein TraN [Desulforegulaceae bacterium] diamond 453 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulforegulaceae   Desulforegulaceae bacterium
28912967 28912967 PRJNA667863_P_NODE_7348_length_275_cov_2.153465_g7314_i0 PRJNA667863 7348 275 2.153465 5.92202875 Syntrophus sp. (in: bacteria) 48412 Bacteria Bacteria 56.2 9.35e-7   NR WP_367360148.1 48412 g7314 i0 46.3 2.4 54 28 58.9 1 97 258 139 191 WP_367360148.1 hypothetical protein [Syntrophus sp. (in: bacteria)] diamond 660 56.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus sp. (in: bacteria)
30176264 30176264 PRJNA667863_P_NODE_15512_length_243_cov_2.305882_g15478_i0 PRJNA667863 15512 243 2.305882 5.60329326 Desulfovibrio sp. 885 Bacteria Bacteria 43.5 0.0189   NR MDR1945846.1 885 g15478 i0 33.3 1 81 43 93.8 2 235 8 152 226 MDR1945846.1 phosphodiester glycosidase family protein [Desulfovibrio sp.] diamond 243 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30303230 30303230 PRJNA667863_P_NODE_16292_length_242_cov_0.911243_g16258_i0 PRJNA667863 16292 242 0.911243 2.20520806 Desulfuromonas sp. DDH964 1823759 Bacteria Bacteria 61.6 5.08e-9   NR WP_066727922.1 1823759 g16258 i0 47.6 3.19834710743802 84 33 91.7 3 240 19 37 119 WP_066727922.1 glycerophosphodiester phosphodiesterase [Desulfuromonas sp. DDH964] diamond 774 61.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964

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