contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA733995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 716667 | 716667 | PRJNA733995_P_NODE_7161_length_321_cov_1.302419_g7114_i0 | PRJNA733995 | 7161 | 321 | 1.302419 | 4.18076499 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.47e-4 | NTclustered | gi|921132567|ref|XM_013585365.1| | 51315 | g7114 | i0 | 94.595 | 0.115264797507788 | 37 | 2 | 12 | 0 | 172 | 208 | 1740 | 1704 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 1992616 | 1992616 | PRJNA733995_P_NODE_10982_length_262_cov_1.222222_g10935_i0 | PRJNA733995 | 10982 | 262 | 1.222222 | 3.20222164 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916498389|ref|XM_013494560.1| | 44415 | g10935 | i0 | 100 | 2.5381679389313 | 30 | 0 | 11 | 0 | 100 | 129 | 434 | 405 | Eimeria mitis uncharacterized protein (EMH_0031730), partial mRNA | blastn | 665 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 3267925 | 3267925 | PRJNA733995_P_NODE_11683_length_253_cov_2.133333_g11636_i0 | PRJNA733995 | 11683 | 253 | 2.133333 | 5.39733249 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|916504802|ref|XM_013497584.1| | 44415 | g11636 | i0 | 100 | 0.114624505928854 | 29 | 0 | 11 | 0 | 156 | 184 | 5073 | 5045 | Eimeria mitis uncharacterized protein (EMH_0058510), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 4545076 | 4545076 | PRJNA733995_P_NODE_12184_length_250_cov_0.870056_g12137_i0 | PRJNA733995 | 12184 | 250 | 0.870056 | 2.17514 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.35e-4 | NTclustered | gi|915007454|ref|XM_013394870.1| | 5801 | g12137 | i0 | 92.683 | 12.376 | 41 | 3 | 16 | 0 | 5 | 45 | 4152 | 4112 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 3094 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 7574649 | 7574649 | PRJNA733995_P_NODE_10846_length_264_cov_0.989529_g10799_i0 | PRJNA733995 | 10846 | 264 | 0.989529 | 2.61235656 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|914999418|ref|XM_013392433.1| | 5801 | g10799 | i0 | 96.875 | 0.666666666666667 | 32 | 0 | 12 | 1 | 97 | 127 | 545 | 514 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 176 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 11400448 | 11400448 | PRJNA733995_P_NODE_11449_length_256_cov_2.524590_g11402_i0 | PRJNA733995 | 11449 | 256 | 2.52459 | 6.4629504 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.39e-4 | NTclustered | gi|915006239|ref|XM_013394533.1| | 5801 | g11402 | i0 | 94.737 | 1.0234375 | 38 | 2 | 15 | 0 | 212 | 249 | 894 | 931 | Eimeria acervulina hypothetical protein partial mRNA | blastn | 262 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 14745613 | 14745613 | PRJNA733995_P_NODE_8452_length_296_cov_1.008969_g8405_i0 | PRJNA733995 | 8452 | 296 | 1.008969 | 2.98654824 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915013415|ref|XM_013396534.1| | 5801 | g8405 | i0 | 100 | 0.195945945945946 | 30 | 0 | 10 | 0 | 257 | 286 | 581 | 610 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 16019125 | 16019125 | PRJNA733995_P_NODE_11393_length_257_cov_1.673913_g11346_i0 | PRJNA733995 | 11393 | 257 | 1.673913 | 4.30195641 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.4e-4 | NTclustered | gi|914995830|ref|XM_013391301.1| | 5801 | g11346 | i0 | 93.023 | 0.167315175097276 | 43 | 0 | 16 | 2 | 12 | 53 | 4079 | 4039 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 43 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 16019173 | 16019173 | PRJNA733995_P_NODE_5213_length_377_cov_2.299342_g5166_i0 | PRJNA733995 | 5213 | 377 | 2.299342 | 8.66851934 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.036 | NTclustered | gi|1472921118|ref|XM_026336081.1| | 88456 | g5166 | i0 | 100 | 0.0742705570291777 | 28 | 0 | 7 | 0 | 178 | 205 | 293 | 266 | PREDICTED: Cyclospora cayetanensis uncharacterized LOC34622411 (LOC34622411), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 16499742 | 16499742 | PRJNA733995_P_NODE_13133_length_245_cov_0.895349_g13086_i0 | PRJNA733995 | 13133 | 245 | 0.895349 | 2.19360505 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|916416941|ref|XM_013374248.1| | 5802 | g13086 | i0 | 96.875 | 0.261224489795918 | 32 | 1 | 13 | 0 | 6 | 37 | 173 | 142 | Eimeria tenella uncharacterized protein (ETH_00029030), partial mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 22394150 | 22394150 | PRJNA733995_P_NODE_12698_length_247_cov_0.885057_g12651_i0 | PRJNA733995 | 12698 | 247 | 0.885057 | 2.18609079 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.33e-4 | NTclustered | gi|914997390|ref|XM_013391782.1| | 5801 | g12651 | i0 | 100 | 0.251012145748988 | 32 | 0 | 13 | 0 | 115 | 146 | 3325 | 3294 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 62 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 22394212 | 22394212 | PRJNA733995_P_NODE_9238_length_284_cov_1.094787_g9191_i0 | PRJNA733995 | 9238 | 284 | 1.094787 | 3.10919508 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|914998669|ref|XM_013392182.1| | 5801 | g9191 | i0 | 96.97 | 0.116197183098592 | 33 | 0 | 11 | 1 | 188 | 219 | 56 | 24 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 22874204 | 22874204 | PRJNA733995_P_NODE_13818_length_241_cov_0.916667_g13771_i0 | PRJNA733995 | 13818 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|916425577|ref|XM_013378566.1| | 5802 | g13771 | i0 | 100 | 0.697095435684647 | 28 | 0 | 12 | 0 | 210 | 237 | 43 | 70 | Eimeria tenella leucine zipper-like transcriptional regulator, putative (ETH_00008770), partial mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella |
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);;