contig_metadata
10 rows where bioproject = "PRJNA1249042", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9282698 | 9282698 | PRJNA1249042_S_NODE_37848_length_227_cov_2.875000_g37634_i0 | PRJNA1249042 | 37848 | 227 | 2.875 | 6.52625 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|457875988|ref|XM_004224447.1| | 1120755 | g37634 | i0 | 100 | 0.127753303964758 | 29 | 0 | 13 | 0 | 82 | 110 | 651 | 679 | Plasmodium cynomolgi strain B protein kinase (PCYB_134220) mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 13108732 | 13108732 | PRJNA1249042_S_NODE_87951_length_171_cov_1.468750_g87737_i0 | PRJNA1249042 | 87951 | 171 | 1.46875 | 2.5115625 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 1.1e-8 | NTclustered | gi|749157478|ref|XM_011132066.1| | 110365 | g87737 | i0 | 95.556 | 0.467836257309941 | 45 | 2 | 27 | 0 | 113 | 157 | 165 | 209 | Gregarina niphandrodes hypothetical protein partial mRNA | blastn | 80 | 73.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 15657307 | 15657307 | PRJNA1249042_S_NODE_28553_length_244_cov_2.572139_g28339_i0 | PRJNA1249042 | 28553 | 244 | 2.572139 | 6.27601916 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1620139505|ref|XM_028675465.1| | 85471 | g28339 | i0 | 100 | 0.118852459016393 | 29 | 0 | 12 | 0 | 200 | 228 | 1581 | 1609 | Plasmodium relictum conserved Plasmodium protein, unknown function (PRELSG_0601800), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 16931756 | 16931756 | PRJNA1249042_S_NODE_45514_length_216_cov_1.901734_g45300_i0 | PRJNA1249042 | 45514 | 216 | 1.901734 | 4.10774544 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|1931716671|ref|XM_037634662.1| | 54757 | g45300 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 55 | 82 | 8287 | 8260 | Plasmodium vinckei vinckei conserved Plasmodium protein, unknown function (PVVCY_1202710), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 18206063 | 18206063 | PRJNA1249042_S_NODE_24855_length_252_cov_2.339713_g24641_i0 | PRJNA1249042 | 24855 | 252 | 2.339713 | 5.89607676 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 2e-97 | NTclustered | gi|1624698160|ref|XM_029013948.1| | 189622 | g24641 | i0 | 93.227 | 684.694444444444 | 251 | 16 | 99 | 1 | 1 | 251 | 23 | 272 | Babesia ovata zinc finger protein 33B (BOVATA_050310), partial mRNA | blastn | 172543 | 368 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22031268 | 22031268 | PRJNA1249042_S_NODE_45538_length_216_cov_1.832370_g45324_i0 | PRJNA1249042 | 45538 | 216 | 1.83237 | 3.9579192 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|1620122695|ref|XM_028672102.1| | 5849 | g45324 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 118 | 145 | 771 | 798 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00309200), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 23306514 | 23306514 | PRJNA1249042_S_NODE_10279_length_306_cov_3.604563_g10065_i0 | PRJNA1249042 | 10279 | 306 | 3.604563 | 11.02996278 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 2.48e-102 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g10065 | i0 | 90.033 | 20.4967320261438 | 301 | 24 | 98 | 5 | 6 | 306 | 121 | 415 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6272 | 385 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 24581116 | 24581116 | PRJNA1249042_S_NODE_72420_length_185_cov_1.683099_g72206_i0 | PRJNA1249042 | 72420 | 185 | 1.683099 | 3.11373315 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.016 | NTclustered | gi|916500119|ref|XM_013495420.1| | 44415 | g72206 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 158 | 185 | 740 | 767 | Eimeria mitis uncharacterized protein (EMH_0039620), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 26743136 | 26743136 | PRJNA1249042_S_NODE_105361_length_157_cov_3.149123_g105147_i0 | PRJNA1249042 | 105361 | 157 | 3.149123 | 4.94412311 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.26e-18 | NR | XP_067803686.1 | 323732 | g105147 | i0 | 72.5 | 16.5668789808917 | 51 | 14 | 97.5 | 0 | 1 | 153 | 54 | 104 | XP_067803686.1 bifunctional Ribosomal protein L31e domain superfamily/Ribosomal protein L31e [Babesia duncani] | diamond | 2601 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 26947015 | 26947015 | PRJNA1249042_S_NODE_60982_length_197_cov_1.720779_g60768_i0 | PRJNA1249042 | 60982 | 197 | 1.720779 | 3.38993463 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00639 | NR | AIZ73304.1 | 5833 | g60768 | i0 | 50 | 1.21827411167513 | 40 | 20 | 60.9 | 0 | 122 | 3 | 82 | 121 | AIZ73304.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum] | diamond | 240 | 43.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum |
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);;