contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 850589 | 850589 | PRJNA870096_S_NODE_78721_length_198_cov_0.896774_g77057_i0 | PRJNA870096 | 78721 | 198 | 0.896774 | 1.77561252 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 5.829999999999998e-42 | NTclustered | gi|2787703497|ref|XM_067346083.1| | 1280935 | g77057 | i0 | 84.103 | 98.0454545454545 | 195 | 25 | 98 | 1 | 1 | 195 | 94 | 282 | Cryptosporidium sp. chipmunk genotype I elongation factor 1-alpha (ELE39_002979), partial mRNA | blastn | 19413 | 183 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 3789185 | 3789185 | PRJNA870096_S_NODE_25823_length_354_cov_17.106109_g24159_i0 | PRJNA870096 | 25823 | 354 | 17.106109 | 60.55562586 | Goussia | 169155 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.72e-109 | NTclustered | gi|328460765|gb|GU479640.1| | 947543 | g24159 | i0 | 88.473 | 77.6158192090395 | 347 | 23 | 94 | 10 | 21 | 354 | 401 | 743 | Goussia carpelli isolate CYP139-#139 18S ribosomal RNA gene, partial sequence | blastn | 27476 | 409 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia carpelli | ||
| 4679042 | 4679042 | PRJNA870096_S_NODE_88524_length_187_cov_1.215278_g86860_i0 | PRJNA870096 | 88524 | 187 | 1.215278 | 2.27256986 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 9.169999999999999e-35 | NTclustered | gi|311692297|dbj|AB564273.1| | 5802 | g86860 | i0 | 83.626 | 127.235294117647 | 171 | 26 | 90 | 1 | 4 | 172 | 2292 | 2462 | Eimeria tenella apicoplast gene for 26S large subunit ribosomal RNA, complete sequence, strain: NIAH | blastn | 23793 | 159 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 4679140 | 4679140 | PRJNA870096_S_NODE_95404_length_180_cov_3.489051_g93740_i0 | PRJNA870096 | 95404 | 180 | 3.489051 | 6.2802918 | Eimeria paludosa | 1497015 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 8.439999999999999e-60 | NTclustered | gi|653601277|gb|KJ767188.1| | 1497015 | g93740 | i0 | 91.16 | 91.4611111111111 | 181 | 12 | 100 | 4 | 1 | 180 | 1288 | 1465 | Eimeria paludosa isolate DMH01 28S ribosomal RNA gene, partial sequence | blastn | 16463 | 243 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria paludosa | ||
| 5953263 | 5953263 | PRJNA870096_S_NODE_27425_length_343_cov_5.663333_g25761_i0 | PRJNA870096 | 27425 | 343 | 5.663333 | 19.42523219 | Eimeria sp. | 1729940 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 2.2699999999999996e-73 | NTclustered | gi|1086927510|gb|KX094956.1| | 1729940 | g25761 | i0 | 82.477 | 96.5626822157434 | 331 | 57 | 96 | 1 | 1 | 330 | 2602 | 2272 | Eimeria sp. strain OTU-Z2 mitochondrion, complete genome | blastn | 33121 | 289 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria sp. | ||
| 8502581 | 8502581 | PRJNA870096_S_NODE_133367_length_154_cov_3.459459_g131703_i0 | PRJNA870096 | 133367 | 154 | 3.459459 | 5.32756686 | Goussia sp. BMR-2011c | 980545 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 5.56e-41 | NTclustered | gi|328460783|gb|GU479658.1| | 980545 | g131703 | i0 | 94.783 | 33.1753246753247 | 115 | 6 | 75 | 0 | 40 | 154 | 1527 | 1413 | Goussia sp. BMR-2011c isolate CAR620-#620 18S ribosomal RNA gene, partial sequence | blastn | 5109 | 180 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia sp. BMR-2011c | ||
| 9777860 | 9777860 | PRJNA870096_S_NODE_26268_length_351_cov_6.769481_g24604_i0 | PRJNA870096 | 26268 | 351 | 6.769481 | 23.76087831 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 2.23e-103 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g24604 | i0 | 88.218 | 88.1965811965812 | 331 | 32 | 93 | 7 | 1 | 327 | 354 | 27 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 30957 | 388 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 12328375 | 12328375 | PRJNA870096_S_NODE_10250_length_576_cov_16.763602_g8686_i0 | PRJNA870096 | 10250 | 576 | 16.763602 | 96.55834752 | Goussia balatonica | 947538 | SAR_Eukaryotes | SAR_Eukaryotes | 706 | 0 | NTclustered | gi|324022100|gb|GU593717.1| | 947538 | g8686 | i0 | 94.004 | 74.9114583333333 | 467 | 25 | 88 | 3 | 112 | 576 | 2054 | 1589 | Goussia balatonica strain 608 28S ribosomal RNA gene, partial sequence | blastn | 43149 | 706 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia balatonica | ||
| 12329697 | 12329697 | PRJNA870096_S_NODE_8110_length_653_cov_6.132787_g6654_i0 | PRJNA870096 | 8110 | 653 | 6.132787 | 40.04709911 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 1173 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g6654 | i0 | 99.081 | 1759.35681470138 | 653 | 6 | 100 | 0 | 1 | 653 | 1897 | 1245 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 1148860 | 1173 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 13603601 | 13603601 | PRJNA870096_S_NODE_24651_length_363_cov_3.237500_g22987_i0 | PRJNA870096 | 24651 | 363 | 3.2375 | 11.752125 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 4.27e-31 | NTclustered | gi|820688590|tpe|LN714475.1| | 572307 | g22987 | i0 | 92.308 | 28.8870523415978 | 104 | 8 | 29 | 0 | 259 | 362 | 951293 | 951190 | TPA_asm: Neospora caninum Liverpool, chromosome chrIb, complete genome | blastn | 10486 | 148 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14878202 | 14878202 | PRJNA870096_S_NODE_52372_length_243_cov_1.800000_g50708_i0 | PRJNA870096 | 52372 | 243 | 1.8 | 4.374 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.64e-5 | NTclustered | gi|1939228054|ref|XM_038023111.1| | 44415 | g50708 | i0 | 92.857 | 0.172839506172839 | 42 | 3 | 17 | 0 | 193 | 234 | 898 | 857 | Eimeria mitis 58 kDa phosphoprotein, putative (EMH_0003140), partial mRNA | blastn | 42 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 14878669 | 14878669 | PRJNA870096_S_NODE_89412_length_186_cov_1.398601_g87748_i0 | PRJNA870096 | 89412 | 186 | 1.398601 | 2.60139786 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1620115444|ref|XM_028670889.1| | 5849 | g87748 | i0 | 100 | 0.155913978494624 | 29 | 0 | 16 | 0 | 115 | 143 | 1070 | 1042 | Plasmodium gallinaceum spindle assembly abnormal protein 4, putative (SAS4), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 17428029 | 17428029 | PRJNA870096_S_NODE_18754_length_419_cov_9.135638_g17100_i0 | PRJNA870096 | 18754 | 419 | 9.135638 | 38.27832322 | Goussia carpelli | 947543 | SAR_Eukaryotes | SAR_Eukaryotes | 658 | 0 | NTclustered | gi|324022099|gb|GU593716.1| | 947543 | g17100 | i0 | 96.954 | 95.5871121718377 | 394 | 9 | 94 | 3 | 26 | 417 | 444 | 836 | Goussia carpelli strain 23 28S ribosomal RNA gene, partial sequence | blastn | 40051 | 658 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia carpelli | ||
| 18701641 | 18701641 | PRJNA870096_S_NODE_52615_length_242_cov_4.984925_g50951_i0 | PRJNA870096 | 52615 | 242 | 4.984925 | 12.0635185 | Apicomplexa sp. ABonacolta-2023a | 3096982 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 7.15e-67 | NTclustered | gi|2623109821|gb|OR832858.1| | 3096982 | g50951 | i0 | 91.667 | 71.4628099173554 | 192 | 16 | 79 | 0 | 1 | 192 | 3959 | 4150 | Apicomplexa sp. ABonacolta-2023a 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17294 | 267 | 1 | Eukaryota | Sar | Apicomplexa | Apicomplexa sp. ABonacolta-2023a | ||||||
| 19976779 | 19976779 | PRJNA870096_S_NODE_50196_length_248_cov_7.873171_g48532_i0 | PRJNA870096 | 50196 | 248 | 7.873171 | 19.52546408 | Goussia sp. BMR-2011c | 980545 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 9e-106 | NTclustered | gi|328460764|gb|GU479639.1| | 980545 | g48532 | i0 | 98.655 | 90.375 | 223 | 3 | 90 | 0 | 1 | 223 | 349 | 127 | Goussia sp. BMR-2011c isolate GCAR812-#812 18S ribosomal RNA gene, partial sequence | blastn | 22413 | 396 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia sp. BMR-2011c | ||
| 21252118 | 21252118 | PRJNA870096_S_NODE_31697_length_318_cov_2.214545_g30033_i0 | PRJNA870096 | 31697 | 318 | 2.214545 | 7.0422531 | Isospora amphiboluri | 1692217 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 2.0399999999999995e-88 | NTclustered | gi|913022872|gb|KR108297.1| | 1692217 | g30033 | i0 | 85.893 | 71.6823899371069 | 319 | 43 | 100 | 2 | 1 | 318 | 914 | 1231 | Isospora amphiboluri voucher AHL12-019929 mitochondrion, complete genome | blastn | 22795 | 339 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Isospora | Isospora amphiboluri | ||
| 22526240 | 22526240 | PRJNA870096_S_NODE_11998_length_532_cov_3.147239_g10391_i0 | PRJNA870096 | 11998 | 532 | 3.147239 | 16.74331148 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.81e-26 | NTclustered | gi|820691464|tpe|LN714483.1| | 572307 | g10391 | i0 | 83.916 | 6.07330827067669 | 143 | 19 | 27 | 3 | 386 | 526 | 5992954 | 5993094 | TPA_asm: Neospora caninum Liverpool, chromosome chrVIII, complete genome | blastn | 3231 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum |
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);;