contig_metadata
20 rows where bioproject = "PRJNA597223", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1844413 | 1844413 | PRJNA597223_P_NODE_11142_length_516_cov_4.284823_g9437_i0 | PRJNA597223 | 11142 | 516 | 4.284823 | 22.10968668 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 562 | 1.89e-155 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g9437 | i0 | 87.327 | 40.2751937984496 | 505 | 47 | 98 | 6 | 8 | 511 | 300916 | 300428 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 20782 | 562 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 1845191 | 1845191 | PRJNA597223_P_NODE_80062_length_157_cov_6.631148_g78216_i0 | PRJNA597223 | 80062 | 157 | 6.631148 | 10.41090236 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 4.43e-37 | NTclustered | gi|134021789|gb|EF023139.1| | 404735 | g78216 | i0 | 88.971 | 84.0127388535032 | 136 | 14 | 87 | 1 | 19 | 154 | 1514 | 1648 | Eimeriidae environmental sample clone Amb_18S_426 18S ribosomal RNA gene, partial sequence | blastn | 13190 | 167 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 4396628 | 4396628 | PRJNA597223_P_NODE_33364_length_255_cov_3.190909_g31518_i0 | PRJNA597223 | 33364 | 255 | 3.190909 | 8.13681795 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 2.03e-97 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g31518 | i0 | 93.227 | 5.21176470588235 | 251 | 16 | 98 | 1 | 1 | 250 | 301726 | 301476 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1329 | 368 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 5672648 | 5672648 | PRJNA597223_P_NODE_19285_length_370_cov_14.988060_g17458_i0 | PRJNA597223 | 19285 | 370 | 14.98806 | 55.455822 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 3.119999999999999e-87 | NTclustered | gi|134021988|gb|EF023338.1| | 404735 | g17458 | i0 | 83.871 | 63.1810810810811 | 372 | 39 | 99 | 6 | 1 | 368 | 1678 | 1324 | Eimeriidae environmental sample clone Amb_18S_660 18S ribosomal RNA gene, partial sequence | blastn | 23377 | 335 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 6947916 | 6947916 | PRJNA597223_S_NODE_506_length_383_cov_2.017442_g449_i0 | PRJNA597223 | 506 | 383 | 2.017442 | 7.72680286 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 5.38e-90 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g449 | i0 | 83.82 | 28.532637075718 | 377 | 46 | 100 | 7 | 5 | 381 | 301862 | 301501 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 10928 | 344 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 9497400 | 9497400 | PRJNA597223_P_NODE_32308_length_261_cov_2.358407_g30462_i0 | PRJNA597223 | 32308 | 261 | 2.358407 | 6.15544227 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 4.7e-64 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g30462 | i0 | 86.695 | 3.78927203065134 | 233 | 29 | 98 | 2 | 11 | 243 | 300156 | 299926 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 989 | 257 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12048375 | 12048375 | PRJNA597223_P_NODE_51370_length_194_cov_3.144654_g49524_i0 | PRJNA597223 | 51370 | 194 | 3.144654 | 6.10062876 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 4.37e-48 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g49524 | i0 | 85.714 | 1.01030927835052 | 196 | 24 | 100 | 3 | 1 | 194 | 80210 | 80403 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 196 | 204 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12048630 | 12048630 | PRJNA597223_P_NODE_74950_length_164_cov_1.193798_g73104_i0 | PRJNA597223 | 74950 | 164 | 1.193798 | 1.95782872 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1843574730|ref|XM_034567299.1| | 5823 | g73104 | i0 | 96.875 | 0.195121951219512 | 32 | 1 | 20 | 0 | 126 | 157 | 4258 | 4227 | Plasmodium berghei ANKA intron-binding protein aquarius, putative (PBANKA_1365300), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 13322922 | 13322922 | PRJNA597223_P_NODE_32911_length_258_cov_1.511211_g31065_i0 | PRJNA597223 | 32911 | 258 | 1.511211 | 3.89892438 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.9e-5 | NTclustered | gi|832041461|ref|XM_012910202.1| | 5854 | g31065 | i0 | 80 | 0.329457364341085 | 85 | 15 | 33 | 2 | 152 | 235 | 121 | 204 | Plasmodium reichenowi 40S ribosomal protein S28e, putative partial mRNA | blastn | 85 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 13323097 | 13323097 | PRJNA597223_P_NODE_47391_length_203_cov_7.011905_g45545_i0 | PRJNA597223 | 47391 | 203 | 7.011905 | 14.23416715 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 7.61e-56 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g45545 | i0 | 99.213 | 12.7290640394089 | 127 | 1 | 100 | 0 | 77 | 203 | 301092 | 301218 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2584 | 230 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 17146513 | 17146513 | PRJNA597223_P_NODE_19214_length_371_cov_4.919643_g17387_i0 | PRJNA597223 | 19214 | 371 | 4.919643 | 18.25187553 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 647 | 0 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g17387 | i0 | 98.113 | 8.1266846361186 | 371 | 7 | 100 | 0 | 1 | 371 | 117365 | 117735 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3015 | 647 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18420888 | 18420888 | PRJNA597223_P_NODE_28955_length_282_cov_4.311741_g27109_i0 | PRJNA597223 | 28955 | 282 | 4.311741 | 12.15910962 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.6e-68 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g27109 | i0 | 91 | 23.6631205673759 | 200 | 18 | 94 | 0 | 6 | 205 | 301719 | 301520 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6673 | 270 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18421449 | 18421449 | PRJNA597223_P_NODE_77455_length_161_cov_1.079365_g75609_i0 | PRJNA597223 | 77455 | 161 | 1.079365 | 1.73777765 | Enterocystis dorypterygis | 2018055 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.24e-75 | NTclustered | gi|1214786106|gb|KY697695.1| | 2018055 | g75609 | i0 | 99.379 | 32.0621118012422 | 161 | 1 | 100 | 0 | 1 | 161 | 95 | 255 | Enterocystis dorypterygis 18S ribosomal RNA gene, partial sequence | blastn | 5162 | 292 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Enterocystidae | Enterocystis | Enterocystis dorypterygis | ||
| 19695288 | 19695288 | PRJNA597223_P_NODE_20196_length_359_cov_10.388889_g18362_i0 | PRJNA597223 | 20196 | 359 | 10.388889 | 37.29611151 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 8.27e-98 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g18362 | i0 | 86.88 | 49.7966573816156 | 343 | 29 | 100 | 7 | 6 | 348 | 300578 | 300252 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 17877 | 370 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 22245951 | 22245951 | PRJNA597223_P_NODE_15618_length_423_cov_4.451031_g13819_i0 | PRJNA597223 | 15618 | 423 | 4.451031 | 18.82786113 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 647 | 0 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g13819 | i0 | 94.326 | 7.99290780141844 | 423 | 23 | 100 | 1 | 1 | 423 | 156988 | 157409 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3381 | 647 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23521790 | 23521790 | PRJNA597223_P_NODE_74939_length_164_cov_1.217054_g73093_i0 | PRJNA597223 | 74939 | 164 | 1.217054 | 1.99596856 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.72e-21 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g73093 | i0 | 87.755 | 13.6890243902439 | 98 | 12 | 88 | 0 | 1 | 98 | 96628 | 96531 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2245 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23521906 | 23521906 | PRJNA597223_P_NODE_8399_length_601_cov_7.203180_g6862_i0 | PRJNA597223 | 8399 | 601 | 7.20318 | 43.2911118 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 933 | 0 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g6862 | i0 | 94.684 | 63.712146422629 | 602 | 31 | 100 | 1 | 1 | 601 | 116173 | 116774 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 38291 | 933 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24795762 | 24795762 | PRJNA597223_S_NODE_1140_length_267_cov_1.114035_g1083_i0 | PRJNA597223 | 1140 | 267 | 1.114035 | 2.97447345 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.84e-76 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g1083 | i0 | 86.891 | 32.4119850187266 | 267 | 33 | 99 | 1 | 1 | 265 | 300282 | 300016 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 8654 | 298 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 28311635 | 28311635 | PRJNA597223_P_NODE_33686_length_254_cov_1.342466_g31840_i0 | PRJNA597223 | 33686 | 254 | 1.342466 | 3.40986364 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 7.05e-29 | NR | VWU51230.1 | 2600580 | g31840 | i0 | 74 | 3.72047244094488 | 77 | 19 | 89.8 | 1 | 22 | 249 | 1 | 77 | VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 945 | 109 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 29258504 | 29258504 | PRJNA597223_P_NODE_37789_length_235_cov_1.440000_g35943_i0 | PRJNA597223 | 37789 | 235 | 1.44 | 3.384 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 9.71e-6 | NR | XP_067068079.1 | 117008 | g35943 | i0 | 41 | 0.778723404255319 | 61 | 36 | 77.9 | 0 | 187 | 5 | 166 | 226 | XP_067068079.1 folate biopterin transporter family protein [Cryptosporidium andersoni] | diamond | 183 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni |
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);;