RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA596870" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA596870 · 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
28293223 28293223 PRJNA596870_P_NODE_37106_length_244_cov_0.900585_g36973_i0 PRJNA596870 37106 244 0.900585 2.1974274 Giardia 5740 Fornicata other_Eukaryota 49.7 1.35e-4   NR ESU44889.1 5741 g36973 i0 36.1 2.02868852459016 83 36 87.3 3 231 19 264 341 ESU44889.1 Variant-specific surface protein, partial [Giardia intestinalis] diamond 495 50.1 0.992015968063872 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
30490623 30490623 PRJNA596870_P_NODE_16513_length_324_cov_1.533865_g16380_i0 PRJNA596870 16513 324 1.533865 4.9697226 Giardia intestinalis 5741 Fornicata other_Eukaryota 53.9 1.13e-5   NR ESU38240.1 5741 g16380 i0 50.9 0.490740740740741 53 25 48.1 1 147 302 246 298 ESU38240.1 Variant-specific surface protein [Giardia intestinalis] diamond 159 53.9 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
31502126 31502126 PRJNA596870_P_NODE_31596_length_249_cov_0.875000_g31463_i0 PRJNA596870 31596 249 0.875 2.17875 Carpediemonas membranifera 201153 Fornicata other_Eukaryota 52.4 1.6e-5   NR KAG9394939.1 201153 g31463 i0 37.7 0.831325301204819 69 40 83.1 1 249 43 7 72 KAG9394939.1 Protein kinase domain [Carpediemonas membranifera] diamond 207 52.4 1 Eukaryota Metamonada   Fornicata       Carpediemonas Carpediemonas membranifera

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