RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473201 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
10648138 10648138 PRJNA473201_P_NODE_68349_length_250_cov_0.870056_g67607_i0 PRJNA473201 68349 250 0.870056 2.17514 Bacillati 1783272 Bacteria Bacteria 144 9.79e-41   NR MBP1931915.1 861532 g67607 i0 76.5 5.832 81 19 97.2 0 3 245 13 93 MBP1931915.1 TnpA family transposase [Ammoniphilus resinae] diamond 1458 145 0.993103448275862 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Ammoniphilus Ammoniphilus resinae
26823140 26823140 PRJNA473201_P_NODE_47241_length_298_cov_1.368889_g46499_i0 PRJNA473201 47241 298 1.368889 4.07928922 Streptococcus salivarius 1304 Bacteria Bacteria 42 0.0342   NR MFR2166121.1 1304 g46499 i0 30.6 0.724832214765101 72 49 71.5 1 78 290 16 87 MFR2166121.1 N-acetylglucosamine-6-phosphate deacetylase [Streptococcus salivarius] diamond 216 42 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
27186995 27186995 PRJNA473201_P_NODE_18602_length_459_cov_16.774611_g17860_i0 PRJNA473201 18602 459 16.774611 76.99546449 root 1 Root_unresolved Root_unresolved 114 1.1000000000000002e-28   NR WP_069142025.1 1313 g17860 i0 48.3 6.16993464052288 118 60 77.1 1 1 354 13 129 WP_069142025.1 LexA family protein, partial [Streptococcus pneumoniae] diamond 2832 114 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
27329176 27329176 PRJNA473201_P_NODE_76883_length_245_cov_1.255814_g76141_i0 PRJNA473201 76883 245 1.255814 3.0767443 Planococcus salinarum 622695 Bacteria Bacteria 60.8 3.46e-9   NR WP_071152043.1 622695 g76141 i0 47.2 2.75510204081633 72 34 85.7 3 4 213 72 141 WP_071152043.1 NUDIX domain-containing protein [Planococcus salinarum] diamond 675 60.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus salinarum
28339479 28339479 PRJNA473201_P_NODE_35546_length_334_cov_0.892720_g34804_i0 PRJNA473201 35546 334 0.89272 2.9816848 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 45.4 0.00982   NR MBR5931215.1 1898203 g34804 i0 38.5 0.70059880239521 78 38 70.1 2 16 249 140 207 MBR5931215.1 electron transfer flavoprotein subunit alpha/FixB family protein [Lachnospiraceae bacterium] diamond 234 45.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29381422 29381422 PRJNA473201_P_NODE_80709_length_243_cov_0.905882_g79967_i0 PRJNA473201 80709 243 0.905882 2.20129326 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0489   NR MBQ8600346.1 2044939 g79967 i0 36.2 0.716049382716049 58 28 71.6 1 24 197 326 374 MBQ8600346.1 ferrous iron transporter B [Clostridia bacterium] diamond 174 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30581491 30581491 PRJNA473201_P_NODE_85613_length_241_cov_0.916667_g84871_i0 PRJNA473201 85613 241 0.916667 2.20916747 Negativicutes bacterium 2499140 Bacteria Bacteria 52.4 1.33e-5   NR MBP9537542.1 2499140 g84871 i0 41.8 1.9792531120332 79 44 98.3 1 239 3 190 266 MBP9537542.1 DUF808 domain-containing protein [Negativicutes bacterium] diamond 477 52.4 1 Bacteria   Bacillati Bacillota Negativicutes       Negativicutes bacterium
30960956 30960956 PRJNA473201_P_NODE_44254_length_306_cov_10.974249_g43512_i0 PRJNA473201 44254 306 10.974249 33.58120194 Clostridia bacterium 2044939 Bacteria Bacteria 43.1 0.019   NR NCB34536.1 2044939 g43512 i0 42.9 0.411764705882353 42 24 41.2 0 85 210 65 106 NCB34536.1 TM2 domain-containing protein [Clostridia bacterium] diamond 126 43.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31181709 31181709 PRJNA473201_P_NODE_82915_length_242_cov_0.911243_g82173_i0 PRJNA473201 82915 242 0.911243 2.20520806 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 42.7 0.0371   NR MCL1903045.1 2485925 g82173 i0 40 0.681818181818182 55 28 68.2 1 33 197 387 436 MCL1903045.1 protein translocase subunit SecF [Oscillospiraceae bacterium] diamond 165 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
31751188 31751188 PRJNA473201_P_NODE_53017_length_284_cov_2.573460_g52275_i0 PRJNA473201 53017 284 2.57346 7.3086264 Clostridia bacterium 2044939 Bacteria Bacteria 103 5.77e-26   NR MDO4200306.1 2044939 g52275 i0 53.5 1.83802816901408 86 40 90.8 0 7 264 1 86 MDO4200306.1 hypothetical protein [Clostridia bacterium] diamond 522 103 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32099279 32099279 PRJNA473201_P_NODE_67098_length_251_cov_0.865169_g66356_i0 PRJNA473201 67098 251 0.865169 2.17157419 Bacillales bacterium 1904864 Bacteria Bacteria 133 6.1e-35   NR HET7627268.1 1904864 g66356 i0 81.9 1.9840637450199201 83 15 99.2 0 251 3 38 120 HET7627268.1 aspartate aminotransferase family protein [Bacillales bacterium] diamond 498 133 1 Bacteria   Bacillati Bacillota Bacilli Bacillales     Bacillales bacterium
32684325 32684325 PRJNA473201_P_NODE_66960_length_251_cov_0.865169_g66218_i0 PRJNA473201 66960 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 103 1.4600000000000002e-26   NR WP_258258424.1 137591 g66218 i0 86.9 2.18725099601594 61 8 72.9 0 250 68 31 91 WP_258258424.1 4Fe-4S dicluster domain-containing protein, partial [Weissella cibaria] diamond 549 103 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella cibaria

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