RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
168893 168893 PRJNA1035005_P_NODE_49221_length_258_cov_1.410811_g48815_i0 PRJNA1035005 49221 258 1.410811 3.63989238 Geothrix oryzae 2927975 Bacteria Bacteria 206 1.6999999999999998e-48   NTclustered gi|2490888707|dbj|AP027079.1| 2927975 g48815 i0 84.615 77.5542635658915 208 30 80 2 1 207 542615 542409 Geothrix oryzae Red222 DNA, complete genome blastn 20009 206 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix oryzae
19294901 19294901 PRJNA1035005_P_NODE_76036_length_245_cov_0.906977_g75630_i0 PRJNA1035005 76036 245 0.906977 2.22209365 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 63.9 1.02e-5   NTclustered gi|2874253677|emb|OY969111.1| 171953 g75630 i0 97.297 1.08571428571429 37 1 15 0 81 117 3067569 3067533 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 blastn 266 63.9 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
21845865 21845865 PRJNA1035005_P_NODE_52978_length_253_cov_1.733333_g52572_i0 PRJNA1035005 52978 253 1.733333 4.38533249 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 462 8.95e-126   NTclustered gi|76574296|gb|DQ139444.1| 171953 g52572 i0 99.605 102.648221343874 253 1 100 0 1 253 789 1041 Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence blastn 25970 462 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
24394882 24394882 PRJNA1035005_P_NODE_37480_length_273_cov_1.195000_g37074_i0 PRJNA1035005 37480 273 1.195 3.26235 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 119 2.44e-22   NTclustered gi|2626289183|emb|OY843586.1| 2052142 g37074 i0 94.737 32.6630036630037 76 4 28 0 10 85 4947046 4946971 MAG: Acidobacteriaceae bacterium isolate 6f8c9a11-1c30-45b4-a4a5-28695f68a2e2 genome assembly, chromosome: 1 blastn 8917 119 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae 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);;