contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4271071 | 4271071 | PRJNA473201_P_NODE_56504_length_275_cov_2.757426_g55762_i0 | PRJNA473201 | 56504 | 275 | 2.757426 | 7.5829215 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|916498813|ref|XM_013494772.1| | 44415 | g55762 | i0 | 100 | 0.105454545454545 | 29 | 0 | 11 | 0 | 96 | 124 | 2511 | 2483 | Eimeria mitis elongation factor Tu GTP-binding domain-containing protein, putative (EMH_0090800), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 6198558 | 6198558 | PRJNA473201_P_NODE_87505_length_220_cov_23.795918_g86763_i0 | PRJNA473201 | 87505 | 220 | 23.795918 | 52.3510196 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 6.91e-12 | NTclustered | gi|573016600|gb|KF018657.1| | 36330 | g86763 | i0 | 77.778 | 20.9636363636364 | 135 | 30 | 61 | 0 | 3 | 137 | 1116 | 982 | Plasmodium ovale isolate ZBP-HN clone RH4 18S ribosomal RNA gene, complete sequence | blastn | 4612 | 84.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 7472991 | 7472991 | PRJNA473201_P_NODE_54446_length_281_cov_1.110577_g53704_i0 | PRJNA473201 | 54446 | 281 | 1.110577 | 3.12072137 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|915122992|ref|XM_013477306.1| | 5804 | g53704 | i0 | 100 | 0.199288256227758 | 28 | 0 | 10 | 0 | 94 | 121 | 1481 | 1454 | Eimeria maxima ribosomal RNA methyltransferase, putative partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 8097420 | 8097420 | PRJNA473201_P_NODE_67347_length_250_cov_1.790960_g66605_i0 | PRJNA473201 | 67347 | 250 | 1.79096 | 4.4774 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.07e-67 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g66605 | i0 | 86.345 | 2.616 | 249 | 30 | 99 | 4 | 1 | 247 | 157195 | 156949 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 654 | 268 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8747954 | 8747954 | PRJNA473201_P_NODE_49327_length_293_cov_10.518182_g48585_i0 | PRJNA473201 | 49327 | 293 | 10.518182 | 30.81827326 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|1620127633|ref|XM_028673323.1| | 5849 | g48585 | i0 | 100 | 0.286689419795222 | 28 | 0 | 10 | 0 | 112 | 139 | 10629 | 10602 | Plasmodium gallinaceum hypothetical protein (PGAL8A_00456300), partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 9371821 | 9371821 | PRJNA473201_P_NODE_53768_length_282_cov_26.224880_g53026_i0 | PRJNA473201 | 53768 | 282 | 26.22488 | 73.9541616 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|1084895398|ref|XM_018787168.1| | 647221 | g53026 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 195 | 222 | 253 | 226 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 9372035 | 9372035 | PRJNA473201_P_NODE_64388_length_254_cov_31.635359_g63646_i0 | PRJNA473201 | 64388 | 254 | 31.635359 | 80.35381186 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 1.37e-9 | NTclustered | gi|1084825779|ref|XM_018785154.1| | 647221 | g63646 | i0 | 82.796 | 3.73228346456693 | 93 | 8 | 35 | 6 | 16 | 103 | 2044 | 1955 | Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA | blastn | 948 | 76.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 10647682 | 10647682 | PRJNA473201_P_NODE_41229_length_312_cov_9.246862_g40487_i0 | PRJNA473201 | 41229 | 312 | 9.246862 | 28.85020944 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|1084825779|ref|XM_018785154.1| | 647221 | g40487 | i0 | 100 | 0.272435897435897 | 29 | 0 | 9 | 0 | 1 | 29 | 2034 | 2006 | Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 14472892 | 14472892 | PRJNA473201_P_NODE_65532_length_251_cov_29.280899_g64790_i0 | PRJNA473201 | 65532 | 251 | 29.280899 | 73.49505649 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1084825779|ref|XM_018785154.1| | 647221 | g64790 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 1 | 29 | 2032 | 2004 | Plasmodium gaboni putative sentrin-specific protease 2 partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 18295682 | 18295682 | PRJNA473201_P_NODE_55775_length_277_cov_2.480392_g55033_i0 | PRJNA473201 | 55775 | 277 | 2.480392 | 6.87068584 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2787699113|ref|XM_067345761.1| | 1280935 | g55033 | i0 | 100 | 0.306859205776173 | 29 | 0 | 10 | 0 | 101 | 129 | 514 | 486 | Cryptosporidium sp. chipmunk genotype I uncharacterized protein (ELE39_002657), partial mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I |
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);;