RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA728642" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA728642 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
8366119 8366119 PRJNA728642_P_NODE_18007_length_245_cov_0.895349_g17736_i0 PRJNA728642 18007 245 0.895349 2.19360505 Bergeyella sp. 1962306 Bacteria Bacteria 165 5.48e-46   NR MDL1912968.1 1962306 g17736 i0 92.6 1.98367346938776 81 6 99.2 0 2 244 442 522 MDL1912968.1 membrane protein insertase YidC [Bergeyella sp.] diamond 486 165 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Bergeyella Bergeyella sp.
27621123 27621123 PRJNA728642_P_NODE_17044_length_248_cov_0.880000_g16773_i0 PRJNA728642 17044 248 0.88 2.1824 Pedobacter xixiisoli 1476464 Bacteria Bacteria 143 3.04e-39   NR WP_240775092.1 1476464 g16773 i0 92.7 0.991935483870968 82 6 99.2 0 248 3 49 130 WP_240775092.1 MFS transporter [Pedobacter xixiisoli] diamond 246 143 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter xixiisoli
27947049 27947049 PRJNA728642_P_NODE_17305_length_247_cov_0.885057_g17034_i0 PRJNA728642 17305 247 0.885057 2.18609079 Larkinella 332157 Bacteria Bacteria 137 2.42e-35   NR WP_111626467.1 643671 g17034 i0 82.7 3.93522267206478 81 14 98.4 0 245 3 192 272 WP_111626467.1 ATP-binding protein [Larkinella arboricola] diamond 972 137 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Larkinella Larkinella arboricola
29168315 29168315 PRJNA728642_P_NODE_19269_length_242_cov_0.911243_g18998_i0 PRJNA728642 19269 242 0.911243 2.20520806 Pedobacter quisquiliarum 1834438 Bacteria Bacteria 134 4.17e-36   NR WP_188626485.1 1834438 g18998 i0 95.6 0.84297520661157 68 3 84.3 0 242 39 259 326 WP_188626485.1 DUF6427 family protein [Pedobacter quisquiliarum] diamond 204 134 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter quisquiliarum
29294402 29294402 PRJNA728642_P_NODE_12709_length_283_cov_1.090476_g12438_i0 PRJNA728642 12709 283 1.090476 3.08604708 Leeuwenhoekiella sp. MAR_2 1977054 Bacteria Bacteria 141 1e-37   NR WP_028375429.1 1392489 g12438 i0 79.3 0.92226148409894 87 18 92.2 0 266 6 351 437 WP_028375429.1 carbohydrate porin [Leeuwenhoekiella sp. MAR_2009_132] diamond 261 141 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Leeuwenhoekiella Leeuwenhoekiella sp. MAR_2009_132
29799505 29799505 PRJNA728642_P_NODE_16951_length_248_cov_0.880000_g16680_i0 PRJNA728642 16951 248 0.88 2.1824 Spirosoma terrae 1968276 Bacteria Bacteria 155 6.949999999999998e-42   NR WP_163946424.1 1968276 g16680 i0 96.3 0.991935483870968 82 3 99.2 0 3 248 899 980 WP_163946424.1 carboxypeptidase regulatory-like domain-containing protein [Spirosoma terrae] diamond 246 155 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Spirosoma Spirosoma terrae
30431874 30431874 PRJNA728642_P_NODE_13833_length_270_cov_2.243655_g13562_i0 PRJNA728642 13833 270 2.243655 6.0578685 Nubsella zeaxanthinifaciens 392412 Bacteria Bacteria 117 5.279999999999999e-31   NR WP_113635889.1 392412 g13562 i0 100 0.622222222222222 56 0 62.2 0 168 1 1 56 WP_113635889.1 hypothetical protein [Nubsella zeaxanthinifaciens] diamond 168 117 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Nubsella Nubsella zeaxanthinifaciens
31326515 31326515 PRJNA728642_P_NODE_19535_length_241_cov_0.916667_g19264_i0 PRJNA728642 19535 241 0.916667 2.20916747 Cytophagales 768507 Bacteria Bacteria 62.4 4.24e-9   NR MBC8154320.1 1871320 g19264 i0 53.7 1.34439834024896 54 25 67.2 0 4 165 400 453 MBC8154320.1 peptidoglycan synthetase [Fibrella sp.] diamond 324 62.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Fibrella Fibrella sp.
31759028 31759028 PRJNA728642_P_NODE_15877_length_251_cov_0.865169_g15606_i0 PRJNA728642 15877 251 0.865169 2.17157419 Hymenobacter sp. BT188 2763504 Bacteria Bacteria 159 1.99e-48   NR WP_187310571.1 2763504 g15606 i0 98.8 0.9800796812749 82 1 98 0 3 248 42 123 WP_187310571.1 four helix bundle protein [Hymenobacter sp. BT188] diamond 246 159 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp. BT188

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