RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB8827 · 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
32923283 32923283 PRJEB8827h_S_NODE_2569_length_220_cov_5.037838_g2550_i0 PRJEB8827 2569 220 5.037838 11.0832436 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 2.26e-7   NR KAF8822859.1 476202 g2550 i0 69.7 6.31363636363636 33 10 45 0 216 118 121 153 KAF8822859.1 ribosomal protein RPS18 [Cardiosporidium cionae] diamond 1389 55.8 0.99462365591397806 Eukaryota Sar   Apicomplexa Aconoidasida Nephromycida   Cardiosporidium Cardiosporidium cionae
32965590 32965590 PRJEB8827f_S_NODE_1194_length_345_cov_3.687097_g1174_i0 PRJEB8827 1194 345 3.687097 12.72048465 Plasmodium coatneyi 208452 SAR_Eukaryotes SAR_Eukaryotes 80.9 1.8e-16   NR XP_019915441.1 208452 g1174 i0 66.7 1.91304347826087 54 18 47 0 23 184 110 163 XP_019915441.1 60S ribosomal protein L12 [Plasmodium coatneyi] diamond 660 80.9 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium coatneyi
32991866 32991866 PRJEB8827h_S_NODE_10939_length_190_cov_4.638710_g10920_i0 PRJEB8827 10939 190 4.63871 8.813549 Eucoccidiorida 75739 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.45e-13   NR XP_013229778.1 5802 g10920 i0 64.9 2.68421052631579 57 20 90 0 2 172 43 99 XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella] diamond 510 69.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella
33111080 33111080 PRJEB8827g_S_NODE_1566_length_249_cov_3.355140_g1545_i0 PRJEB8827 1566 249 3.35514 8.3542986 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.1 3.24e-6   NR XP_013233142.1 5802 g1545 i0 74.1 3.68674698795181 27 7 32.5 0 29 109 147 173 XP_013233142.1 ribosomal protein L11, putative [Eimeria tenella] diamond 918 53.1 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);;