contig_metadata
12 rows where bioproject = "PRJNA473824", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447093 | 447093 | PRJNA473824_P_NODE_44661_length_183_cov_3.582192_g44023_i0 | PRJNA473824 | 44661 | 183 | 3.582192 | 6.55541136 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.35e-75 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g44023 | i0 | 95.628 | 3.42622950819672 | 183 | 8 | 100 | 0 | 1 | 183 | 117593 | 117411 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 627 | 294 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 3647289 | 3647289 | PRJNA473824_P_NODE_128103_length_160_cov_4.048780_g127465_i0 | PRJNA473824 | 128103 | 160 | 4.04878 | 6.478048 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|1145256463|ref|XM_012905769.2| | 5854 | g127465 | i0 | 100 | 0.35 | 28 | 0 | 18 | 0 | 113 | 140 | 1836 | 1809 | Plasmodium reichenowi circumsporozoite- and TRAP-related protein partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 9374758 | 9374758 | PRJNA473824_P_NODE_39868_length_192_cov_4.167742_g39230_i0 | PRJNA473824 | 39868 | 192 | 4.167742 | 8.00206464 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.0099999999999997e-46 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g39230 | i0 | 91.096 | 27.7395833333333 | 146 | 13 | 99 | 0 | 1 | 146 | 95786 | 95641 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 5326 | 198 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10650467 | 10650467 | PRJNA473824_P_NODE_26029_length_232_cov_4.456410_g25391_i0 | PRJNA473824 | 26029 | 232 | 4.45641 | 10.3388712 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 1.93e-52 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g25391 | i0 | 83.682 | 10.0172413793103 | 239 | 32 | 100 | 3 | 1 | 232 | 301581 | 301343 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2324 | 219 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11925412 | 11925412 | PRJNA473824_P_NODE_28790_length_221_cov_4.146739_g28152_i0 | PRJNA473824 | 28790 | 221 | 4.146739 | 9.16429319 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 6.519999999999999e-57 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g28152 | i0 | 86.175 | 27.5067873303167 | 217 | 29 | 100 | 1 | 1 | 217 | 96603 | 96388 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6079 | 233 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11925566 | 11925566 | PRJNA473824_P_NODE_39230_length_193_cov_13.128205_g38592_i0 | PRJNA473824 | 39230 | 193 | 13.128205 | 25.33743565 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 9.2e-60 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g38592 | i0 | 89.637 | 19.0725388601036 | 193 | 16 | 100 | 2 | 1 | 193 | 219 | 31 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 3681 | 243 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14475445 | 14475445 | PRJNA473824_P_NODE_36712_length_199_cov_3.302469_g36074_i0 | PRJNA473824 | 36712 | 199 | 3.302469 | 6.57191331 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 2.69e-50 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g36074 | i0 | 87.31 | 33.0904522613065 | 197 | 10 | 100 | 2 | 1 | 197 | 299173 | 298992 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6585 | 211 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18297768 | 18297768 | PRJNA473824_P_NODE_119875_length_171_cov_2.753731_g119237_i0 | PRJNA473824 | 119875 | 171 | 2.753731 | 4.70888001 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 4.8e-52 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g119237 | i0 | 89.474 | 42.4444444444444 | 171 | 18 | 100 | 0 | 1 | 171 | 116284 | 116454 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7258 | 217 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 18947799 | 18947799 | PRJNA473824_P_NODE_15575_length_302_cov_4.818868_g14937_i0 | PRJNA473824 | 15575 | 302 | 4.818868 | 14.55298136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 1.1599999999999998e-85 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g14937 | i0 | 85.809 | 674.738410596026 | 303 | 31 | 100 | 2 | 1 | 302 | 309 | 18 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 203771 | 329 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 19572304 | 19572304 | PRJNA473824_P_NODE_15956_length_298_cov_3.586207_g15318_i0 | PRJNA473824 | 15956 | 298 | 3.586207 | 10.68689686 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 3.2699999999999997e-66 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g15318 | i0 | 88.532 | 1.47986577181208 | 218 | 25 | 75 | 0 | 6 | 223 | 80426 | 80209 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 441 | 265 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19572864 | 19572864 | PRJNA473824_P_NODE_49876_length_175_cov_3.036232_g49238_i0 | PRJNA473824 | 49876 | 175 | 3.036232 | 5.313406 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.3899999999999996e-42 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g49238 | i0 | 87.195 | 2.37714285714286 | 164 | 20 | 93 | 1 | 6 | 168 | 97220 | 97383 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 416 | 185 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20848577 | 20848577 | PRJNA473824_P_NODE_41117_length_190_cov_1.856209_g40479_i0 | PRJNA473824 | 41117 | 190 | 1.856209 | 3.5267971 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 8.96e-65 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g40479 | i0 | 94.643 | 13.8315789473684 | 168 | 8 | 89 | 1 | 1 | 167 | 301458 | 301625 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2628 | 259 | 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);;