RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA546018 · 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
1786777 1786777 PRJNA546018_S_NODE_55102_length_205_cov_2.840278_g54777_i0 PRJNA546018 55102 205 2.840278 5.8225699 Angulamoeba microcystivorans 1654978 Evosea other_Eukaryota 239 1.28e-58   NTclustered gi|961557578|gb|KP719182.2| 1654978 g54777 i0 90.27 15.6780487804878 185 15 89 3 1 183 1089 906 Angulamoeba microcystivorans strain A4WVB clone 2 small subunit ribosomal RNA gene, partial sequence blastn 3214 239 1 Eukaryota Amoebozoa   Evosea Variosea     Angulamoeba Angulamoeba microcystivorans
4338413 4338413 PRJNA546018_S_NODE_7604_length_643_cov_5.896907_g7301_i0 PRJNA546018 7604 643 5.896907 37.91711201 Squamamoeba japonica 1167875 Evosea other_Eukaryota 265 7.539999999999999e-66   NTclustered gi|381423467|gb|JN638032.1| 1167875 g7301 i0 83.746 36.4043545878694 283 42 44 4 140 419 1179 1460 Squamamoeba japonica strain CCAP 1593/1 clone 2224 18S ribosomal RNA gene, partial sequence blastn 23408 265 1 Eukaryota Amoebozoa   Evosea       Squamamoeba Squamamoeba japonica
23463409 23463409 PRJNA546018_S_NODE_44379_length_230_cov_1.153846_g44054_i0 PRJNA546018 44379 230 1.153846 2.6538458 Dictyostelium purpureum 5786 Evosea other_Eukaryota 211 3.2e-50   NTclustered gi|85062628|gb|DQ340386.1| 5786 g44054 i0 88.571 48.1608695652174 175 18 76 2 1 174 8297 8124 Dictyostelium purpureum 17S ribosomal RNA, 5.8S ribosomal RNA, 26S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence blastn 11077 211 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum

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