RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJEB49404 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
9038566 9038566 PRJEB49404_P_NODE_514108_length_178_cov_1.755396_g500307_i0 PRJEB49404 514108 178 1.755396 3.12460488 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 107 1.02e-27   NR MEF8823062.1 2683721 g500307 i0 96.6 0.99438202247191 59 2 99.4 0 177 1 15 73 MEF8823062.1 transcription elongation factor GreA [Desulfohalobiaceae bacterium] diamond 177 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27665568 27665568 PRJEB49404_P_NODE_650904_length_150_cov_1.477477_g637103_i0 PRJEB49404 650904 150 1.477477 2.2162155 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 72.4 3.05e-13   NR MEF8822769.1 2683721 g637103 i0 85 0.8 40 5 80 1 120 1 259 297 MEF8822769.1 phosphate acyltransferase PlsX [Desulfohalobiaceae bacterium] diamond 120 72.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27854791 27854791 PRJEB49404_P_NODE_594805_length_160_cov_2.024793_g581004_i0 PRJEB49404 594805 160 2.024793 3.2396688 Desulfobacter hydrogenophilus 2291 Bacteria Bacteria 100 1.38e-25   NR WP_282959083.1 2291 g581004 i0 100 0.99375 53 0 99.4 0 2 160 66 118 WP_282959083.1 histidine kinase dimerization/phospho-acceptor domain-containing protein, partial [Desulfobacter hydrogenophilus] diamond 159 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter Desulfobacter hydrogenophilus
29174371 29174371 PRJEB49404_P_NODE_637669_length_152_cov_1.867257_g623868_i0 PRJEB49404 637669 152 1.867257 2.83823064 Desulfonatronovibrionaceae 3031459 Bacteria Bacteria 47.8 1.8e-4   NR WP_045217375.1 698827 g623868 i0 71.4 1.10526315789474 28 8 55.3 0 86 3 2 29 WP_045217375.1 hypothetical protein [Desulfonatronovibrio magnus] diamond 168 47.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronovibrionaceae Desulfonatronovibrio Desulfonatronovibrio magnus
29907309 29907309 PRJEB49404_P_NODE_648131_length_150_cov_2.585586_g634330_i0 PRJEB49404 648131 150 2.585586 3.878379 Desulfobacterium sp. 4572_2 2067988 Bacteria Bacteria 49.7 3.58e-5   NR OQY16229.1 1971621 g634330 i0 51 1.96 49 24 98 0 148 2 73 121 OQY16229.1 MAG: hypothetical protein B6I32_03970 [Desulfobacterium sp. 4572_20] diamond 294 49.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium Desulfobacterium sp. 4572_20
30444421 30444421 PRJEB49404_P_NODE_584973_length_162_cov_1.869919_g571172_i0 PRJEB49404 584973 162 1.869919 3.02926878 uncultured Desulfobacter sp. 240139 Bacteria Bacteria 43.5 0.00114   NR WP_321495063.1 240139 g571172 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.
30507503 30507503 PRJEB49404_P_NODE_602853_length_159_cov_1.058333_g589052_i0 PRJEB49404 602853 159 1.058333 1.68274947 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 80.1 9.38e-17   NR HVP80271.1 2202153 g589052 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
30532279 30532279 PRJEB49404_P_NODE_552673_length_169_cov_1.546154_g538872_i0 PRJEB49404 552673 169 1.546154 2.61300026 Pseudomonadati 3379134 Bacteria Bacteria 69.7 4.09e-12   NR WCB48155.1 881 g538872 i0 59.2 2.73372781065089 49 20 87 0 167 21 573 621 WCB48155.1 hypothetical protein PH214_16050 [Nitratidesulfovibrio vulgaris] diamond 462 70.1 0.994293865905849 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio vulgaris
30949956 30949956 PRJEB49404_P_NODE_575774_length_164_cov_1.640000_g561973_i0 PRJEB49404 575774 164 1.64 2.6896 Syntrophotalea acetylenica 29542 Bacteria Bacteria 66.2 6.39e-11   NR MDD4456268.1 29542 g561973 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
31582244 31582244 PRJEB49404_P_NODE_377996_length_223_cov_1.543478_g364195_i0 PRJEB49404 377996 223 1.543478 3.44195594 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 50.1 7.33e-5   NR HZX13631.1 2202153 g364195 i0 35.9 2.50224215246637 64 41 86.1 0 11 202 304 367 HZX13631.1 3-dehydroquinate synthase [Thermodesulfobacteriota bacterium] diamond 558 50.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);;