RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA529924" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA529924 · 5 ✖

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
16420025 16420025 PRJNA529924_P_NODE_3973_length_195_cov_1.692771_g3799_i0 PRJNA529924 3973 195 1.692771 3.30090345 Limosilactobacillus 2742598 Bacteria Bacteria 346 6.9e-91   NTclustered gi|2459461436|gb|CP119425.1| 1613 g3799 i0 98.485 99.7692307692308 198 0 100 1 1 195 1035119 1034922 Limosilactobacillus fermentum strain KUFM408 chromosome, complete genome blastn 19455 346 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus fermentum
20243714 20243714 PRJNA529924_P_NODE_296_length_1146_cov_12.971352_g229_i0 PRJNA529924 296 1146 12.971352 148.65169392 Bacillales 1385 Bacteria Bacteria 1585 0   NTclustered gi|2692800537|gb|CP146065.1| 1283 g229 i0 91.732 502.177137870855 1149 84 99 10 2 1146 772955 771814 Staphylococcus haemolyticus strain SPS12 chromosome, complete genome blastn 575495 1585 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
25343610 25343610 PRJNA529924_P_NODE_3200_length_236_cov_1.492754_g3026_i0 PRJNA529924 3200 236 1.492754 3.52289944 Clostridium 1485 Bacteria Bacteria 54.7 0.006   NTclustered gi|2331091137|gb|CP110856.1| 1534 g3026 i0 100 0.491525423728814 29 0 12 0 142 170 2245442 2245414 Clostridium kluyveri strain BJN0002 chromosome, complete genome blastn 116 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium kluyveri
29256301 29256301 PRJNA529924_P_NODE_4409_length_178_cov_1.275168_g4235_i0 PRJNA529924 4409 178 1.275168 2.26979904 Bacillota bacterium 1879010 Bacteria Bacteria 43.5 0.00778   NR HBG15780.1 1879010 g4235 i0 54.8 4.95505617977528 42 19 70.8 0 178 53 196 237 HBG15780.1 peptidoglycan-binding protein LysM [Bacillota bacterium] diamond 882 43.5 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31025541 31025541 PRJNA529924_P_NODE_2555_length_291_cov_1.839695_g2381_i0 PRJNA529924 2555 291 1.839695 5.35351245 Bacillota bacterium 1879010 Bacteria Bacteria 42 0.014   NR NLL58111.1 1879010 g2381 i0 38.9 0.556701030927835 54 26 55.7 2 213 52 3 49 NLL58111.1 50S ribosomal protein L28 [Bacillota bacterium] diamond 162 42 1 Bacteria   Bacillati Bacillota         Bacillota 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);;