RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA917598 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
29203810 29203810 PRJNA917598_P_NODE_64669_length_282_cov_1.712919_g63725_i0 PRJNA917598 64669 282 1.712919 4.83043158 Cryptosporidium sp. chipmunk genotype I 1280935 SAR_Eukaryotes SAR_Eukaryotes 52 3.23e-5   NR XP_067200937.1 1280935 g63725 i0 31.8 5.72340425531915 85 54 86.2 2 277 35 154 238 XP_067200937.1 Ser Thr kinase [Cryptosporidium sp. chipmunk genotype I] diamond 1614 52 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium sp. chipmunk genotype I
29337248 29337248 PRJNA917598_P_NODE_57189_length_300_cov_1.339207_g56245_i0 PRJNA917598 57189 300 1.339207 4.017621 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.94e-7   NR XP_953348.1 5874 g56245 i0 40.7 2.34 81 42 81 3 19 261 9 83 XP_953348.1 60S ribosomal protein P1, putative [Theileria annulata] diamond 702 55.5 0.992792792792793 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria annulata
31256862 31256862 PRJNA917598_P_NODE_23055_length_483_cov_0.939024_g22113_i0 PRJNA917598 23055 483 0.939024 4.53548592 Cyclospora cayetanensis 88456 SAR_Eukaryotes SAR_Eukaryotes 197 7.21e-61   NR OEH76901.1 88456 g22113 i0 65.6 3.97515527950311 160 55 99.4 0 3 482 29 188 OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] diamond 1920 197 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis

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