RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA846486", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA846486 · 4 ✖

analysis 1

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
4661679 4661679 PRJNA846486_P_NODE_39724_length_216_cov_1.239521_g39628_i0 PRJNA846486 39724 216 1.239521 2.67736536 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 108 9.73e-29   NR KAF4712660.1 32597 g39628 i0 66.7 5.95833333333333 72 24 100 0 1 216 10 81 KAF4712660.1 iso-1-cytochrome c [Perkinsus olseni] diamond 1287 108 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28539328 28539328 PRJNA846486_P_NODE_62347_length_182_cov_1.563910_g62251_i0 PRJNA846486 62347 182 1.56391 2.8463162 Perkinsus sp. BL_2 28001 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00324   NR TEB19254.1 2494336 g62251 i0 41.8 0.906593406593407 55 29 90.7 1 173 9 180 231 TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] diamond 165 44.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus sp. BL_2016
28547735 28547735 PRJNA846486_P_NODE_54907_length_191_cov_1.464789_g54811_i0 PRJNA846486 54907 191 1.464789 2.79774699 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.93e-8   NR KAF4758630.1 32597 g54811 i0 58.1 4.69633507853403 62 16 88 2 1 168 479 536 KAF4758630.1 heat shock protein 90, partial [Perkinsus olseni] diamond 897 59.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28634057 28634057 PRJNA846486_P_NODE_21467_length_277_cov_3.285088_g21371_i0 PRJNA846486 21467 277 3.285088 9.09969376 Perkinsus sp. BL_2 28001 SAR_Eukaryotes SAR_Eukaryotes 68.2 2.97e-11   NR TEB19254.1 2494336 g21371 i0 42.3 0.844765342960289 78 40 83.4 2 1 231 190 263 TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] diamond 234 68.2 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus sp. BL_2016

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