RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB48872 · 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
6468817 6468817 PRJEB48872_P_NODE_693626_length_151_cov_1.008929_g677814_i0 PRJEB48872 693626 151 1.008929 1.52348279 Polyangium aurulentum 2567896 Bacteria Bacteria 235 1.14e-57   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g677814 i0 94.702 211.682119205298 151 8 100 0 1 151 442384 442234 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 31964 235 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum
10281556 10281556 PRJEB48872_P_NODE_442529_length_213_cov_1.413793_g426717_i0 PRJEB48872 442529 213 1.413793 3.01137909 Sorangium cellulosum 56 Bacteria Bacteria 58.4 4.03e-4   NTclustered gi|1338588479|gb|CP012673.1| 56 g426717 i0 94.595 0.173708920187793 37 2 17 0 7 43 5718077 5718041 Sorangium cellulosum strain So ce26 chromosome, complete genome blastn 37 58.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
13744016 13744016 PRJEB48872_P_NODE_157351_length_464_cov_1.604706_g141582_i0 PRJEB48872 157351 464 1.604706 7.44583584 Polyangiaceae 49 Bacteria Bacteria 680 0   NTclustered gi|1566478966|gb|CP012672.1| 56 g141582 i0 93.103 167.907327586207 464 32 100 0 1 464 11964626 11965089 Sorangium cellulosum strain So ce836 chromosome, complete genome blastn 77909 680 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum

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