RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Minisyncoccota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Minisyncoccota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA556992 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 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
525483 525483 PRJNA556992_P_NODE_21061_length_738_cov_2.314286_g19115_i0 PRJNA556992 21061 738 2.314286 17.07943068 Candidatus Minusculum obligatum 1948790 Bacteria Bacteria 678 0   NTclustered gi|2862534883|gb|CP174360.1| 1948790 g19115 i0 83.934 151.651761517615 722 102 97 13 22 737 191634 190921 MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome blastn 111919 678 1 Bacteria Bacteria candidate phyla   Minisyncoccota Minisyncoccia Candidatus Phycocordibacterales Candidatus Phycocordibacteraceae Candidatus Minusculum Candidatus Minusculum obligatum
17112231 17112231 PRJNA556992_P_NODE_90134_length_418_cov_2.991304_g87951_i0 PRJNA556992 90134 418 2.991304 12.50365072 Candidatus Phycocordibacter aenigmaticus 1948796 Bacteria Bacteria 477 5.599999999999999e-130   NTclustered gi|2862534145|gb|CP174359.1| 1948796 g87951 i0 87.5 49.1315789473684 416 48 99 4 1 414 75449 75036 MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome blastn 20537 477 1 Bacteria Bacteria candidate phyla   Minisyncoccota Minisyncoccia Candidatus Phycocordibacterales Candidatus Phycocordibacteraceae Candidatus Phycocordibacter Candidatus Phycocordibacter aenigmaticus
18375314 18375314 PRJNA556992_P_NODE_113735_length_389_cov_4.626582_g111549_i0 PRJNA556992 113735 389 4.626582 17.99740398 Candidatus Phycocordibacter aenigmaticus 1948796 Bacteria Bacteria 339 2.5499999999999997e-88   NTclustered gi|2862534145|gb|CP174359.1| 1948796 g111549 i0 88.462 30.9460154241645 286 26 72 6 6 286 75388 75671 MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome blastn 12038 339 1 Bacteria Bacteria candidate phyla   Minisyncoccota Minisyncoccia Candidatus Phycocordibacterales Candidatus Phycocordibacteraceae Candidatus Phycocordibacter Candidatus Phycocordibacter aenigmaticus

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