RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Calditrichota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Calditrichota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA704949 · 7 ✖

analysis 1

  • diamond · 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
9629814 9629814 PRJNA704949_P_NODE_836108_length_290_cov_1.838174_g820774_i0 PRJNA704949 836108 290 1.838174 5.3307046 Pseudomonadati 3379134 Bacteria Bacteria 139 1.0799999999999998e-37   NR OGB68390.1 1797576 g820774 i0 78.4 9.35172413793103 88 19 91 0 266 3 129 216 OGB68390.1 MAG: hypothetical protein A2Y94_04395 [Caldithrix sp. RBG_13_44_9] diamond 2712 140 0.992857142857143 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix sp. RBG_13_44_9
27030703 27030703 PRJNA704949_P_NODE_1252862_length_226_cov_1.175141_g1237525_i0 PRJNA704949 1252862 226 1.175141 2.65581866 Pseudomonadati 3379134 Bacteria Bacteria 47.4 6.56e-4   NR MCB9086918.1 2268178 g1237525 i0 60.6 1.20796460176991 33 13 43.8 0 2 100 242 274 MCB9086918.1 sterol desaturase family protein [Calditrichia bacterium] diamond 273 47.4 1 Bacteria   Pseudomonadati Calditrichota Calditrichia       Calditrichia bacterium
28598947 28598947 PRJNA704949_P_NODE_119507_length_727_cov_2.935103_g106613_i0 PRJNA704949 119507 727 2.935103 21.33819881 Calditrichota bacterium 2212469 Bacteria Bacteria 248 8.74e-77   NR MCB0260289.1 2212469 g106613 i0 60.6 5.84319119669876 203 78 82.9 2 704 102 206 408 MCB0260289.1 glycosyltransferase family 4 protein [Calditrichota bacterium] diamond 4248 248 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
30599430 30599430 PRJNA704949_P_NODE_72953_length_901_cov_4.354460_g61330_i0 PRJNA704949 72953 901 4.35446 39.2336846 Bacteria 2 Bacteria Bacteria 128 5.72e-32   NR MCK4560096.1 2268178 g61330 i0 39.7 2.3607103218646 179 74 58.9 3 341 871 42 188 MCK4560096.1 hypothetical protein [Calditrichia bacterium] diamond 2127 128 1 Bacteria   Pseudomonadati Calditrichota Calditrichia       Calditrichia bacterium
31294752 31294752 PRJNA704949_P_NODE_946155_length_269_cov_1.890909_g930820_i0 PRJNA704949 946155 269 1.890909 5.08654521 root 1 Root_unresolved Root_unresolved 87.8 5.46e-18   NR MCB0278977.1 2212469 g930820 i0 52.5 2.76579925650558 80 38 89.2 0 30 269 255 334 MCB0278977.1 guanine deaminase [Calditrichota bacterium] diamond 744 87.8 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
32359583 32359583 PRJNA704949_P_NODE_1453799_length_205_cov_1.333333_g1438461_i0 PRJNA704949 1453799 205 1.333333 2.73333265 Calditrichota bacterium 2212469 Bacteria Bacteria 62.4 2.68e-9   NR RMF66691.1 2212469 g1438461 i0 46.2 0.951219512195122 65 35 95.1 0 8 202 443 507 RMF66691.1 MAG: HAMP domain-containing protein, partial [Calditrichota bacterium] diamond 195 62.4 1 Bacteria   Pseudomonadati Calditrichota         Calditrichota bacterium
32391056 32391056 PRJNA704949_P_NODE_1771999_length_179_cov_2.561538_g1756660_i0 PRJNA704949 1771999 179 2.561538 4.58515302 Caldithrix sp. 1962856 Bacteria Bacteria 46.2 9.33e-4   NR TDI96034.1 1962856 g1756660 i0 48.9 1.75977653631285 45 23 75.4 0 178 44 240 284 TDI96034.1 MAG: T9SS type A sorting domain-containing protein [Caldithrix sp.] diamond 315 46.2 1 Bacteria   Pseudomonadati Calditrichota Calditrichia Calditrichales Calditrichaceae Caldithrix Caldithrix 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);;