contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1248471" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4180745 | 4180745 | PRJNA1248471_S_NODE_13124_length_189_cov_1.642857_g13024_i0 | PRJNA1248471 | 13124 | 189 | 1.642857 | 3.10499973 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.41e-19 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g13024 | i0 | 83.761 | 10.7089947089947 | 117 | 15 | 62 | 4 | 2 | 117 | 80571 | 80458 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2024 | 108 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6731356 | 6731356 | PRJNA1248471_S_NODE_17686_length_169_cov_3.783333_g17586_i0 | PRJNA1248471 | 17686 | 169 | 3.783333 | 6.39383277 | uncultured stramenopile | 152704 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.73e-79 | NTclustered | gi|291495474|gb|GU823101.1| | 152704 | g17586 | i0 | 99.408 | 100 | 169 | 1 | 100 | 0 | 1 | 169 | 399 | 567 | Uncultured stramenopile clone A93F14RM2B11 18S ribosomal RNA gene, partial sequence | blastn | 16900 | 307 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 7429917 | 7429917 | PRJNA1248471_S_NODE_3926_length_277_cov_4.289474_g3826_i0 | PRJNA1248471 | 3926 | 277 | 4.289474 | 11.88184298 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 4.53e-139 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g3826 | i0 | 99.639 | 100 | 277 | 1 | 100 | 0 | 1 | 277 | 1191 | 915 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 27700 | 512 | 0.990234375 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 8007009 | 8007009 | PRJNA1248471_S_NODE_21787_length_162_cov_0.920354_g21687_i0 | PRJNA1248471 | 21787 | 162 | 0.920354 | 1.49097348 | uncultured diatom | 137771 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 7.83e-25 | NTclustered | gi|60687350|gb|AY821977.1| | 137771 | g21687 | i0 | 92.135 | 6.11111111111111 | 89 | 7 | 55 | 0 | 72 | 160 | 381 | 469 | Uncultured diatom clone CV1_B2_82 small subunit ribosomal RNA gene, partial sequence | blastn | 990 | 126 | 1 | Eukaryota | Sar | Bacillariophyta | uncultured diatom | ||||||
| 10557666 | 10557666 | PRJNA1248471_S_NODE_12449_length_193_cov_0.680556_g12349_i0 | PRJNA1248471 | 12449 | 193 | 0.680556 | 1.31347308 | Ostreopsis sp. s0661 | 1094658 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.47e-28 | NTclustered | gi|359385670|dbj|AB674848.1| | 1094658 | g12349 | i0 | 85.075 | 2.70466321243523 | 134 | 20 | 69 | 0 | 1 | 134 | 306 | 439 | Ostreopsis sp. s0661 gene for 28S ribosomal RNA, partial sequence | blastn | 522 | 137 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Ostreopsidaceae | Ostreopsis | Ostreopsis sp. s0661 | |||
| 11832184 | 11832184 | PRJNA1248471_S_NODE_18250_length_168_cov_0.739496_g18150_i0 | PRJNA1248471 | 18250 | 168 | 0.739496 | 1.24235328 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.81e-6 | NTclustered | gi|2047401816|gb|MZ327268.1| | 5872 | g18150 | i0 | 93.182 | 2.64285714285714 | 44 | 3 | 26 | 0 | 1 | 44 | 178 | 135 | Theileria equi voucher GZ-6 small subunit ribosomal RNA gene, partial sequence | blastn | 444 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 15079576 | 15079576 | PRJNA1248471_S_NODE_12552_length_192_cov_1.832168_g12452_i0 | PRJNA1248471 | 12552 | 192 | 1.832168 | 3.51776256 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.13e-93 | NTclustered | gi|27262897|emb|Y10566.2| | 92081 | g12452 | i0 | 100 | 100 | 192 | 0 | 100 | 0 | 1 | 192 | 755 | 946 | Peridinium balticum endosymbiont partial 18S rRNA gene | blastn | 19200 | 355 | 1 | Eukaryota | Sar | Bacillariophyta | Peridinium balticum endosymbiont |
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);;