contig_metadata
16 rows where bioproject = "PRJNA849172", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3385220 | 3385220 | PRJNA849172_P_NODE_115483_length_235_cov_19.376543_g115123_i0 | PRJNA849172 | 115483 | 235 | 19.376543 | 45.53487605 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1145256240|ref|XM_012905638.2| | 5854 | g115123 | i0 | 100 | 0.123404255319149 | 29 | 0 | 12 | 0 | 66 | 94 | 1430 | 1458 | Plasmodium reichenowi exported protein (hyp1) partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 3386388 | 3386388 | PRJNA849172_P_NODE_21043_length_450_cov_1.851459_g20684_i0 | PRJNA849172 | 21043 | 450 | 1.851459 | 8.3315655 | Gregarina sp. Phaedon/Daegwallyeong/2010 | 1049247 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 3.21e-38 | NTclustered | gi|339715944|gb|JF412715.1| | 1049247 | g20684 | i0 | 79.197 | 13.4266666666667 | 274 | 37 | 59 | 17 | 1 | 264 | 3078 | 3341 | Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence | blastn | 6042 | 172 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina sp. Phaedon/Daegwallyeong/2010 | ||
| 7611052 | 7611052 | PRJNA849172_P_NODE_8146_length_762_cov_35.352685_g7809_i0 | PRJNA849172 | 8146 | 762 | 35.352685 | 269.3874597 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 531 | 8.05e-146 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g7809 | i0 | 92.513 | 432.494750656168 | 374 | 22 | 49 | 4 | 2 | 374 | 396 | 28 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 329561 | 531 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 10160459 | 10160459 | PRJNA849172_P_NODE_117848_length_233_cov_18.368750_g117488_i0 | PRJNA849172 | 117848 | 233 | 18.36875 | 42.7991875 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.48e-61 | NTclustered | gi|1717244046|gb|MN252431.1| | 35084 | g117488 | i0 | 91.257 | 78.5793991416309 | 183 | 14 | 78 | 2 | 4 | 185 | 1135 | 954 | Babesia sp. isolate TC-B-90 small subunit ribosomal RNA gene, partial sequence | blastn | 18309 | 248 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. | ||
| 11037766 | 11037766 | PRJNA849172_P_NODE_10009_length_679_cov_27.196370_g9659_i0 | PRJNA849172 | 10009 | 679 | 27.19637 | 184.6633523 | Cystoisospora felis | 482539 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 2.32e-36 | NTclustered | gi|3323386|gb|U85705.1|IFU85705 | 482539 | g9659 | i0 | 92.982 | 16.7864506627393 | 114 | 8 | 17 | 0 | 181 | 294 | 2037 | 1924 | Isospora felis 28S large subunit ribosomal RNA gene, complete sequence | blastn | 11398 | 167 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 12315386 | 12315386 | PRJNA849172_P_NODE_39850_length_327_cov_4.452756_g39490_i0 | PRJNA849172 | 39850 | 327 | 4.452756 | 14.56051212 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915133579|ref|XM_013480517.1| | 5804 | g39490 | i0 | 100 | 0.55045871559633 | 30 | 0 | 9 | 0 | 235 | 264 | 214 | 243 | Eimeria maxima XPA-binding protein, putative partial mRNA | blastn | 180 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 12316242 | 12316242 | PRJNA849172_P_NODE_68530_length_271_cov_2.515152_g68170_i0 | PRJNA849172 | 68530 | 271 | 2.515152 | 6.81606192 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 4.4799999999999996e-129 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g68170 | i0 | 98.155 | 4.99261992619926 | 271 | 5 | 100 | 0 | 1 | 271 | 117208 | 117478 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1353 | 473 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 13589197 | 13589197 | PRJNA849172_P_NODE_15351_length_533_cov_14.060870_g14992_i0 | PRJNA849172 | 15351 | 533 | 14.06087 | 74.9444371 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 179 | 7.959999999999999e-54 | NR | XP_011129527.1 | 110365 | g14992 | i0 | 63.4 | 0.861163227016886 | 153 | 54 | 85 | 1 | 532 | 80 | 18 | 170 | XP_011129527.1 ribosomal protein L19 [Gregarina niphandrodes] | diamond | 459 | 179 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 14865023 | 14865023 | PRJNA849172_P_NODE_6752_length_844_cov_3.162127_g6436_i0 | PRJNA849172 | 6752 | 844 | 3.162127 | 26.68835188 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 519 | 2.75e-184 | NR | XP_011134762.1 | 110365 | g6436 | i0 | 88.3 | 0.998815165876777 | 281 | 33 | 99.9 | 0 | 1 | 843 | 30 | 310 | XP_011134762.1 pyruvate kinase [Gregarina niphandrodes] | diamond | 843 | 519 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 17414986 | 17414986 | PRJNA849172_P_NODE_56974_length_285_cov_1.683962_g56614_i0 | PRJNA849172 | 56974 | 285 | 1.683962 | 4.7992917 | Gregarina sp. Phaedon/Daegwallyeong/2010 | 1049247 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 5.46e-29 | NTclustered | gi|339715944|gb|JF412715.1| | 1049247 | g56614 | i0 | 88.235 | 43.3438596491228 | 119 | 12 | 62 | 2 | 54 | 171 | 3617 | 3734 | Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence | blastn | 12353 | 141 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina sp. Phaedon/Daegwallyeong/2010 | ||
| 20358892 | 20358892 | PRJNA849172_P_NODE_35236_length_346_cov_6.465201_g34877_i0 | PRJNA849172 | 35236 | 346 | 6.465201 | 22.36959546 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 4.21e-6 | NTclustered | gi|1425132576|gb|MH618774.1| | 27992 | g34877 | i0 | 100 | 10.014450867052 | 35 | 0 | 10 | 0 | 1 | 35 | 62 | 28 | Theileria sp. isolate P11 small subunit ribosomal RNA gene, partial sequence | blastn | 3465 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria sp. | ||
| 28286345 | 28286345 | PRJNA849172_P_NODE_3506_length_1188_cov_3.420628_g3279_i0 | PRJNA849172 | 3506 | 1188 | 3.420628 | 40.63706064 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.19e-12 | NR | XP_011128453.1 | 110365 | g3279 | i0 | 24.3 | 1.13383838383838 | 370 | 123 | 65.9 | 13 | 1181 | 399 | 10 | 331 | XP_011128453.1 hypothetical protein GNI_000970 [Gregarina niphandrodes] | diamond | 1347 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30054711 | 30054711 | PRJNA849172_P_NODE_9371_length_706_cov_4.252765_g9024_i0 | PRJNA849172 | 9371 | 706 | 4.252765 | 30.0245209 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 3.3799999999999997e-128 | NR | XP_011131176.1 | 110365 | g9024 | i0 | 78.1 | 0.990084985835694 | 233 | 51 | 99 | 0 | 1 | 699 | 25 | 257 | XP_011131176.1 putative 60S ribosomal protein L7 [Gregarina niphandrodes] | diamond | 699 | 372 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30402837 | 30402837 | PRJNA849172_P_NODE_16233_length_517_cov_3.004505_g15874_i0 | PRJNA849172 | 16233 | 517 | 3.004505 | 15.53329085 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 4.38e-59 | NR | XP_011130055.1 | 110365 | g15874 | i0 | 66.3 | 0.998065764023211 | 172 | 57 | 99.8 | 1 | 517 | 2 | 317 | 487 | XP_011130055.1 pyruvate kinase [Gregarina niphandrodes] | diamond | 516 | 202 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30686581 | 30686581 | PRJNA849172_P_NODE_132413_length_217_cov_8.250000_g132053_i0 | PRJNA849172 | 132413 | 217 | 8.25 | 17.9025 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00219 | NR | XP_012648586.1 | 1133968 | g132053 | i0 | 44.4 | 2.26728110599078 | 54 | 29 | 74.7 | 1 | 4 | 165 | 276 | 328 | XP_012648586.1 Kelch motif [Babesia microti strain RI] | diamond | 492 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 30695033 | 30695033 | PRJNA849172_P_NODE_29173_length_379_cov_10.986928_g28814_i0 | PRJNA849172 | 29173 | 379 | 10.986928 | 41.64045712 | root | 1 | Root_unresolved | Root_unresolved | 82 | 3.44e-17 | NR | XP_011130617.1 | 110365 | g28814 | i0 | 41.2 | 3.17414248021108 | 114 | 67 | 90.2 | 0 | 13 | 354 | 8 | 121 | XP_011130617.1 putative 60S ribosomal protein L26 [Gregarina niphandrodes] | diamond | 1203 | 82 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes |
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);;