RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA599026" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA599026 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1847349 1847349 PRJNA599026_S_NODE_3562_length_505_cov_3.467105_g3113_i0 PRJNA599026 3562 505 3.467105 17.50888025 Babesia ovata 189622 SAR_Eukaryotes SAR_Eukaryotes 69.4 4.9e-7   NTclustered gi|1624694579|ref|XM_029012161.1| 189622 g3113 i0 89.091 0.245544554455446 55 6 11 0 371 425 55 1 Babesia ovata DHHC zinc finger domain-containing protein (BOVATA_032440), partial mRNA blastn 124 69.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovata
4399096 4399096 PRJNA599026_S_NODE_18764_length_238_cov_3.238095_g18308_i0 PRJNA599026 18764 238 3.238095 7.7066661 Toxoplasma gondii 5811 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.53e-10   NTclustered gi|1085129780|ref|XM_002364337.2| 508771 g18308 i0 80.18 0.600840336134454 111 16 45 6 129 236 4931 4824 Toxoplasma gondii ME49 protein kinase G AGC kinase family member PKG (PKG), mRNA blastn 143 78.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Toxoplasma Toxoplasma gondii
5675290 5675290 PRJNA599026_S_NODE_24265_length_217_cov_1.214286_g23809_i0 PRJNA599026 24265 217 1.214286 2.63500062 Cystoisospora suis 483139 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.019   NTclustered gi|2795617106|ref|XM_068062583.1| 483139 g23809 i0 100 0.129032258064516 28 0 13 0 18 45 2342 2369 Cystoisospora suis uncharacterized protein (CSUI_002381), mRNA blastn 28 52.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Cystoisospora Cystoisospora suis
6950386 6950386 PRJNA599026_S_NODE_8606_length_330_cov_1.807829_g8150_i0 PRJNA599026 8606 330 1.807829 5.9658357 Plasmodium cynomolgi 5827 SAR_Eukaryotes SAR_Eukaryotes 95.3 5.09e-15   NTclustered gi|457874751|ref|XM_004224034.1| 1120755 g8150 i0 85.556 0.751515151515151 90 13 27 0 241 330 2031 1942 Plasmodium cynomolgi strain B histidine -- tRNA ligase (PCYB_127000) mRNA, partial cds blastn 248 95.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium cynomolgi
15874166 15874166 PRJNA599026_S_NODE_18673_length_239_cov_1.073684_g18217_i0 PRJNA599026 18673 239 1.073684 2.56610476 Plasmodium floridense 31275 SAR_Eukaryotes SAR_Eukaryotes 156 1.59e-33   NTclustered gi|1372150352|gb|MF508420.1| 31275 g18217 i0 78.838 34.0083682008368 241 43 99 5 3 239 241 5 Plasmodium floridense isolate DR233 cell division cycle protein 48-like protein gene, partial cds blastn 8128 156 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium floridense

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