RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA168635", tax_clade = "Sar" 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

  • PRJNA168635 · 2 ✖

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
6742314 6742314 PRJNA168635_P_NODE_33406_length_158_cov_2.587156_g32990_i0 PRJNA168635 33406 158 2.587156 4.08770648 Tuberlatum coatsi 2497440 SAR_Eukaryotes SAR_Eukaryotes 143 7.53e-30   NTclustered gi|1538047935|gb|MK309360.1| 2497440 g32990 i0 83.648 67.6645569620253 159 19 99 5 1 157 1092 939 Tuberlatum coatsi strain TUcoa_LOHABE01 large subunit ribosomal RNA gene, partial sequence blastn 10691 143 1 Eukaryota Sar   Perkinsozoa     Parviluciferaceae Tuberlatum Tuberlatum coatsi
13118044 13118044 PRJNA168635_P_NODE_10591_length_253_cov_6.901961_g10176_i0 PRJNA168635 10591 253 6.901961 17.46196133 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 132 2.87e-26   NTclustered gi|37675413|gb|AY305326.1| 330153 g10176 i0 85.156 1.51778656126482 128 19 51 0 126 253 7480 7607 Perkinsus andrewsi 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 384 132 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki

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