RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA874604" 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

  • PRJNA874604 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27907760 27907760 PRJNA874604_P_NODE_20625_length_398_cov_2.433846_g20273_i0 PRJNA874604 20625 398 2.433846 9.68670708 Kipferlia bialata 797122 Fornicata other_Eukaryota 44.7 0.0443   NR GIQ80334.1 797122 g20273 i0 41.8 0.595477386934673 79 40 56.5 4 153 377 2577 2653 GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] diamond 237 44.7 1 Eukaryota Metamonada   Fornicata       Kipferlia Kipferlia bialata
28105443 28105443 PRJNA874604_P_NODE_82985_length_246_cov_1.780347_g82633_i0 PRJNA874604 82985 246 1.780347 4.37965362 Giardia 5740 Fornicata other_Eukaryota 52 2.06e-5   NR ESU35890.1 5741 g82633 i0 44.6 1.58536585365854 65 36 79.3 0 2 196 54 118 ESU35890.1 Hypothetical protein DHA2_16973 [Giardia intestinalis] diamond 390 52.4 0.99236641221374 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
28855117 28855117 PRJNA874604_P_NODE_89108_length_244_cov_1.736842_g88756_i0 PRJNA874604 89108 244 1.736842 4.23789448 Giardia lamblia P15 658858 Fornicata other_Eukaryota 72.8 8.28e-13   NR EFO65702.1 658858 g88756 i0 43.4 1.02049180327869 83 42 95.9 2 234 1 121 203 EFO65702.1 Kinase, NEK [Giardia lamblia P15] diamond 249 72.8 1 Eukaryota Metamonada   Fornicata   Diplomonadida Hexamitidae Giardia Giardia duodenalis
31896510 31896510 PRJNA874604_P_NODE_69497_length_251_cov_0.865169_g69145_i0 PRJNA874604 69497 251 0.865169 2.17157419 Giardia 5740 Fornicata other_Eukaryota 45.8 0.00218   NR BAB58891.1 5741 g69145 i0 46.8 1.12350597609562 47 25 56.2 0 237 97 110 156 BAB58891.1 rab-like protein E, partial [Giardia intestinalis] diamond 282 45.8 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);;