contig_metadata
8 rows where bioproject = "PRJNA942359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 922932 | 922932 | PRJNA942359_P_NODE_17201_length_247_cov_0.833333_g17086_i0 | PRJNA942359 | 17201 | 247 | 0.833333 | 2.05833251 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 9.21e-86 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g17086 | i0 | 91.02 | 28.5182186234818 | 245 | 20 | 100 | 2 | 3 | 247 | 300353 | 300595 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7044 | 329 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 4751268 | 4751268 | PRJNA942359_P_NODE_13524_length_252_cov_1.206704_g13409_i0 | PRJNA942359 | 13524 | 252 | 1.206704 | 3.04089408 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.49e-123 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g13409 | i0 | 99.206 | 25.5753968253968 | 252 | 2 | 100 | 0 | 1 | 252 | 300053 | 300304 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6445 | 455 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8576114 | 8576114 | PRJNA942359_P_NODE_9927_length_281_cov_1.500000_g9812_i0 | PRJNA942359 | 9927 | 281 | 1.5 | 4.215 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.78e-88 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g9812 | i0 | 90.038 | 11.2989323843416 | 261 | 26 | 100 | 0 | 1 | 261 | 157575 | 157315 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3175 | 339 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12402229 | 12402229 | PRJNA942359_P_NODE_5390_length_358_cov_1.077193_g5275_i0 | PRJNA942359 | 5390 | 358 | 1.077193 | 3.85635094 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 1.01e-136 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g5275 | i0 | 92.113 | 45.3854748603352 | 355 | 27 | 99 | 1 | 3 | 357 | 300715 | 300362 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 16248 | 499 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 17501335 | 17501335 | PRJNA942359_P_NODE_8374_length_300_cov_0.894273_g8259_i0 | PRJNA942359 | 8374 | 300 | 0.894273 | 2.682819 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 8.77e-97 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g8259 | i0 | 88.667 | 27.3233333333333 | 300 | 34 | 100 | 0 | 1 | 300 | 116165 | 116464 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 8197 | 366 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18774916 | 18774916 | PRJNA942359_P_NODE_8415_length_299_cov_1.066372_g8300_i0 | PRJNA942359 | 8415 | 299 | 1.066372 | 3.18845228 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.99e-131 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g8300 | i0 | 95.652 | 4.89966555183946 | 299 | 13 | 100 | 0 | 1 | 299 | 117510 | 117808 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1465 | 481 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20049799 | 20049799 | PRJNA942359_P_NODE_9996_length_281_cov_0.769231_g9881_i0 | PRJNA942359 | 9996 | 281 | 0.769231 | 2.16153911 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.85e-116 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g9881 | i0 | 94.604 | 45.8078291814947 | 278 | 15 | 100 | 0 | 1 | 278 | 299905 | 299628 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 12872 | 431 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 26803619 | 26803619 | PRJNA942359_P_NODE_17641_length_246_cov_0.901734_g17526_i0 | PRJNA942359 | 17641 | 246 | 0.901734 | 2.21826564 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 4.86e-8 | NR | XP_013233079.1 | 5802 | g17526 | i0 | 30.4 | 0.963414634146341 | 79 | 52 | 92.7 | 1 | 233 | 6 | 238 | 316 | XP_013233079.1 vacuolar protein sorting-associated protein, putative [Eimeria tenella] | diamond | 237 | 59.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella |
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);;