RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA849822 · 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
2114087 2114087 PRJNA849822_P_NODE_35082_length_251_cov_0.876404_g34908_i0 PRJNA849822 35082 251 0.876404 2.19977404 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 121 6.149999999999999e-23   NTclustered gi|2874254120|emb|OY970205.1| 194844 g34908 i0 93.75 29.9800796812749 80 5 32 0 108 187 289839 289918 MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1 blastn 7525 121 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
8491370 8491370 PRJNA849822_P_NODE_15867_length_365_cov_0.890411_g15693_i0 PRJNA849822 15867 365 0.890411 3.25000015 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 54.7 0.01   NTclustered gi|2874254057|emb|OY970381.1| 194844 g15693 i0 92.5 0.10958904109589 40 0 11 3 259 298 1797994 1797958 MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 blastn 40 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
8491662 8491662 PRJNA849822_P_NODE_8487_length_519_cov_2.484305_g8315_i0 PRJNA849822 8487 519 2.484305 12.89354295 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 915 0   NTclustered gi|31789410|gb|AY281354.1| 171953 g8315 i0 98.459 285.368015414258 519 8 100 0 1 519 38454 37936 Uncultured Acidobacteria bacterium clone 38c7 genomic sequence blastn 148106 915 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
19085065 19085065 PRJNA849822_P_NODE_41155_length_244_cov_0.912281_g40981_i0 PRJNA849822 41155 244 0.912281 2.22596564 Pseudomonadati 3379134 Bacteria Bacteria 165 2.71e-36   NTclustered gi|2131947417|dbj|AP024452.2| 2802971 g40981 i0 79.508 94.2868852459016 244 40 98 10 4 241 2725641 2725880 Vicinamibacteria bacterium TBR-22 DNA, complete genome blastn 23006 165 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp. TBR-22

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