RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1159911" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1159911 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27893136 27893136 PRJNA1159911_P_NODE_92945_length_247_cov_0.885057_g92403_i0 PRJNA1159911 92945 247 0.885057 2.18609079 Smithella sp. F21 1538640 Bacteria Bacteria 143 5.9e-38   NR KFN37787.1 1538640 g92403 i0 84.1 0.995951417004049 82 13 99.6 0 247 2 284 365 KFN37787.1 hypothetical protein KN63_08110 [Smithella sp. F21] diamond 246 143 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp. F21
28146047 28146047 PRJNA1159911_P_NODE_685_length_4721_cov_4.652754_g659_i0 PRJNA1159911 685 4721 4.652754 219.65651634 Syntrophotalea acetylenica 29542 Bacteria Bacteria 307 2.2599999999999997e-88   NR MDD4456620.1 29542 g659 i0 40.8 0.284685447998305 448 244 28.2 8 2018 687 28 458 MDD4456620.1 ATPase, T2SS/T4P/T4SS family [Syntrophotalea acetylenica] diamond 1344 307 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea acetylenica
30640538 30640538 PRJNA1159911_P_NODE_2133_length_2464_cov_4.903388_g2023_i0 PRJNA1159911 2133 2464 4.903388 120.81948032 uncultured Desulfuromusa sp. 219183 Bacteria Bacteria 202 9.49e-51   NR WP_321392226.1 219183 g2023 i0 30.5 0.566152597402597 465 292 53.8 10 2433 1108 282 738 WP_321392226.1 DotA/TraY family protein [uncultured Desulfuromusa sp.] diamond 1395 202 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae Desulfuromusa uncultured Desulfuromusa sp.
31747049 31747049 PRJNA1159911_P_NODE_95637_length_245_cov_0.895349_g95095_i0 PRJNA1159911 95637 245 0.895349 2.19360505 Candidatus Electrothrix aestuarii 3062594 Bacteria Bacteria 63.2 2.47e-9   NR XCN75363.1 3062594 g95095 i0 44.3 2.20408163265306 61 33 73.5 1 184 5 956 1016 XCN75363.1 MAG: WD40 repeat domain-containing protein [Candidatus Electrothrix aestuarii] diamond 540 63.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix aestuarii

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