contig_metadata
7 rows where bioproject = "PRJNA1093008", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4025620 | 4025620 | PRJNA1093008_S_NODE_93244_length_243_cov_0.905882_g92917_i0 | PRJNA1093008 | 93244 | 243 | 0.905882 | 2.20129326 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.98e-72 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g92917 | i0 | 90.411 | 16.8312757201646 | 219 | 18 | 91 | 2 | 25 | 243 | 63 | 278 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 4090 | 285 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 8672211 | 8672211 | PRJNA1093008_S_NODE_24487_length_355_cov_7.195035_g24160_i0 | PRJNA1093008 | 24487 | 355 | 7.195035 | 25.54237425 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.579999999999999e-145 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g24160 | i0 | 95.468 | 1204.90704225352 | 331 | 13 | 93 | 2 | 27 | 355 | 597 | 267 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 427742 | 527 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 9126513 | 9126513 | PRJNA1093008_S_NODE_78648_length_254_cov_1.574586_g78321_i0 | PRJNA1093008 | 78648 | 254 | 1.574586 | 3.99944844 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1620128169|ref|XM_028673384.1| | 5849 | g78321 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 174 | 201 | 582 | 609 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00461900), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 10402095 | 10402095 | PRJNA1093008_S_NODE_73889_length_260_cov_1.101604_g73562_i0 | PRJNA1093008 | 73889 | 260 | 1.101604 | 2.8641704 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.26e-89 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g73562 | i0 | 93.534 | 27.6769230769231 | 232 | 12 | 91 | 3 | 28 | 259 | 256 | 484 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 7196 | 342 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 18050392 | 18050392 | PRJNA1093008_S_NODE_60915_length_277_cov_1.132353_g60588_i0 | PRJNA1093008 | 60915 | 277 | 1.132353 | 3.13661781 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.659999999999998e-42 | NTclustered | gi|1027956776|ref|XM_016798718.1| | 31271 | g60588 | i0 | 85.632 | 28.4657039711191 | 174 | 25 | 63 | 0 | 92 | 265 | 198 | 25 | Plasmodium chabaudi chabaudi ubiquitin-60S ribosomal protein L40, putative (PCHAS_1141200), partial mRNA | blastn | 7885 | 183 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 18050437 | 18050437 | PRJNA1093008_S_NODE_65815_length_270_cov_1.563452_g65488_i0 | PRJNA1093008 | 65815 | 270 | 1.563452 | 4.2213204 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1145256267|ref|XM_012905653.2| | 5854 | g65488 | i0 | 96.97 | 1.88518518518519 | 33 | 1 | 12 | 0 | 226 | 258 | 593 | 561 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 509 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 25245350 | 25245350 | PRJNA1093008_S_NODE_47080_length_299_cov_1.933628_g46753_i0 | PRJNA1093008 | 47080 | 299 | 1.933628 | 5.78154772 | root | 1 | Root_unresolved | Root_unresolved | 191 | 5.65e-44 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g46753 | i0 | 98.165 | 102.016722408027 | 109 | 2 | 36 | 0 | 1 | 109 | 242 | 134 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 30503 | 191 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina |
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);;