RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA1174207" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA1174207 · 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
13793964 13793964 PRJNA1174207_P_NODE_31291_length_259_cov_1.655914_g30762_i0 PRJNA1174207 31291 259 1.655914 4.28881726 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 143 1.36e-29   NTclustered gi|22417090|gb|AF509333.1| 32597 g30762 i0 91.346 44.5482625482625 104 9 40 0 3 106 6628 6525 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 11538 143 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31145919 31145919 PRJNA1174207_P_NODE_37335_length_246_cov_0.890173_g36806_i0 PRJNA1174207 37335 246 0.890173 2.18982558 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 100 2.48e-22   NR XP_002771800.1 423536 g36806 i0 64.6 4.75609756097561 79 28 96.3 0 245 9 263 341 XP_002771800.1 elongation factor 2, putative [Perkinsus marinus ATCC 50983] diamond 1170 100 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus

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