contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA399133" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1688054 | 1688054 | PRJNA399133_P_NODE_2402_length_321_cov_1.842657_g2314_i0 | PRJNA399133 | 2402 | 321 | 1.842657 | 5.91492897 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.47e-4 | NTclustered | gi|404352171|gb|JX283477.1| | 5833 | g2314 | i0 | 100 | 31.9065420560748 | 31 | 0 | 10 | 0 | 282 | 312 | 134 | 164 | Plasmodium falciparum isolate JGD39 merozoite surface protein 1 gene, partial cds | blastn | 10242 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 5516892 | 5516892 | PRJNA399133_P_NODE_10645_length_162_cov_1.070866_g10557_i0 | PRJNA399133 | 10645 | 162 | 1.070866 | 1.73480292 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 4.5199999999999996e-52 | NTclustered | gi|238617656|gb|FJ973407.1| | 2986 | g10557 | i0 | 90.741 | 94.0617283950617 | 162 | 15 | 100 | 0 | 1 | 162 | 337 | 176 | Ochromonas danica strain ATCC 30004 alpha-tubulin (atub) gene, partial cds | blastn | 15238 | 217 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 6790881 | 6790881 | PRJNA399133_P_NODE_10506_length_163_cov_0.875000_g10418_i0 | PRJNA399133 | 10506 | 163 | 0.875 | 1.42625 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 1.25e-62 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g10418 | i0 | 94.479 | 8.04294478527607 | 163 | 9 | 100 | 0 | 1 | 163 | 5032 | 5194 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 1311 | 252 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 12559461 | 12559461 | PRJNA399133_P_NODE_10290_length_164_cov_1.697674_g10202_i0 | PRJNA399133 | 10290 | 164 | 1.697674 | 2.78418536 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.41e-75 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g10202 | i0 | 99.379 | 96.6158536585366 | 161 | 1 | 98 | 0 | 1 | 161 | 1410 | 1570 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 15845 | 292 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 15715923 | 15715923 | PRJNA399133_P_NODE_2733_length_302_cov_2.003745_g2645_i0 | PRJNA399133 | 2733 | 302 | 2.003745 | 6.0513099 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.58e-49 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g2645 | i0 | 79.53 | 16.5430463576159 | 298 | 57 | 98 | 4 | 2 | 297 | 127 | 422 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 4996 | 209 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16383316 | 16383316 | PRJNA399133_P_NODE_8253_length_182_cov_3.054422_g8165_i0 | PRJNA399133 | 8253 | 182 | 3.054422 | 5.55904804 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.21e-29 | NTclustered | gi|404425902|gb|JX310031.1| | 655661 | g8165 | i0 | 92.857 | 8.50549450549451 | 98 | 5 | 98 | 1 | 81 | 178 | 2409 | 2314 | Wilbertia typica voucher PXM20100628 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1548 | 141 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Eurystomatellidae | Wilbertia | Wilbertia typica | ||
| 18264830 | 18264830 | PRJNA399133_P_NODE_135_length_1346_cov_3.454615_g107_i0 | PRJNA399133 | 135 | 1346 | 3.454615 | 46.4991179 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 1916 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g107 | i0 | 96.88 | 39.4546805349183 | 1154 | 19 | 86 | 1 | 193 | 1346 | 1238 | 102 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 53106 | 1916 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 18264880 | 18264880 | PRJNA399133_P_NODE_3915_length_255_cov_1.986364_g3827_i0 | PRJNA399133 | 3915 | 255 | 1.986364 | 5.0652282 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.27e-64 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g3827 | i0 | 86.441 | 133.580392156863 | 236 | 32 | 93 | 0 | 20 | 255 | 285 | 50 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 34063 | 259 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 18932334 | 18932334 | PRJNA399133_P_NODE_2755_length_301_cov_1.657895_g2667_i0 | PRJNA399133 | 2755 | 301 | 1.657895 | 4.99026395 | Hymenostomatida | 31277 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.0599999999999996e-145 | NTclustered | gi|1468800191|gb|MH822305.1| | 5927 | g2667 | i0 | 98.339 | 100.019933554817 | 301 | 5 | 100 | 0 | 1 | 301 | 257 | 557 | Dexiostoma campyla strain Tue2015_Dex small subunit ribosomal RNA gene, partial sequence | blastn | 30106 | 529 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Turaniellidae | Dexiostoma | Dexiostoma campyla | ||
| 19539003 | 19539003 | PRJNA399133_P_NODE_116_length_1431_cov_5.164756_g93_i0 | PRJNA399133 | 116 | 1431 | 5.164756 | 73.90765836 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 2410 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g93 | i0 | 97.042 | 1505.19566736548 | 1420 | 35 | 99 | 2 | 1 | 1418 | 1888 | 474 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 2153935 | 2410 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 19539005 | 19539005 | PRJNA399133_P_NODE_11816_length_154_cov_1.344538_g11728_i0 | PRJNA399133 | 11816 | 154 | 1.344538 | 2.07058852 | Chrysolepidomonas dendrolepidota | 64707 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 3.34e-38 | NTclustered | gi|16326553|gb|AF409121.1| | 64707 | g11728 | i0 | 92.5 | 36.2987012987013 | 120 | 8 | 77 | 1 | 36 | 154 | 3831 | 3712 | Chrysolepidomonas dendrolepidota internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 5590 | 171 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chrysolepidomonadaceae | Chrysolepidomonas | Chrysolepidomonas dendrolepidota | |||
| 20814853 | 20814853 | PRJNA399133_P_NODE_3557_length_267_cov_2.099138_g3469_i0 | PRJNA399133 | 3557 | 267 | 2.099138 | 5.60469846 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.31e-132 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g3469 | i0 | 99.251 | 515.786516853933 | 267 | 2 | 100 | 0 | 1 | 267 | 222 | 488 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 137715 | 483 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22089694 | 22089694 | PRJNA399133_P_NODE_2558_length_312_cov_2.509025_g2470_i0 | PRJNA399133 | 2558 | 312 | 2.509025 | 7.828158 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.66e-67 | NTclustered | gi|657012367|gb|KF302531.1| | 2850 | g2470 | i0 | 84.477 | 24.4679487179487 | 277 | 37 | 88 | 6 | 39 | 312 | 16 | 289 | Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds | blastn | 7634 | 268 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 23365347 | 23365347 | PRJNA399133_P_NODE_4679_length_234_cov_2.507538_g4591_i0 | PRJNA399133 | 4679 | 234 | 2.507538 | 5.86763892 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 2.9799999999999993e-115 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4591 | i0 | 99.573 | 88.8589743589744 | 234 | 1 | 100 | 0 | 1 | 234 | 93 | 326 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 20793 | 427 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24639735 | 24639735 | PRJNA399133_P_NODE_8520_length_179_cov_4.118056_g8432_i0 | PRJNA399133 | 8520 | 179 | 4.118056 | 7.37132024 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 1.74e-86 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g8432 | i0 | 100 | 59.4301675977654 | 179 | 0 | 100 | 0 | 1 | 179 | 1651 | 1473 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 10638 | 331 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;