RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA562549" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 2 ✖

bioproject 1

  • PRJNA562549 · 2 ✖

analysis 1

  • diamond · 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
28247582 28247582 PRJNA562549_P_NODE_36446_length_202_cov_0.921986_g36213_i0 PRJNA562549 36446 202 0.921986 1.86241172 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 119 1.72e-30   NR KOO23867.1 1460289 g36213 i0 80.6 1.99009900990099 67 13 99.5 0 1 201 138 204 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 402 119 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29461095 29461095 PRJNA562549_P_NODE_32030_length_210_cov_0.872483_g31797_i0 PRJNA562549 32030 210 0.872483 1.8322143 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 117 4.38e-30   NR KAL1498655.1 97485 g31797 i0 77.9 9.87142857142857 68 15 97.1 0 204 1 100 167 KAL1498655.1 hypothetical protein AB1Y20_013968 [Prymnesium parvum] diamond 2073 118 0.991525423728814 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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