RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA940501" 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

  • PRJNA940501 · 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
3472892 3472892 PRJNA940501_S_NODE_81803_length_251_cov_1.980769_g80985_i0 PRJNA940501 81803 251 1.980769 4.97173019 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 364 2.57e-96   NTclustered gi|2874254027|emb|OY970352.1| 171953 g80985 i0 95.595 116.848605577689 227 10 90 0 24 250 2367572 2367346 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 29329 364 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
6024795 6024795 PRJNA940501_S_NODE_54985_length_278_cov_2.110638_g54167_i0 PRJNA940501 54985 278 2.110638 5.86757364 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 342 1.36e-89   NTclustered gi|217038907|gb|EU810998.1| 171953 g54167 i0 88.889 202.942446043165 279 30 100 1 1 278 333 55 Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence blastn 56418 342 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
6025032 6025032 PRJNA940501_S_NODE_68105_length_263_cov_2.709091_g67287_i0 PRJNA940501 68105 263 2.709091 7.12490933 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 52.8 0.024   NTclustered gi|2874253889|emb|OY970064.1| 194844 g67287 i0 100 0.106463878326996 28 0 11 0 210 237 1173474 1173447 MAG: uncultured Acidobacteriaceae bacterium isolate MFD06092.bin.c.1 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
8570562 8570562 PRJNA940501_S_NODE_112467_length_230_cov_1.759358_g111649_i0 PRJNA940501 112467 230 1.759358 4.0465234 Granulicella sp. 5B5 1617967 Bacteria Bacteria 54.7 0.006   NTclustered gi|1886125103|gb|CP046444.1| 1617967 g111649 i0 96.875 0.260869565217391 32 1 14 0 151 182 1625997 1625966 Granulicella sp. 5B5 chromosome, complete genome blastn 60 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella sp. 5B5
12397231 12397231 PRJNA940501_S_NODE_140830_length_215_cov_4.098837_g140012_i0 PRJNA940501 140830 215 4.098837 8.81249955 Geothrix sp. 21YS21S-2 3068893 Bacteria Bacteria 73.1 1.45e-8   NTclustered gi|2566094019|gb|CP132910.1| 3068893 g140012 i0 90.741 2.7906976744186 54 5 25 0 161 214 1471598 1471545 Geothrix sp. 21YS21S-2 chromosome, complete genome blastn 600 73.1 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. 21YS21S-2
18773144 18773144 PRJNA940501_S_NODE_46175_length_290_cov_7.125506_g45357_i0 PRJNA940501 46175 290 7.125506 20.6639674 uncultured Holophaga sp. 188475 Bacteria Bacteria 141 5.57e-29   NTclustered gi|2621785467|emb|OY781925.1| 188475 g45357 i0 79.5 3.93103448275862 200 39 69 2 92 290 2883088 2882890 MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1 blastn 1140 141 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Holophaga uncultured Holophaga sp.

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