RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA857143" and tax_phylum = "Fornicata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fornicata · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA857143 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
17422088 17422088 PRJNA857143_S_NODE_27374_length_479_cov_4.977833_g26282_i0 PRJNA857143 27374 479 4.977833 23.84382007 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 194 1.91e-60   NR KAG9393705.1 201153 g26282 i0 74 19.4029227557411 123 32 77 0 479 111 45 167 KAG9393705.1 Cyclophilin-type peptidyl-prolyl cis-trans isomerase [Carpediemonas membranifera] diamond 9294 195 0.994871794871795 Eukaryota Metamonada   Fornicata       Carpediemonas Carpediemonas membranifera
27600544 27600544 PRJNA857143_S_NODE_86764_length_329_cov_2.636719_g85671_i0 PRJNA857143 86764 329 2.636719 8.67480551 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.4 4.05e-5   NR TNJ28645.1 5742 g85671 i0 35.3 2.22492401215805 68 41 59.3 1 327 133 195 262 TNJ28645.1 VSP protein [Giardia muris] diamond 732 52.8 0.992424242424242 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia muris
29107818 29107818 PRJNA857143_S_NODE_82948_length_334_cov_4.478927_g81855_i0 PRJNA857143 82948 334 4.478927 14.95961618 Giardia intestinalis 5741 Fornicata other_Eukaryota 50.1 2.59e-4   NR ESU42095.1 5741 g81855 i0 33.3 0.70059880239521 78 50 70.1 1 8 241 176 251 ESU42095.1 Variant-specific surface protein [Giardia intestinalis] diamond 234 50.1 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
29139595 29139595 PRJNA857143_S_NODE_73069_length_349_cov_3.956522_g71976_i0 PRJNA857143 73069 349 3.956522 13.80826178 Giardia lamblia P15 658858 Fornicata other_Eukaryota 50.8 1.81e-4   NR EFO64296.1 658858 g71976 i0 46.3 0.816618911174785 41 22 35.2 0 1 123 336 376 EFO64296.1 VSP [Giardia lamblia P15] diamond 285 50.8 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
29147851 29147851 PRJNA857143_S_NODE_158449_length_260_cov_1.668449_g157356_i0 PRJNA857143 158449 260 1.668449 4.3379674 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.9 5.47e-6   NR KAG9392317.1 201153 g157356 i0 42.4 5.51538461538462 66 37 76.2 1 39 236 438 502 KAG9392317.1 Helicase conserved C-terminal domain [Carpediemonas membranifera] diamond 1434 54.3 0.992633517495396 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);;