RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA886442" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA886442 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
3412650 3412650 PRJNA886442_P_NODE_14263_length_244_cov_0.912281_g14099_i0 PRJNA886442 14263 244 0.912281 2.22596564 Edaphobacter flagellatus 1933044 Bacteria Bacteria 220 5.699999999999998e-53   NTclustered gi|2304905232|gb|CP073697.1| 1933044 g14099 i0 83.898 19.0409836065574 236 32 95 5 1 233 2718071 2718303 Edaphobacter flagellatus strain HZ411 chromosome, complete genome blastn 4646 220 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter flagellatus
17818997 17818997 PRJNA886442_P_NODE_1934_length_498_cov_2.061176_g1770_i0 PRJNA886442 1934 498 2.061176 10.26465648 Acidobacteriaceae 204434 Bacteria Bacteria 704 0   NTclustered gi|1799576755|gb|CP042596.1| 2602070 g1770 i0 92.169 112.373493975904 498 39 100 0 1 498 397690 398187 Granulicella sp. WH15 chromosome, complete genome blastn 55962 710 0.991549295774648 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella sp. WH15
25087966 25087966 PRJNA886442_P_NODE_1680_length_534_cov_11.440347_g1516_i0 PRJNA886442 1680 534 11.440347 61.09145298 Terriglobus roseus 392734 Bacteria Bacteria 953 0   NTclustered gi|1085637902|emb|LT629690.1| 392734 g1516 i0 98.876 110.101123595506 534 6 100 0 1 534 4806997 4807530 Terriglobus roseus strain GAS232 genome assembly, chromosome: I blastn 58794 953 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus

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