RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA758087" 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

  • PRJNA758087 · 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
27400740 27400740 PRJNA758087_P_NODE_22043_length_565_cov_21.855691_g20729_i0 PRJNA758087 22043 565 21.855691 123.48465415 Longimicrobium sp. 2029185 Bacteria Bacteria 114 1.34e-29   NR HEX6910714.1 2029185 g20729 i0 90 0.31858407079646 60 6 31.9 0 294 115 1 60 HEX6910714.1 hypothetical protein [Longimicrobium sp.] diamond 180 114 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28221381 28221381 PRJNA758087_P_NODE_29686_length_416_cov_4.297376_g28366_i0 PRJNA758087 29686 416 4.297376 17.87708416 Longimicrobium sp. 2029185 Bacteria Bacteria 241 1.4e-77   NR HEX6912734.1 2029185 g28366 i0 90 0.9375 130 13 93.8 0 3 392 141 270 HEX6912734.1 hypothetical protein [Longimicrobium sp.] diamond 390 241 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28789734 28789734 PRJNA758087_P_NODE_41607_length_251_cov_1.134831_g40287_i0 PRJNA758087 41607 251 1.134831 2.84842581 Gemmatirosa sp. 2510638 Bacteria Bacteria 57 3.7e-7   NR HEY0779517.1 2510638 g40287 i0 85.7 0.741035856573705 28 4 33.5 0 250 167 359 386 HEY0779517.1 IS481 family transposase [Gemmatirosa sp.] diamond 186 57 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
28821148 28821148 PRJNA758087_P_NODE_37948_length_297_cov_1.642857_g36628_i0 PRJNA758087 37948 297 1.642857 4.87928529 Gemmatirosa sp. 2510638 Bacteria Bacteria 200 5.1899999999999995e-62   NR HZF66553.1 2510638 g36628 i0 91.8 0.98989898989899 98 8 99 0 296 3 43 140 HZF66553.1 protein kinase [Gemmatirosa sp.] diamond 294 200 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
29137459 29137459 PRJNA758087_P_NODE_37069_length_308_cov_1.893617_g35749_i0 PRJNA758087 37069 308 1.893617 5.83234036 Gemmatirosa sp. 2510638 Bacteria Bacteria 92.4 2.2e-20   NR HZF68683.1 2510638 g35749 i0 100 0.409090909090909 42 0 40.9 0 307 182 206 247 HZF68683.1 hypothetical protein [Gemmatirosa sp.] diamond 126 92.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
29232028 29232028 PRJNA758087_P_NODE_28509_length_437_cov_1.115385_g27189_i0 PRJNA758087 28509 437 1.115385 4.87423245 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 179 1.18e-49   NR GJG87148.1 2839016 g27189 i0 72.1 1.86727688787185 136 37 92.7 1 3 407 226 361 GJG87148.1 fatty acid oxidation complex subunit alpha [Gemmatimonadetes bacterium T265] diamond 816 179 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265
29484248 29484248 PRJNA758087_P_NODE_25470_length_493_cov_1.328571_g24150_i0 PRJNA758087 25470 493 1.328571 6.54985503 Gemmatimonas sp. 1962908 Bacteria Bacteria 201 1.85e-56   NR WP_291263654.1 1962908 g24150 i0 62.3 4.68559837728195 154 58 93.7 0 463 2 460 613 WP_291263654.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonas sp.] diamond 2310 201 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
30179223 30179223 PRJNA758087_P_NODE_6532_length_1312_cov_13.832930_g5683_i0 PRJNA758087 6532 1312 13.83293 181.4880416 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 143 1.2e-36   NR HEX6926041.1 3047548 g5683 i0 57.1 0.240091463414634 105 45 24 0 814 500 90 194 HEX6926041.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 315 143 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30274394 30274394 PRJNA758087_P_NODE_18032_length_667_cov_9.841751_g16749_i0 PRJNA758087 18032 667 9.841751 65.64447917 Longimicrobium sp. 2029185 Bacteria Bacteria 287 6.19e-93   NR HVH11520.1 2029185 g16749 i0 86.2 0.782608695652174 174 24 78.3 0 643 122 206 379 HVH11520.1 IS4 family transposase [Longimicrobium sp.] diamond 522 287 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31759686 31759686 PRJNA758087_P_NODE_42377_length_248_cov_0.880000_g41057_i0 PRJNA758087 42377 248 0.88 2.1824 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 117 1.56e-28   NR HUR94818.1 2448054 g41057 i0 69.1 1.95967741935484 81 25 98 0 3 245 75 155 HUR94818.1 molybdopterin cofactor-binding domain-containing protein [Gemmatimonadales bacterium] diamond 486 117 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);;