contig_metadata
11 rows where bioproject = "PRJNA1126661", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4109728 | 4109728 | PRJNA1126661_P_NODE_67644_length_259_cov_4.037634_g67114_i0 | PRJNA1126661 | 67644 | 259 | 4.037634 | 10.45747206 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 9.589999999999999e-96 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g67114 | i0 | 92.829 | 5.21235521235521 | 251 | 17 | 97 | 1 | 10 | 259 | 157570 | 157320 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1350 | 363 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 9210267 | 9210267 | PRJNA1126661_P_NODE_30548_length_326_cov_0.379447_g30019_i0 | PRJNA1126661 | 30548 | 326 | 0.379447 | 1.23699722 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.37e-30 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g30019 | i0 | 100 | 10.0981595092025 | 79 | 0 | 48 | 0 | 248 | 326 | 299313 | 299391 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3292 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 9210679 | 9210679 | PRJNA1126661_P_NODE_66688_length_261_cov_9.404255_g66158_i0 | PRJNA1126661 | 66688 | 261 | 9.404255 | 24.54510555 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 7.48e-97 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g66158 | i0 | 92.549 | 1.97701149425287 | 255 | 19 | 100 | 0 | 7 | 261 | 80164 | 80418 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 516 | 366 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 13036044 | 13036044 | PRJNA1126661_P_NODE_32171_length_315_cov_4.537190_g31642_i0 | PRJNA1126661 | 32171 | 315 | 4.53719 | 14.2921485 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 3.96e-155 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g31642 | i0 | 98.73 | 5.19047619047619 | 315 | 4 | 100 | 0 | 1 | 315 | 117599 | 117285 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1635 | 560 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 15585566 | 15585566 | PRJNA1126661_P_NODE_59613_length_278_cov_7.029268_g59083_i0 | PRJNA1126661 | 59613 | 278 | 7.029268 | 19.54136504 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.73e-98 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g59083 | i0 | 90.975 | 35.7985611510791 | 277 | 24 | 100 | 1 | 3 | 278 | 97428 | 97152 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 9952 | 372 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 15585688 | 15585688 | PRJNA1126661_P_NODE_74873_length_241_cov_3.672619_g74343_i0 | PRJNA1126661 | 74873 | 241 | 3.672619 | 8.85101179 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.819999999999997e-96 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g74343 | i0 | 94.191 | 27.9626556016598 | 241 | 9 | 100 | 5 | 1 | 241 | 314 | 79 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6739 | 363 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 15585764 | 15585764 | PRJNA1126661_P_NODE_86573_length_202_cov_11.643411_g86043_i0 | PRJNA1126661 | 86573 | 202 | 11.643411 | 23.51969022 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 2.7199999999999995e-55 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g86043 | i0 | 87.437 | 1.99009900990099 | 199 | 23 | 99 | 2 | 2 | 200 | 80454 | 80650 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 402 | 228 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18134570 | 18134570 | PRJNA1126661_P_NODE_76935_length_235_cov_2.888889_g76405_i0 | PRJNA1126661 | 76935 | 235 | 2.888889 | 6.78888915 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.99e-42 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g76405 | i0 | 83.582 | 13.2212765957447 | 201 | 30 | 100 | 3 | 4 | 203 | 96631 | 96433 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3107 | 185 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20684070 | 20684070 | PRJNA1126661_P_NODE_57817_length_282_cov_10.937799_g57288_i0 | PRJNA1126661 | 57817 | 282 | 10.937799 | 30.84459318 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 7.84e-127 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g57288 | i0 | 96.454 | 54.3156028368794 | 282 | 10 | 100 | 0 | 1 | 282 | 116101 | 116382 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 15317 | 466 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23235193 | 23235193 | PRJNA1126661_P_NODE_86019_length_204_cov_5.954198_g85489_i0 | PRJNA1126661 | 86019 | 204 | 5.954198 | 12.14656392 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.68e-75 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g85489 | i0 | 92.683 | 38.2745098039216 | 205 | 13 | 99 | 1 | 2 | 204 | 116137 | 116341 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7808 | 294 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 29344060 | 29344060 | PRJNA1126661_P_NODE_26689_length_326_cov_2.984190_g26160_i0 | PRJNA1126661 | 26689 | 326 | 2.98419 | 9.7284594 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 2.21e-8 | NR | KAF8820843.1 | 476202 | g26160 | i0 | 56.1 | 1.61963190184049 | 57 | 17 | 46 | 2 | 3 | 152 | 25 | 80 | KAF8820843.1 UBX domain-containing protein [Cardiosporidium cionae] | diamond | 528 | 60.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae |
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);;