contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28388453 | 28388453 | PRJNA669701_P_NODE_30466_length_425_cov_3.022727_g30071_i0 | PRJNA669701 | 30466 | 425 | 3.022727 | 12.84658975 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.0800000000000003e-22 | NR | POM82495.1 | 93969 | g30071 | i0 | 54.9 | 9.81882352941176 | 82 | 37 | 57.9 | 0 | 260 | 15 | 5989 | 6070 | POM82495.1 HECT-domain (ubiquitin-transferase) family protein [Cryptosporidium meleagridis] | diamond | 4173 | 103 | 0.990291262135922 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis | ||
| 28451805 | 28451805 | PRJNA669701_P_NODE_116686_length_248_cov_1.760000_g116291_i0 | PRJNA669701 | 116686 | 248 | 1.76 | 4.3648 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 6.24e-25 | NR | XP_067802537.1 | 323732 | g116291 | i0 | 61.7 | 3.82258064516129 | 81 | 31 | 98 | 0 | 2 | 244 | 10 | 90 | XP_067802537.1 Ribosomal protein S25 [Babesia duncani] | diamond | 948 | 99.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28451816 | 28451816 | PRJNA669701_P_NODE_90066_length_270_cov_1.345178_g89671_i0 | PRJNA669701 | 90066 | 270 | 1.345178 | 3.6319806 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 4.92e-4 | NR | KNC35130.1 | 580058 | g89671 | i0 | 92.3 | 0.577777777777778 | 26 | 2 | 28.9 | 0 | 187 | 264 | 523 | 548 | KNC35130.1 erythrocyte membrane protein 1 [Plasmodium falciparum RAJ116] | diamond | 156 | 48.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 29260388 | 29260388 | PRJNA669701_P_NODE_93989_length_265_cov_3.505208_g93594_i0 | PRJNA669701 | 93989 | 265 | 3.505208 | 9.2888012 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3.25e-25 | NR | OEH76901.1 | 88456 | g93594 | i0 | 64.4 | 5.89811320754717 | 87 | 31 | 98.5 | 0 | 265 | 5 | 107 | 193 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1563 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30334862 | 30334862 | PRJNA669701_P_NODE_84372_length_277_cov_1.122549_g83977_i0 | PRJNA669701 | 84372 | 277 | 1.122549 | 3.10946073 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 9.67e-4 | NR | XP_011131355.1 | 110365 | g83977 | i0 | 72.4 | 0.314079422382672 | 29 | 8 | 31.4 | 0 | 31 | 117 | 340 | 368 | XP_011131355.1 putative transmembrane protein [Gregarina niphandrodes] | diamond | 87 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30492418 | 30492418 | PRJNA669701_P_NODE_120073_length_247_cov_1.649425_g119678_i0 | PRJNA669701 | 120073 | 247 | 1.649425 | 4.07407975 | Plasmodium falciparum 7G8 | 57266 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 6.98e-4 | NR | EUR64179.1 | 57266 | g119678 | i0 | 92.9 | 0.340080971659919 | 28 | 2 | 34 | 0 | 225 | 142 | 239 | 266 | EUR64179.1 hypothetical protein PFBG_05179, partial [Plasmodium falciparum 7G8] | diamond | 84 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 31250656 | 31250656 | PRJNA669701_P_NODE_139815_length_241_cov_5.476190_g139420_i0 | PRJNA669701 | 139815 | 241 | 5.47619 | 13.1976179 | Plasmodium falciparum Santa Lucia | 478859 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 8.44e-4 | NR | EUT90749.1 | 478859 | g139420 | i0 | 87.8 | 0.510373443983402 | 41 | 5 | 51 | 0 | 125 | 3 | 148 | 188 | EUT90749.1 hypothetical protein PFAG_01106 [Plasmodium falciparum Santa Lucia] | diamond | 123 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 31313932 | 31313932 | PRJNA669701_P_NODE_137155_length_242_cov_1.408284_g136760_i0 | PRJNA669701 | 137155 | 242 | 1.408284 | 3.40804728 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 8.66e-4 | NR | XP_067200564.1 | 1280935 | g136760 | i0 | 79.2 | 0.892561983471074 | 24 | 5 | 29.8 | 0 | 85 | 156 | 691 | 714 | XP_067200564.1 membrane associated adenylyl cyclase with 6 transmembrane regions and an adenylyl cyclase domain [Cryptosporidium sp. chipmunk genotype I] | diamond | 216 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 31673797 | 31673797 | PRJNA669701_P_NODE_90757_length_269_cov_1.571429_g90362_i0 | PRJNA669701 | 90757 | 269 | 1.571429 | 4.22714401 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 2.44e-17 | NR | KAK1938396.1 | 32595 | g90362 | i0 | 44.9 | 5.95539033457249 | 89 | 49 | 99.3 | 0 | 2 | 268 | 37 | 125 | KAK1938396.1 putative mago nashi protein [Babesia divergens] | diamond | 1602 | 82.4 | 0.995145631067961 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia divergens | ||
| 31737015 | 31737015 | PRJNA669701_P_NODE_70637_length_294_cov_2.212670_g70242_i0 | PRJNA669701 | 70637 | 294 | 2.21267 | 6.5052498 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.01e-17 | NR | ETW63707.1 | 5835 | g70242 | i0 | 100 | 1.95918367346939 | 48 | 0 | 49 | 0 | 292 | 149 | 645 | 692 | ETW63707.1 hypothetical protein PFMC_00453 [Plasmodium falciparum CAMP/Malaysia] | diamond | 576 | 87.8 | 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);;