RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA493244 · 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
27313856 27313856 PRJNA493244_P_NODE_446403_length_783_cov_53.458449_g427242_i0 PRJNA493244 446403 783 53.458449 418.57965567 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.8 2.41e-20   NR OLQ18173.1 237895 g427242 i0 44.2 4.95785440613027 120 60 43.3 1 750 412 1 120 OLQ18173.1 ribosomal protein S10 [Cryptosporidium hominis] diamond 3882 97.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium hominis
27992555 27992555 PRJNA493244_P_NODE_1345345_length_283_cov_5.009009_g1322221_i0 PRJNA493244 1345345 283 5.009009 14.17549547 Cryptosporidium bovis 310047 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0238   NR XP_067181760.1 310047 g1322221 i0 46.2 0.551236749116608 52 26 53 1 159 10 370 421 XP_067181760.1 interaptin [Cryptosporidium bovis] diamond 156 43.9 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium bovis
32115701 32115701 PRJNA493244_P_NODE_1325238_length_289_cov_2.570175_g1302114_i0 PRJNA493244 1325238 289 2.570175 7.42780575 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 61.2 4.28e-9   NR XP_067924299.1 483139 g1302114 i0 58.2 5.06574394463668 55 20 54 1 194 39 121 175 XP_067924299.1 ribosomal protein rpl23a [Cystoisospora suis] diamond 1464 61.2 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Cystoisospora Cystoisospora suis

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