RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB9859" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB9859 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2695181 2695181 PRJEB9859_P_NODE_6523_length_221_cov_4.125000_g6488_i0 PRJEB9859 6523 221 4.125 9.11625 Geothrix sp. PMB-07 3068640 Bacteria Bacteria 52.8 0.02   NTclustered gi|2563347696|gb|CP132333.1| 3068640 g6488 i0 100 0.380090497737557 28 0 13 0 72 99 473717 473690 Geothrix sp. PMB-07 chromosome, complete genome blastn 84 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. PMB-07
6523238 6523238 PRJEB9859_P_NODE_2386_length_302_cov_153.076923_g2351_i0 PRJEB9859 2386 302 153.076923 462.29230746 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 130 1.26e-25   NTclustered gi|217038907|gb|EU810998.1| 171953 g2351 i0 97.403 21.476821192053 77 1 25 1 213 288 206 282 Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence blastn 6486 130 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
11623477 11623477 PRJEB9859_P_NODE_1210_length_371_cov_61.695906_g1176_i0 PRJEB9859 1210 371 61.695906 228.89181126 Thermotomaculum hydrothermale 981385 Bacteria Bacteria 86.1 3.48e-12   NTclustered gi|1941646770|dbj|AP017470.1| 981385 g1176 i0 96.154 52.2991913746631 52 2 22 0 46 97 1449802 1449853 Thermotomaculum hydrothermale DNA, complete genome, strain: AC55 blastn 19403 86.1 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Thermotomaculales Thermotomaculaceae Thermotomaculum Thermotomaculum hydrothermale
14173576 14173576 PRJEB9859_P_NODE_6012_length_235_cov_154.475728_g5977_i0 PRJEB9859 6012 235 154.475728 363.0179608 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 130 9.46e-26   NTclustered gi|217038907|gb|EU810998.1| 171953 g5977 i0 97.403 28.1531914893617 77 1 32 1 15 90 282 206 Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence blastn 6616 130 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
16721832 16721832 PRJEB9859_P_NODE_6354_length_226_cov_187.578680_g6319_i0 PRJEB9859 6354 226 187.57868 423.9278168 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 209 1.13e-49   NTclustered gi|2874253885|emb|OY970060.1| 171953 g6319 i0 85.167 31.8008849557522 209 25 90 4 4 207 4839278 4839071 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 7187 209 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
21821745 21821745 PRJEB9859_P_NODE_1978_length_320_cov_4.085911_g1943_i0 PRJEB9859 1978 320 4.085911 13.0749152 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 95.3 4.92e-15   NTclustered gi|2874253940|emb|OY970265.1| 171953 g1943 i0 98.148 27.45 54 1 17 0 160 213 5241082 5241029 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1 blastn 8784 95.3 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;