RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA685607" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA685607 · 4 ✖

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
10870418 10870418 PRJNA685607_P_NODE_73129_length_248_cov_1.320000_g72770_i0 PRJNA685607 73129 248 1.32 3.2736 Aduncisulcus paluster 2918883 Fornicata other_Eukaryota 89 4.81e-19   NR GKT34402.1 2918883 g72770 i0 61.7 1.97177419354839 81 21 98 3 5 247 66 136 GKT34402.1 60S ribosomal protein L5 [Aduncisulcus paluster] diamond 489 89 1 Eukaryota Metamonada   Fornicata       Aduncisulcus Aduncisulcus paluster
27587833 27587833 PRJNA685607_P_NODE_14424_length_424_cov_3.082621_g14066_i0 PRJNA685607 14424 424 3.082621 13.07031304 Aduncisulcus paluster 2918883 Fornicata other_Eukaryota 132 8.94e-33   NR GKT31530.1 2918883 g14066 i0 59.1 0.898584905660377 127 46 87 2 420 52 51 175 GKT31530.1 Diphthamide synthesis DPH1/DPH2 like protein [Aduncisulcus paluster] diamond 381 132 1 Eukaryota Metamonada   Fornicata       Aduncisulcus Aduncisulcus paluster
28882177 28882177 PRJNA685607_P_NODE_33788_length_318_cov_0.942857_g33429_i0 PRJNA685607 33788 318 0.942857 2.99828526 Spironucleus salmonicida 348837 Fornicata other_Eukaryota 105 1.1399999999999999e-23   NR XP_067763333.1 348837 g33429 i0 47.7 1.00943396226415 107 51 98.1 2 3 314 560 664 XP_067763333.1 Elongation factor 2 [Spironucleus salmonicida] diamond 321 105 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Spironucleus Spironucleus salmonicida
32642622 32642622 PRJNA685607_P_NODE_2640_length_973_cov_1.978889_g2380_i0 PRJNA685607 2640 973 1.978889 19.25458997 Giardia intestinalis 5741 Fornicata other_Eukaryota 51.2 0.00371   NR ESU43722.1 5741 g2380 i0 28.6 0.517985611510791 168 93 48.7 5 885 412 4 154 ESU43722.1 Variant-specific surface protein, partial [Giardia intestinalis] diamond 504 51.2 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis

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