RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14664 · 3 ✖

analysis 1

  • blastn · 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
2571040 2571040 PRJEB14664_P_NODE_14923_length_183_cov_2.432432_g14793_i0 PRJEB14664 14923 183 2.432432 4.45135056 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 121 4.2099999999999996e-23   NTclustered gi|2794945628|ref|XM_067860250.1| 5871 g14793 i0 80.12 5.77049180327869 166 29 90 4 20 183 339 176 Babesia caballi 40S ribosomal protein S11, putative (BcabD6B2_37170), partial mRNA blastn 1056 121 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
8948137 8948137 PRJEB14664_P_NODE_14408_length_188_cov_2.013072_g14278_i0 PRJEB14664 14408 188 2.013072 3.78457536 Besnoitia besnoiti 94643 SAR_Eukaryotes SAR_Eukaryotes 169 1.5299999999999998e-37   NTclustered gi|1673123994|ref|XM_029360740.1| 94643 g14278 i0 82.888 51.1542553191489 187 32 99 0 2 188 161 347 Besnoitia besnoiti ribosomal-ubiquitin protein RPL40 (BESB_020310), partial mRNA blastn 9617 169 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Besnoitia Besnoitia besnoiti
13739230 13739230 PRJEB14664_P_NODE_911_length_957_cov_3.386117_g839_i0 PRJEB14664 911 957 3.386117 32.40513969 Apicomplexa 5794 SAR_Eukaryotes SAR_Eukaryotes 165 1.19e-35   NTclustered gi|396582138|gb|JN696678.1| 5874 g839 i0 89.844 13.7648902821317 128 13 13 0 776 903 1262 1135 Theileria annulata 28S ribosomal RNA gene, partial sequence blastn 13173 165 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria annulata

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