RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA312899 · 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
26838908 26838908 PRJNA312899_P_NODE_81201_length_176_cov_2.409449_g80759_i0 PRJNA312899 81201 176 2.409449 4.24063024 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.26e-7   NR KAF8822859.1 476202 g80759 i0 69.7 10.4488636363636 33 10 56.3 0 9 107 121 153 KAF8822859.1 ribosomal protein RPS18 [Cardiosporidium cionae] diamond 1839 55.8 0.99462365591397806 Eukaryota Sar   Apicomplexa Aconoidasida Nephromycida   Cardiosporidium Cardiosporidium cionae
30042655 30042655 PRJNA312899_P_NODE_29771_length_338_cov_15.934256_g29329_i0 PRJNA312899 29771 338 15.934256 53.85778528 Eimeria tenella 5802 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.94e-5   NR XP_013234781.1 5802 g29329 i0 41.4 0.514792899408284 58 34 51.5 0 336 163 56 113 XP_013234781.1 uncharacterized protein ETH_00032675 [Eimeria tenella] diamond 174 50.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella

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