RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA964500" 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

  • PRJNA964500 · 3 ✖

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
19116845 19116845 PRJNA964500_S_NODE_11655_length_176_cov_3.040816_g11563_i0 PRJNA964500 11655 176 3.040816 5.35183616 Didymium 5792 Evosea other_Eukaryota 265 1.7499999999999998e-66   NTclustered gi|2687|emb|X60210.1| 5793 g11563 i0 94.706 8.22727272727273 170 9 97 0 1 170 2613 2444 D.iridis LSU rRNA gene blastn 1448 265 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Physariida Didymiaceae Didymium Didymium iridis
20391804 20391804 PRJNA964500_S_NODE_4776_length_252_cov_307.278027_g4684_i0 PRJNA964500 4776 252 307.278027 774.34062804 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 220 5.919999999999999e-53   NTclustered gi|300078500|gb|GU001162.1| 136499 g4684 i0 85.849 2288.54365079365 212 25 83 4 35 244 4282 4074 Phalansterium solitarium 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 576713 222 0.990990990990991 Eukaryota Amoebozoa   Evosea Variosea     Phalansterium Phalansterium solitarium
22618951 22618951 PRJNA964500_S_NODE_5918_length_231_cov_334.188119_g5826_i0 PRJNA964500 5918 231 334.188119 771.97455489 Phalansterium solitarium 136499 Evosea other_Eukaryota 265 2.44e-66   NTclustered gi|300078500|gb|GU001162.1| 136499 g5826 i0 90.955 85.3896103896104 199 14 85 3 35 231 4282 4086 Phalansterium solitarium 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19725 265 1 Eukaryota Amoebozoa   Evosea Variosea     Phalansterium Phalansterium solitarium

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