contig_metadata
9 rows where bioproject = "PRJNA814235", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 817566 | 817566 | PRJNA814235_P_NODE_36781_length_315_cov_3.032374_g35392_i0 | PRJNA814235 | 36781 | 315 | 3.032374 | 9.5519781 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 2.17e-38 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g35392 | i0 | 93.86 | 7.93968253968254 | 114 | 7 | 36 | 0 | 190 | 303 | 300538 | 300425 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2501 | 172 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 4644534 | 4644534 | PRJNA814235_P_NODE_147644_length_176_cov_6.258993_g146249_i0 | PRJNA814235 | 147644 | 176 | 6.258993 | 11.01582768 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.08e-48 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g146249 | i0 | 88.068 | 5.55681818181818 | 176 | 17 | 100 | 2 | 1 | 176 | 5 | 176 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 978 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 7196839 | 7196839 | PRJNA814235_P_NODE_83246_length_208_cov_2.467836_g81851_i0 | PRJNA814235 | 83246 | 208 | 2.467836 | 5.13309888 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.59e-97 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g81851 | i0 | 98.558 | 5.31730769230769 | 208 | 3 | 100 | 0 | 1 | 208 | 117513 | 117306 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1106 | 368 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11019227 | 11019227 | PRJNA814235_P_NODE_121349_length_202_cov_6.127273_g119954_i0 | PRJNA814235 | 121349 | 202 | 6.127273 | 12.37709146 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.08e-66 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g119954 | i0 | 90.594 | 12.3415841584158 | 202 | 16 | 100 | 2 | 1 | 202 | 69 | 267 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 2493 | 265 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 14843760 | 14843760 | PRJNA814235_P_NODE_131992_length_192_cov_4.658065_g130597_i0 | PRJNA814235 | 131992 | 192 | 4.658065 | 8.9434848 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 1.52e-62 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g130597 | i0 | 91.398 | 21.59375 | 186 | 13 | 100 | 2 | 1 | 186 | 283 | 101 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 4146 | 252 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 17394044 | 17394044 | PRJNA814235_P_NODE_132854_length_191_cov_4.746753_g131459_i0 | PRJNA814235 | 132854 | 191 | 4.746753 | 9.06629823 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.17e-63 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g131459 | i0 | 91.892 | 21.5340314136126 | 185 | 12 | 100 | 2 | 1 | 185 | 282 | 101 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 4113 | 255 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 21218510 | 21218510 | PRJNA814235_P_NODE_166217_length_162_cov_0.856000_g164822_i0 | PRJNA814235 | 166217 | 162 | 0.856 | 1.38672 | Anthozoaphila gnarlus | 2783686 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.19e-20 | NTclustered | gi|2887160896|gb|PQ872231.1| | 2783686 | g164822 | i0 | 95.652 | 42.6234567901235 | 69 | 3 | 43 | 0 | 4 | 72 | 883 | 815 | Anthozoaphila gnarlus isolate GZ27070 large subunit ribosomal RNA gene, partial sequence | blastn | 6905 | 111 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Corallicolida | Corallicolidae | Anthozoaphila | Anthozoaphila gnarlus | ||
| 23770396 | 23770396 | PRJNA814235_P_NODE_53819_length_259_cov_5.027027_g52425_i0 | PRJNA814235 | 53819 | 259 | 5.027027 | 13.019999930000001 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 2.089999999999999e-87 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g52425 | i0 | 90.347 | 18.9382239382239 | 259 | 20 | 100 | 4 | 1 | 259 | 441 | 188 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 4905 | 335 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 25044778 | 25044778 | PRJNA814235_P_NODE_74240_length_221_cov_1.836957_g72845_i0 | PRJNA814235 | 74240 | 221 | 1.836957 | 4.05967497 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 5.04e-58 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g72845 | i0 | 85.973 | 2.00904977375566 | 221 | 31 | 100 | 0 | 1 | 221 | 157652 | 157432 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 444 | 237 | 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);;