contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2413537 | 2413537 | PRJNA577580_P_NODE_6582_length_351_cov_1.258993_g6504_i0 | PRJNA577580 | 6582 | 351 | 1.258993 | 4.41906543 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.17e-50 | NTclustered | gi|2785772740|ref|XM_067210427.1| | 117008 | g6504 | i0 | 83.19 | 5.9031339031339 | 232 | 37 | 66 | 2 | 102 | 332 | 262 | 492 | Cryptosporidium andersoni 40s ribosomal protein S2 (cand_001790), partial mRNA | blastn | 2072 | 211 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 3114909 | 3114909 | PRJNA577580_P_NODE_13403_length_254_cov_1.127072_g13325_i0 | PRJNA577580 | 13403 | 254 | 1.127072 | 2.86276288 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1620175782|ref|XM_028683395.1| | 880535 | g13325 | i0 | 100 | 0.220472440944882 | 28 | 0 | 11 | 0 | 227 | 254 | 1486 | 1459 | Plasmodium sp. gorilla clade G2 DEAD/DEAH box ATP-dependent RNA helicase, putative (PADL01_1242000), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 8217233 | 8217233 | PRJNA577580_P_NODE_4547_length_420_cov_2.492795_g4469_i0 | PRJNA577580 | 4547 | 420 | 2.492795 | 10.469739 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.09e-27 | NTclustered | gi|1472918886|ref|XR_003297360.1| | 88456 | g4469 | i0 | 81.143 | 9.67619047619048 | 175 | 29 | 41 | 4 | 97 | 270 | 759 | 930 | PREDICTED: Cyclospora cayetanensis large subunit ribosomal RNA (LOC113146729), rRNA | blastn | 4064 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 12617175 | 12617175 | PRJNA577580_P_NODE_7290_length_333_cov_1.930769_g7212_i0 | PRJNA577580 | 7290 | 333 | 1.930769 | 6.42946077 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 2.39e-13 | NTclustered | gi|400365274|gb|JQ684659.1| | 5833 | g7212 | i0 | 88.158 | 19.0570570570571 | 76 | 7 | 23 | 2 | 1 | 75 | 1568 | 1642 | Plasmodium falciparum isolate LF3 28S ribosomal RNA gene, partial sequence | blastn | 6346 | 89.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 15866681 | 15866681 | PRJNA577580_P_NODE_15833_length_244_cov_0.912281_g15755_i0 | PRJNA577580 | 15833 | 244 | 0.912281 | 2.22596564 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.27e-71 | NTclustered | gi|1620150562|ref|XM_028678648.1| | 85471 | g15755 | i0 | 87.398 | 88.3524590163934 | 246 | 27 | 100 | 4 | 1 | 244 | 353 | 596 | Plasmodium relictum polyubiquitin, putative (PRELSG_1312500), partial mRNA | blastn | 21558 | 279 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 15866712 | 15866712 | PRJNA577580_P_NODE_3953_length_453_cov_3.507895_g3875_i0 | PRJNA577580 | 3953 | 453 | 3.507895 | 15.89076435 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 5.6e-11 | NTclustered | gi|1931714359|ref|XR_552297.2| | 54757 | g3875 | i0 | 84.524 | 7.89845474613687 | 84 | 11 | 18 | 2 | 111 | 193 | 4020 | 4102 | Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA | blastn | 3578 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 24790159 | 24790159 | PRJNA577580_P_NODE_1520_length_737_cov_6.534639_g1446_i0 | PRJNA577580 | 1520 | 737 | 6.534639 | 48.16028943 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.021 | NTclustered | gi|1620181669|ref|XM_028684540.1| | 880535 | g1446 | i0 | 100 | 0.039348710990502 | 29 | 0 | 4 | 0 | 27 | 55 | 891 | 863 | Plasmodium sp. gorilla clade G2 lipase, putative (PADL01_1426900), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 |
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);;