RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1151638" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1151638 · 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
1037009 1037009 PRJNA1151638_P_NODE_5781_length_247_cov_0.896552_g5714_i0 PRJNA1151638 5781 247 0.896552 2.21448344 Bacteria 2 Bacteria Bacteria 62.1 3.71e-5   NTclustered gi|297170971|gb|GU567972.1| 723556 g5714 i0 86.207 23.3684210526316 58 7 23 1 191 247 29197 29140 Uncultured myxobacterium HF0200_01L06 genomic sequence blastn 5772 62.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     uncultured myxobacterium HF0200_01L06
18888490 18888490 PRJNA1151638_P_NODE_195_length_1011_cov_5.566098_g149_i0 PRJNA1151638 195 1011 5.566098 56.27325078 Sorangium 39643 Bacteria Bacteria 1269 0   NTclustered gi|1566478966|gb|CP012672.1| 56 g149 i0 89.318 159.552917903066 1011 108 100 0 1 1011 4328267 4329277 Sorangium cellulosum strain So ce836 chromosome, complete genome blastn 161308 1269 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
20703408 20703408 PRJNA1151638_P_NODE_5297_length_249_cov_4.909091_g5230_i0 PRJNA1151638 5297 249 4.909091 12.22363659 Polyangium aurulentum 2567896 Bacteria Bacteria 235 2.08e-57   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g5230 i0 85.841 57.0160642570281 226 27 89 5 28 249 11727332 11727108 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 14197 235 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum

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