RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA977246 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
4779264 4779264 PRJNA977246_S_NODE_20764_length_301_cov_4.088235_g19772_i0 PRJNA977246 20764 301 4.088235 12.30558735 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 131 4.41e-33   NR MEP7326841.1 2026742 g19772 i0 77.2 0.916943521594684 92 21 91.7 0 296 21 556 647 MEP7326841.1 protein kinase [Gemmatimonadota bacterium] diamond 276 131 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
6054365 6054365 PRJNA977246_S_NODE_21065_length_298_cov_3.498141_g20073_i0 PRJNA977246 21065 298 3.498141 10.42446018 Gemmatirosa sp. 2510638 Bacteria Bacteria 196 7.36e-60   NR HZF66602.1 2510638 g20073 i0 96.9 0.966442953020134 96 3 96.6 0 289 2 80 175 HZF66602.1 SPFH domain-containing protein [Gemmatirosa sp.] diamond 288 196 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
21671167 21671167 PRJNA977246_S_NODE_20337_length_305_cov_860.967391_g19345_i0 PRJNA977246 20337 305 860.967391 2625.95054255 Longimicrobiales bacterium 2910168 Bacteria Bacteria 98.6 1.68e-21   NR HEX6065740.1 2910168 g19345 i0 64.8 1.72131147540984 88 30 85.6 1 302 42 288 375 HEX6065740.1 FTR1 family protein [Longimicrobiales bacterium] diamond 525 98.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
26652157 26652157 PRJNA977246_S_NODE_23701_length_273_cov_3.688525_g22709_i0 PRJNA977246 23701 273 3.688525 10.06967325 Bacteria 2 Bacteria Bacteria 59.3 4.72e-8   NR MBI4421315.1 2026742 g22709 i0 60.8 2.76923076923077 51 18 53.8 1 149 3 42 92 MBI4421315.1 2-phosphosulfolactate phosphatase [Gemmatimonadota bacterium] diamond 756 59.7 0.993299832495812 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27405593 27405593 PRJNA977246_S_NODE_48083_length_158_cov_3.139535_g47091_i0 PRJNA977246 48083 158 3.139535 4.9604653 Gemmatirosa sp. 2510638 Bacteria Bacteria 99.8 3.89e-24   NR HZF67294.1 2510638 g47091 i0 90.4 0.987341772151899 52 5 98.7 0 2 157 66 117 HZF67294.1 nucleotidyltransferase domain-containing protein [Gemmatirosa sp.] diamond 156 99.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
28163273 28163273 PRJNA977246_S_NODE_30045_length_226_cov_3.609137_g29053_i0 PRJNA977246 30045 226 3.609137 8.15664962 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 111 1.71e-26   NR HQR18241.1 2448054 g29053 i0 70.7 3.98230088495575 75 22 99.6 0 225 1 459 533 HQR18241.1 protein kinase [Gemmatimonadales bacterium] diamond 900 111 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29552206 29552206 PRJNA977246_S_NODE_36390_length_195_cov_3.734940_g35398_i0 PRJNA977246 36390 195 3.73494 7.283133 Gemmatirosa sp. 2510638 Bacteria Bacteria 95.9 3.59e-23   NR HZF66787.1 2510638 g35398 i0 75.4 1 65 16 100 0 1 195 12 76 HZF66787.1 ferritin-like domain-containing protein [Gemmatirosa sp.] diamond 195 95.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
29779588 29779588 PRJNA977246_S_NODE_24971_length_262_cov_5.506438_g23979_i0 PRJNA977246 24971 262 5.506438 14.42686756 Bacteria 2 Bacteria Bacteria 47 0.00154   NR MFN9215176.1 2026742 g23979 i0 42.2 2.06106870229008 90 45 96.2 4 4 255 247 335 MFN9215176.1 hypothetical protein [Gemmatimonadota bacterium] diamond 540 47 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31606371 31606371 PRJNA977246_S_NODE_27356_length_244_cov_3.162791_g26364_i0 PRJNA977246 27356 244 3.162791 7.71721004 Gemmatirosa sp. 2510638 Bacteria Bacteria 79.7 6.24e-16   NR HZF67294.1 2510638 g26364 i0 90.9 0.540983606557377 44 4 54.1 0 111 242 1 44 HZF67294.1 nucleotidyltransferase domain-containing protein [Gemmatirosa sp.] diamond 132 79.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
32270861 32270861 PRJNA977246_S_NODE_44138_length_168_cov_4.510791_g43146_i0 PRJNA977246 44138 168 4.510791 7.57812888 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 82.4 1.38e-16   NR HOX21343.1 2448054 g43146 i0 81.3 3.41071428571429 48 9 85.7 0 23 166 207 254 HOX21343.1 hypothetical protein [Gemmatimonadales bacterium] diamond 573 82.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales 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);;