RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA641707 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
21559922 21559922 PRJNA641707_P_NODE_52677_length_296_cov_5.991903_g50018_i0 PRJNA641707 52677 296 5.991903 17.73603288 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 113 1.24e-20   NTclustered gi|22417090|gb|AF509333.1| 32597 g50018 i0 89.13 9.86486486486486 92 9 31 1 62 152 6979 7070 Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 2920 113 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
21559923 21559923 PRJNA641707_P_NODE_52697_length_296_cov_5.408907_g50038_i0 PRJNA641707 52697 296 5.408907 16.01036472 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 78.7 4.53e-10   NTclustered gi|22417090|gb|AF509333.1| 32597 g50038 i0 90 0.608108108108108 60 6 20 0 7 66 6329 6388 Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 180 78.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni

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