contig_metadata
16 rows where bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5318745 | 5318745 | PRJNA1111146_P_NODE_198645_length_206_cov_2.941176_g197507_i0 | PRJNA1111146 | 198645 | 206 | 2.941176 | 6.05882256 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 9.89e-65 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g197507 | i0 | 89.32 | 11.7572815533981 | 206 | 22 | 100 | 0 | 1 | 206 | 299706 | 299911 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2422 | 259 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6594277 | 6594277 | PRJNA1111146_P_NODE_262166_length_194_cov_1.219858_g261028_i0 | PRJNA1111146 | 262166 | 194 | 1.219858 | 2.36652452 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.420000000000001e-77 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g261028 | i0 | 95.699 | 5.88144329896907 | 186 | 8 | 96 | 0 | 1 | 186 | 157426 | 157611 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1141 | 300 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10419015 | 10419015 | PRJNA1111146_P_NODE_110909_length_238_cov_1.081081_g109771_i0 | PRJNA1111146 | 110909 | 238 | 1.081081 | 2.57297278 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.15e-90 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g109771 | i0 | 92.857 | 19.4705882352941 | 238 | 16 | 100 | 1 | 1 | 238 | 300628 | 300392 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 4634 | 344 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10420628 | 10420628 | PRJNA1111146_P_NODE_67269_length_268_cov_0.920930_g66131_i0 | PRJNA1111146 | 67269 | 268 | 0.92093 | 2.4680924 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.64e-94 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g66131 | i0 | 90.672 | 34.2126865671642 | 268 | 25 | 100 | 0 | 1 | 268 | 301650 | 301917 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 9169 | 357 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11695689 | 11695689 | PRJNA1111146_P_NODE_440710_length_176_cov_2.756098_g439572_i0 | PRJNA1111146 | 440710 | 176 | 2.756098 | 4.85073248 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1027959202|ref|XM_737592.2| | 31271 | g439572 | i0 | 100 | 0.164772727272727 | 29 | 0 | 16 | 0 | 120 | 148 | 2020 | 1992 | Plasmodium chabaudi chabaudi conserved Plasmodium protein, unknown function (PCHAS_1410500), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 12969422 | 12969422 | PRJNA1111146_P_NODE_113291_length_237_cov_0.885870_g112153_i0 | PRJNA1111146 | 113291 | 237 | 0.88587 | 2.0995119 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.15e-74 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g112153 | i0 | 89.03 | 1.9662447257384 | 237 | 24 | 100 | 2 | 1 | 237 | 80496 | 80262 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 466 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12969623 | 12969623 | PRJNA1111146_P_NODE_17371_length_390_cov_9.148368_g16236_i0 | PRJNA1111146 | 17371 | 390 | 9.148368 | 35.6786352 | Gregarina sp. Phaedon/Daegwallyeong/2010 | 1049247 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.03e-69 | NTclustered | gi|339715944|gb|JF412715.1| | 1049247 | g16236 | i0 | 79.661 | 67.4025641025641 | 413 | 60 | 100 | 18 | 1 | 390 | 4097 | 4508 | 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 | 26287 | 276 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina sp. Phaedon/Daegwallyeong/2010 | ||
| 12970021 | 12970021 | PRJNA1111146_P_NODE_2691_length_1190_cov_4.875110_g1818_i0 | PRJNA1111146 | 2691 | 1190 | 4.87511 | 58.013809 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2060 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g1818 | i0 | 98.22 | 1360.48487394958 | 1180 | 18 | 99 | 1 | 14 | 1190 | 1913 | 734 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 1618977 | 2060 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14245951 | 14245951 | PRJNA1111146_P_NODE_51032_length_286_cov_3.489270_g49895_i0 | PRJNA1111146 | 51032 | 286 | 3.48927 | 9.9793122 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 2.21e-127 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g49895 | i0 | 97.112 | 3.21328671328671 | 277 | 8 | 97 | 0 | 3 | 279 | 117378 | 117654 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 919 | 468 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 15519775 | 15519775 | PRJNA1111146_P_NODE_80293_length_256_cov_1.600985_g79155_i0 | PRJNA1111146 | 80293 | 256 | 1.600985 | 4.0985216 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 5.74e-88 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g79155 | i0 | 90.625 | 24.4140625 | 256 | 20 | 100 | 3 | 1 | 256 | 373 | 122 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6250 | 337 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 19342803 | 19342803 | PRJNA1111146_P_NODE_43376_length_298_cov_2.636735_g42239_i0 | PRJNA1111146 | 43376 | 298 | 2.636735 | 7.8574703 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.99e-105 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g42239 | i0 | 90.604 | 15.5201342281879 | 298 | 27 | 100 | 1 | 1 | 297 | 157179 | 157476 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 4625 | 394 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20617028 | 20617028 | PRJNA1111146_P_NODE_20337_length_370_cov_1.444795_g19200_i0 | PRJNA1111146 | 20337 | 370 | 1.444795 | 5.3457415 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 2.249999999999999e-138 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g19200 | i0 | 91.351 | 6.9027027027027 | 370 | 30 | 100 | 2 | 1 | 369 | 157444 | 157812 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2554 | 505 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 21892378 | 21892378 | PRJNA1111146_P_NODE_117058_length_235_cov_1.010989_g115920_i0 | PRJNA1111146 | 117058 | 235 | 1.010989 | 2.37582415 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.91e-72 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g115920 | i0 | 88.559 | 33.8425531914894 | 236 | 25 | 100 | 2 | 1 | 235 | 301734 | 301500 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7953 | 285 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23974230 | 23974230 | PRJNA1111146_P_NODE_340159_length_183_cov_0.869231_g339021_i0 | PRJNA1111146 | 340159 | 183 | 0.869231 | 1.59069273 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.35e-4 | NTclustered | gi|1145257365|ref|XM_020114577.1| | 5854 | g339021 | i0 | 92.683 | 0.672131147540984 | 41 | 2 | 22 | 1 | 85 | 124 | 3658 | 3618 | Plasmodium reichenowi putative membrane protein partial mRNA | blastn | 123 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 25248437 | 25248437 | PRJNA1111146_P_NODE_403540_length_179_cov_0.896825_g402402_i0 | PRJNA1111146 | 403540 | 179 | 0.896825 | 1.60531675 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|2785763289|ref|XM_067216604.1| | 5824 | g402402 | i0 | 100 | 0.312849162011173 | 28 | 0 | 16 | 0 | 69 | 96 | 2408 | 2381 | Plasmodium brasilianum uncharacterized protein (MKS88_003507), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 30952652 | 30952652 | PRJNA1111146_P_NODE_144014_length_223_cov_1.335294_g142876_i0 | PRJNA1111146 | 144014 | 223 | 1.335294 | 2.97770562 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 3.32e-14 | NR | XP_029221480.1 | 94643 | g142876 | i0 | 57.8 | 4.30493273542601 | 64 | 27 | 86.1 | 0 | 204 | 13 | 112 | 175 | XP_029221480.1 ribosomal protein RPP0 [Besnoitia besnoiti] | diamond | 960 | 75.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti |
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);;