RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA846486" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA846486 · 5 ✖

analysis 1

  • blastn · 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
8884495 8884495 PRJNA846486_P_NODE_55687_length_190_cov_1.475177_g55591_i0 PRJNA846486 55687 190 1.475177 2.8028363 Terriglobales 204433 Bacteria Bacteria 69.4 1.62e-7   NTclustered gi|2874253802|emb|OY969786.1| 194844 g55591 i0 100 12.5894736842105 37 0 19 0 21 57 1552930 1552894 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09671.bin.c.1 genome assembly, chromosome: 1 blastn 2392 69.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
12312433 12312433 PRJNA846486_P_NODE_50210_length_198_cov_1.006711_g50114_i0 PRJNA846486 50210 198 1.006711 1.99328778 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 147 7.65e-31   NTclustered gi|2874253678|emb|OY969112.1| 171953 g50114 i0 81.283 3.35353535353535 187 29 93 5 6 189 5390645 5390828 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 664 147 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
12312541 12312541 PRJNA846486_P_NODE_88550_length_164_cov_0.904348_g88454_i0 PRJNA846486 88550 164 0.904348 1.48313072 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 126 7.9499999999999995e-25   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g88454 i0 80.723 1.01219512195122 166 28 100 4 1 164 382675 382838 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 166 126 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
14861294 14861294 PRJNA846486_P_NODE_88312_length_164_cov_0.904348_g88216_i0 PRJNA846486 88312 164 0.904348 1.48313072 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 82.4 1.75e-11   NTclustered gi|2874254049|emb|OY970373.1| 171953 g88216 i0 85.542 0.50609756097561 83 6 49 6 30 109 2474349 2474270 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 83 82.4 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
25059450 25059450 PRJNA846486_P_NODE_41840_length_212_cov_0.957055_g41744_i0 PRJNA846486 41840 212 0.957055 2.0289566 Luteitalea pratensis 1855912 Bacteria Bacteria 176 1.06e-39   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g41744 i0 82.587 91.3490566037736 201 33 94 2 8 207 4794340 4794141 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 19366 176 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis

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