RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1192965 · 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
1042364 1042364 PRJNA1192965_P_NODE_1_length_3180_cov_34.790795_g0_i0 PRJNA1192965 1 3180 34.790795 1106.347281 Ruminococcus sp. XPD3 41978 Bacteria Bacteria 1895 0   NR WP_075424065.1 1452269 g0 i0 100 0.911320754716981 966 0 91.1 0 2997 100 2 967 WP_075424065.1 type VI-D CRISPR-associated RNA-guided ribonuclease Cas13d [Ruminococcus sp. XPD3002] diamond 2898 1895 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp. XPD3002
30546296 30546296 PRJNA1192965_P_NODE_3793_length_248_cov_1.468571_g3774_i0 PRJNA1192965 3793 248 1.468571 3.64205608 Clostridia bacterium 2044939 Bacteria Bacteria 72.4 1.25e-12   NR MBR0463171.1 2044939 g3774 i0 52.6 4.65725806451613 76 30 85.9 3 36 248 222 296 MBR0463171.1 glycoside hydrolase family 125 protein [Clostridia bacterium] diamond 1155 72.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31620919 31620919 PRJNA1192965_P_NODE_2916_length_262_cov_1.629630_g2897_i0 PRJNA1192965 2916 262 1.62963 4.2696306 unclassified Oceanobacillus 2630292 Bacteria Bacteria 42.7 0.0453   NR WP_156858045.1 2630292 g2897 i0 30.6 0.709923664122137 62 43 71 0 234 49 149 210 WP_156858045.1 MULTISPECIES: ribosome biogenesis GTPase YqeH [unclassified Oceanobacillus] diamond 186 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Oceanobacillus  
31652423 31652423 PRJNA1192965_P_NODE_4057_length_247_cov_0.885057_g4038_i0 PRJNA1192965 4057 247 0.885057 2.18609079 Bacilli bacterium 1903720 Bacteria Bacteria 42 0.0235   NR GHU29446.1 1903720 g4038 i0 37.5 0.777327935222672 64 32 71.7 4 198 22 4 64 GHU29446.1 hypothetical protein FACS1894152_7770 [Bacilli bacterium] diamond 192 42 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31779030 31779030 PRJNA1192965_P_NODE_1157_length_369_cov_4.905405_g1138_i0 PRJNA1192965 1157 369 4.905405 18.10094445 Brevibacillus fulvus 1125967 Bacteria Bacteria 137 3.71e-39   NR WP_204516782.1 1125967 g1138 i0 61.7 0.869918699186992 107 41 87 0 41 361 2 108 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 321 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
31873985 31873985 PRJNA1192965_P_NODE_2997_length_259_cov_1.956989_g2978_i0 PRJNA1192965 2997 259 1.956989 5.06860151 Bacilli bacterium 1903720 Bacteria Bacteria 120 7.2e-30   NR MBP3799570.1 1903720 g2978 i0 66.3 1.93436293436293 83 28 96.1 0 6 254 102 184 MBP3799570.1 dynamin family protein [Bacilli bacterium] diamond 501 120 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32063787 32063787 PRJNA1192965_P_NODE_1278_length_356_cov_1.088339_g1259_i0 PRJNA1192965 1278 356 1.088339 3.87448684 Symbiobacteriaceae bacterium 2602712 Bacteria Bacteria 109 4.07e-26   NR MDF2629472.1 2602712 g1259 i0 44.4 0.985955056179775 117 62 98.6 2 352 2 38 151 MDF2629472.1 zinc-binding dehydrogenase [Symbiobacteriaceae bacterium] diamond 351 109 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae   Symbiobacteriaceae 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);;