contig_metadata
7 rows where bioproject = "PRJNA1196438", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 323048 | 323048 | PRJNA1196438_P_NODE_36261_length_294_cov_4.647059_g35835_i0 | PRJNA1196438 | 36261 | 294 | 4.647059 | 13.66235346 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 3.74e-140 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g35835 | i0 | 98.611 | 5.06462585034014 | 288 | 4 | 98 | 0 | 7 | 294 | 117534 | 117247 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1489 | 510 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 1598316 | 1598316 | PRJNA1196438_P_NODE_83882_length_225_cov_4.177632_g83455_i0 | PRJNA1196438 | 83882 | 225 | 4.177632 | 9.399672 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 8.31e-81 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g83455 | i0 | 91.964 | 20.3022222222222 | 224 | 17 | 99 | 1 | 2 | 225 | 300321 | 300543 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 4568 | 313 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 4150368 | 4150368 | PRJNA1196438_P_NODE_68624_length_248_cov_3.068571_g68197_i0 | PRJNA1196438 | 68624 | 248 | 3.068571 | 7.61005608 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 9.249999999999998e-86 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g68197 | i0 | 90.726 | 2.00403225806452 | 248 | 21 | 100 | 2 | 1 | 246 | 80162 | 80409 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 497 | 329 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11801594 | 11801594 | PRJNA1196438_P_NODE_39290_length_290_cov_1.488479_g38863_i0 | PRJNA1196438 | 39290 | 290 | 1.488479 | 4.3165891 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2794768076|ref|XM_067947470.1| | 323732 | g38863 | i0 | 90.476 | 0.144827586206897 | 42 | 3 | 14 | 1 | 43 | 84 | 205 | 165 | Babesia duncani uncharacterized protein (BdWA1_002447), partial mRNA | blastn | 42 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 18174731 | 18174731 | PRJNA1196438_P_NODE_42735_length_284_cov_6.407583_g42308_i0 | PRJNA1196438 | 42735 | 284 | 6.407583 | 18.19753572 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.68e-125 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g42308 | i0 | 98.473 | 791.676056338028 | 262 | 3 | 92 | 1 | 13 | 273 | 724 | 985 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 224836 | 460 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 20724719 | 20724719 | PRJNA1196438_P_NODE_61577_length_256_cov_1.513661_g61150_i0 | PRJNA1196438 | 61577 | 256 | 1.513661 | 3.87497216 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 7.209999999999998e-107 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g61150 | i0 | 94.922 | 26.6484375 | 256 | 12 | 99 | 1 | 2 | 256 | 302325 | 302070 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6822 | 399 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23275375 | 23275375 | PRJNA1196438_P_NODE_45179_length_281_cov_1.129808_g44752_i0 | PRJNA1196438 | 45179 | 281 | 1.129808 | 3.17476048 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.68e-115 | NTclustered | gi|1624698160|ref|XM_029013948.1| | 189622 | g44752 | i0 | 94.891 | 833.46975088968 | 274 | 13 | 98 | 1 | 8 | 281 | 296 | 24 | Babesia ovata zinc finger protein 33B (BOVATA_050310), partial mRNA | blastn | 234205 | 427 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata |
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);;