contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10148610 | 10148610 | PRJNA800090_P_NODE_122708_length_288_cov_1.333333_g120523_i0 | PRJNA800090 | 122708 | 288 | 1.333333 | 3.83999904 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 2.39e-33 | NR | ETW57274.1 | 57270 | g120523 | i0 | 66 | 11.9166666666667 | 94 | 30 | 95.8 | 1 | 1 | 276 | 155 | 248 | ETW57274.1 hypothetical protein PFUGPA_00763 [Plasmodium falciparum Palo Alto/Uganda] | diamond | 3432 | 127 | 0.992125984251969 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 22474611 | 22474611 | PRJNA800090_P_NODE_152238_length_254_cov_1.459459_g150053_i0 | PRJNA800090 | 152238 | 254 | 1.459459 | 3.70702586 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 7.32e-33 | NR | XP_029219060.1 | 94643 | g150053 | i0 | 81.1 | 11.244094488189 | 74 | 14 | 87.4 | 0 | 31 | 252 | 8 | 81 | XP_029219060.1 ribosomal protein RPL3 [Besnoitia besnoiti] | diamond | 2856 | 127 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 23749373 | 23749373 | PRJNA800090_P_NODE_116759_length_297_cov_1.171053_g114574_i0 | PRJNA800090 | 116759 | 297 | 1.171053 | 3.47802741 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 6.859999999999999e-48 | NR | XP_011128572.1 | 110365 | g114574 | i0 | 78.6 | 30.6363636363636 | 98 | 21 | 99 | 0 | 3 | 296 | 38 | 135 | XP_011128572.1 putative serine/threonine-protein kinase/mitogen-activated protein kinase [Gregarina niphandrodes] | diamond | 9099 | 168 | 0.994047619047619 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 28199828 | 28199828 | PRJNA800090_P_NODE_151166_length_255_cov_1.456989_g148981_i0 | PRJNA800090 | 151166 | 255 | 1.456989 | 3.71532195 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 2.01e-20 | NR | XP_028861612.1 | 5858 | g148981 | i0 | 54.9 | 6.74117647058824 | 82 | 37 | 96.5 | 0 | 250 | 5 | 1 | 82 | XP_028861612.1 AP-4 complex subunit mu, putative [Plasmodium malariae] | diamond | 1719 | 94.7 | 0.996832101372756 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 29052668 | 29052668 | PRJNA800090_P_NODE_42628_length_561_cov_2.534553_g40461_i0 | PRJNA800090 | 42628 | 561 | 2.534553 | 14.21884233 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 4.42e-72 | NR | XP_013233901.1 | 5802 | g40461 | i0 | 65.9 | 7.5668449197861 | 179 | 60 | 95.7 | 1 | 538 | 2 | 1 | 178 | XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella] | diamond | 4245 | 228 | 0.991228070175439 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29210572 | 29210572 | PRJNA800090_P_NODE_169069_length_238_cov_2.159763_g166884_i0 | PRJNA800090 | 169069 | 238 | 2.159763 | 5.14023594 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 3.66e-10 | NR | XP_009690801.1 | 869250 | g166884 | i0 | 44.9 | 1.85294117647059 | 78 | 40 | 98.3 | 2 | 236 | 3 | 23 | 97 | XP_009690801.1 60S ribosomal protein L18 [Theileria orientalis strain Shintoku] | diamond | 441 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30031506 | 30031506 | PRJNA800090_P_NODE_98531_length_329_cov_1.123077_g96346_i0 | PRJNA800090 | 98531 | 329 | 1.123077 | 3.69492333 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.7899999999999995e-31 | NR | KAF8820025.1 | 476202 | g96346 | i0 | 56.1 | 3.87537993920973 | 107 | 43 | 96.7 | 3 | 325 | 8 | 197 | 300 | KAF8820025.1 putative glyoxalase I [Cardiosporidium cionae] | diamond | 1275 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 31318001 | 31318001 | PRJNA800090_P_NODE_174095_length_235_cov_0.879518_g171910_i0 | PRJNA800090 | 174095 | 235 | 0.879518 | 2.0668673 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 1.18e-14 | NR | XP_012769770.1 | 5866 | g171910 | i0 | 52.9 | 0.868085106382979 | 68 | 32 | 86.8 | 0 | 5 | 208 | 6 | 73 | XP_012769770.1 hypothetical protein, conserved [Babesia bigemina] | diamond | 204 | 76.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 32898067 | 32898067 | PRJNA800090_P_NODE_104980_length_316_cov_2.554656_g102795_i0 | PRJNA800090 | 104980 | 316 | 2.554656 | 8.07271296 | Plasmodium chabaudi chabaudi | 31271 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.66e-24 | NR | SCM25146.1 | 31271 | g102795 | i0 | 53.4 | 0.977848101265823 | 103 | 45 | 94.9 | 2 | 302 | 3 | 1 | 103 | SCM25146.1 Ribosomal Proteins L2, RNA binding domain/Ribosomal Proteins L2, C-terminal domain containing protein, putative [Plasmodium chabaudi chabaudi] | diamond | 309 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi |
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);;