contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax_phylum = "Apicomplexa"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300357 | 1300357 | PRJEB2925_P_NODE_15782_length_251_cov_1.064815_g14504_i0 | PRJEB2925 | 15782 | 251 | 1.064815 | 2.67268565 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 1.21e-84 | NTclustered | gi|124507039|ref|XM_001352081.1| | 36329 | g14504 | i0 | 100 | 2.02390438247012 | 176 | 0 | 70 | 0 | 76 | 251 | 1137 | 962 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_0924600), partial mRNA | blastn | 508 | 326 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 5128448 | 5128448 | PRJEB2925_P_NODE_1365_length_1738_cov_6.762184_g1008_i0 | PRJEB2925 | 1365 | 1738 | 6.762184 | 117.52675792 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 3070 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g1008 | i0 | 98.561 | 1206.01898734177 | 1737 | 25 | 99 | 0 | 1 | 1737 | 1894 | 158 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 2096061 | 3070 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 11504230 | 11504230 | PRJEB2925_P_NODE_8010_length_440_cov_2.958025_g6790_i0 | PRJEB2925 | 8010 | 440 | 2.958025 | 13.01531 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 9.01e-14 | NTclustered | gi|1474771164|gb|MH107388.1| | 323732 | g6790 | i0 | 84.536 | 0.536363636363636 | 97 | 9 | 21 | 6 | 233 | 326 | 15781 | 15874 | Babesia duncani isolate WA-1 apicoplast, complete genome | blastn | 236 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 16602904 | 16602904 | PRJEB2925_P_NODE_16014_length_248_cov_1.079812_g14736_i0 | PRJEB2925 | 16014 | 248 | 1.079812 | 2.67793376 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 4.34e-79 | NTclustered | gi|124512965|ref|XM_001349803.1| | 36329 | g14736 | i0 | 98.837 | 2.41532258064516 | 172 | 2 | 69 | 0 | 1 | 172 | 815 | 644 | Plasmodium falciparum 3D7 meiosis-specific nuclear structural protein 1, putative (PF3D7_1311100), partial mRNA | blastn | 599 | 307 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 24251888 | 24251888 | PRJEB2925_P_NODE_15120_length_260_cov_1.022222_g13842_i0 | PRJEB2925 | 15120 | 260 | 1.022222 | 2.6577772 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.58e-108 | NTclustered | gi|124513881|ref|XM_001350261.1| | 36329 | g13842 | i0 | 100 | 1.68076923076923 | 219 | 0 | 84 | 0 | 42 | 260 | 1085 | 867 | Plasmodium falciparum 3D7 zinc finger protein, putative (PF3D7_1358600), partial mRNA | blastn | 437 | 405 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 25214151 | 25214151 | PRJEB2925_P_NODE_16020_length_248_cov_0.981221_g14742_i0 | PRJEB2925 | 16020 | 248 | 0.981221 | 2.43342808 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.76e-36 | NTclustered | gi|160646|gb|M14599.1|PFARGSS | 5821 | g14742 | i0 | 100 | 38.3145161290323 | 89 | 0 | 60 | 0 | 160 | 248 | 1730 | 1642 | P.berghei small subunit rRNA gene | blastn | 9502 | 165 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei |
Advanced export
JSON shape: default, array, newline-delimited
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);;