contig_metadata
8 rows where bioproject = "PRJNA674048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3194067 | 3194067 | PRJNA674048_P_NODE_34163_length_152_cov_2.019417_g33960_i0 | PRJNA674048 | 34163 | 152 | 2.019417 | 3.06951384 | Selenidium pyroidea | 2605653 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 3.43e-8 | NTclustered | gi|1730679298|gb|MN381957.1| | 2605653 | g33960 | i0 | 100 | 26.9210526315789 | 38 | 0 | 25 | 0 | 115 | 152 | 4669 | 4706 | Selenidium pyroidea isolate AK3 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4092 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Archigregarinorida | Selenidiidae | Selenidium | Selenidium pyroidea | ||
| 6269869 | 6269869 | PRJNA674048_P_NODE_20165_length_196_cov_2.122449_g19962_i0 | PRJNA674048 | 20165 | 196 | 2.122449 | 4.16000004 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|915016625|ref|XM_013397533.1| | 5801 | g19962 | i0 | 94.286 | 1.52551020408163 | 35 | 2 | 18 | 0 | 23 | 57 | 270 | 236 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 299 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 8296391 | 8296391 | PRJNA674048_P_NODE_22067_length_187_cov_2.166667_g21864_i0 | PRJNA674048 | 22067 | 187 | 2.166667 | 4.05166729 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 9.57e-5 | NTclustered | gi|1931714359|ref|XR_552297.2| | 54757 | g21864 | i0 | 86.792 | 6.24598930481283 | 53 | 7 | 28 | 0 | 99 | 151 | 4102 | 4050 | Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA | blastn | 1168 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 14672078 | 14672078 | PRJNA674048_P_NODE_15812_length_224_cov_2.537143_g15609_i0 | PRJNA674048 | 15812 | 224 | 2.537143 | 5.68320032 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 6.76e-42 | NTclustered | gi|1624737946|ref|XM_029018495.1| | 857276 | g15609 | i0 | 83.673 | 30.03125 | 196 | 30 | 87 | 2 | 26 | 220 | 1 | 195 | Cryptosporidium ubiquitum histone H3 (cubi_01483), partial mRNA | blastn | 6727 | 183 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 18495498 | 18495498 | PRJNA674048_P_NODE_28095_length_168_cov_0.873950_g27892_i0 | PRJNA674048 | 28095 | 168 | 0.87395 | 1.468236 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.37e-22 | NTclustered | gi|820688590|tpe|LN714475.1| | 572307 | g27892 | i0 | 89.583 | 18.3214285714286 | 96 | 6 | 56 | 3 | 3 | 96 | 42485 | 42578 | TPA_asm: Neospora caninum Liverpool, chromosome chrIb, complete genome | blastn | 3078 | 119 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24118047 | 24118047 | PRJNA674048_P_NODE_34139_length_152_cov_2.417476_g33936_i0 | PRJNA674048 | 34139 | 152 | 2.417476 | 3.67456352 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.67e-4 | NTclustered | gi|527046684|tpe|HG323586.1| | 5833 | g33936 | i0 | 100 | 2.74342105263158 | 31 | 0 | 20 | 0 | 100 | 130 | 159 | 189 | TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA | blastn | 417 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 27694213 | 27694213 | PRJNA674048_P_NODE_28744_length_167_cov_0.881356_g28541_i0 | PRJNA674048 | 28744 | 167 | 0.881356 | 1.47186452 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 6.65e-8 | NR | XP_018635896.1 | 508771 | g28541 | i0 | 49.2 | 6.21556886227545 | 59 | 25 | 98.8 | 2 | 167 | 3 | 1014 | 1071 | XP_018635896.1 sushi domain (scr repeat) domain-containing protein [Toxoplasma gondii ME49] | diamond | 1038 | 57.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29765716 | 29765716 | PRJNA674048_P_NODE_24111_length_179_cov_1.600000_g23908_i0 | PRJNA674048 | 24111 | 179 | 1.6 | 2.864 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.76e-20 | NR | XP_067069864.1 | 117008 | g23908 | i0 | 71.2 | 1.9608938547486 | 59 | 17 | 98.9 | 0 | 1 | 177 | 14 | 72 | XP_067069864.1 60s ribosomal protein L13A [Cryptosporidium andersoni] | diamond | 351 | 89.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni |
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);;