contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1036688" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169673 | 169673 | PRJNA1036688_P_NODE_8021_length_195_cov_2.443038_g7729_i0 | PRJNA1036688 | 8021 | 195 | 2.443038 | 4.7639241 | Sarcocystis asinus | 2925352 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 4.65e-8 | NTclustered | gi|2206936643|gb|OM971684.1| | 2925352 | g7729 | i0 | 84.507 | 3.92820512820513 | 71 | 11 | 36 | 0 | 53 | 123 | 1686 | 1616 | Sarcocystis asinus isolate YDDSa2 large subunit ribosomal RNA gene, partial sequence | blastn | 766 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis asinus | ||
| 1444339 | 1444339 | PRJNA1036688_P_NODE_6242_length_233_cov_2.219388_g5950_i0 | PRJNA1036688 | 6242 | 233 | 2.219388 | 5.17117404 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.33e-63 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g5950 | i0 | 86.266 | 161.583690987124 | 233 | 32 | 100 | 0 | 1 | 233 | 3 | 235 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 37649 | 254 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 2283328 | 2283328 | PRJNA1036688_P_NODE_4402_length_298_cov_2.938697_g4110_i0 | PRJNA1036688 | 4402 | 298 | 2.938697 | 8.75731706 | Colpodida | 88566 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.35e-149 | NTclustered | gi|156499055|gb|EU039885.1| | 459237 | g4110 | i0 | 99.333 | 100.395973154362 | 300 | 0 | 100 | 2 | 1 | 298 | 51 | 350 | Bresslauides discoideus 18S ribosomal RNA gene, partial sequence; macronuclear | blastn | 29918 | 542 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Hausmanniellidae | Bresslauides | Bresslauides discoideus | ||
| 3996183 | 3996183 | PRJNA1036688_P_NODE_8024_length_195_cov_2.348101_g7732_i0 | PRJNA1036688 | 8024 | 195 | 2.348101 | 4.57879695 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.46e-95 | NTclustered | gi|67090779|gb|DQ007471.1| | 65357 | g7732 | i0 | 100 | 40.174358974359 | 195 | 0 | 100 | 0 | 1 | 195 | 417 | 611 | Albugo candida isolate F20 large subunit ribosomal RNA gene, partial sequence | blastn | 7834 | 361 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 5272480 | 5272480 | PRJNA1036688_P_NODE_11845_length_153_cov_2.344828_g11553_i0 | PRJNA1036688 | 11845 | 153 | 2.344828 | 3.58758684 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.0799999999999995e-72 | NTclustered | gi|338797988|gb|HQ665049.1| | 65357 | g11553 | i0 | 100 | 99.4901960784314 | 153 | 0 | 100 | 0 | 1 | 153 | 1388 | 1236 | Albugo candida isolate AC2V 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15222 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 5272499 | 5272499 | PRJNA1036688_P_NODE_3645_length_338_cov_4.382060_g3354_i0 | PRJNA1036688 | 3645 | 338 | 4.38206 | 14.8113628 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.91e-4 | NTclustered | gi|1931714359|ref|XR_552297.2| | 54757 | g3354 | i0 | 86.792 | 2.5207100591716 | 53 | 7 | 16 | 0 | 171 | 223 | 4102 | 4050 | Plasmodium vinckei vinckei ribosomal RNA (PVVCY_0502190), rRNA | blastn | 852 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 6547678 | 6547678 | PRJNA1036688_P_NODE_10966_length_161_cov_1.072581_g10674_i0 | PRJNA1036688 | 10966 | 161 | 1.072581 | 1.72685541 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 1.59e-61 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g10674 | i0 | 94.41 | 1 | 161 | 9 | 100 | 0 | 1 | 161 | 80247 | 80407 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 161 | 248 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 7822312 | 7822312 | PRJNA1036688_P_NODE_8967_length_182_cov_1.048276_g8675_i0 | PRJNA1036688 | 8967 | 182 | 1.048276 | 1.90786232 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.9e-73 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g8675 | i0 | 95.055 | 3.53846153846154 | 182 | 9 | 100 | 0 | 1 | 182 | 2007 | 2188 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 644 | 287 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 10372931 | 10372931 | PRJNA1036688_P_NODE_8629_length_186_cov_2.322148_g8337_i0 | PRJNA1036688 | 8629 | 186 | 2.322148 | 4.31919528 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.61e-75 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g8337 | i0 | 95.161 | 45.8225806451613 | 186 | 7 | 100 | 2 | 1 | 186 | 3368 | 3551 | Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8523 | 292 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11648193 | 11648193 | PRJNA1036688_P_NODE_6530_length_225_cov_1.909574_g6238_i0 | PRJNA1036688 | 6530 | 225 | 1.909574 | 4.2965415 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.97e-85 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g6238 | i0 | 92.889 | 100.133333333333 | 225 | 16 | 100 | 0 | 1 | 225 | 4923 | 4699 | Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22530 | 327 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 14198254 | 14198254 | PRJNA1036688_P_NODE_4232_length_305_cov_2.104478_g3940_i0 | PRJNA1036688 | 4232 | 305 | 2.104478 | 6.4186579 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 9.33e-67 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g3940 | i0 | 82.736 | 87.8852459016394 | 307 | 45 | 100 | 7 | 1 | 305 | 3587 | 3887 | Cercomonas sp. isolate JGP5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26805 | 267 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 15035754 | 15035754 | PRJNA1036688_P_NODE_10552_length_164_cov_2.425197_g10260_i0 | PRJNA1036688 | 10552 | 164 | 2.425197 | 3.97732308 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|300713466|gb|GQ902928.1| | 152704 | g10260 | i0 | 100 | 33.1829268292683 | 164 | 0 | 100 | 0 | 1 | 164 | 47 | 210 | Uncultured stramenopile clone Ac-C2 28S ribosomal RNA gene, partial sequence | blastn | 5442 | 303 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 15472506 | 15472506 | PRJNA1036688_P_NODE_6953_length_215_cov_2.196629_g6661_i0 | PRJNA1036688 | 6953 | 215 | 2.196629 | 4.72275235 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 9.83e-105 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g6661 | i0 | 99.537 | 67.5116279069767 | 216 | 0 | 100 | 1 | 1 | 215 | 2888 | 2673 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14515 | 392 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16746588 | 16746588 | PRJNA1036688_P_NODE_10054_length_169_cov_2.227273_g9762_i0 | PRJNA1036688 | 10054 | 169 | 2.227273 | 3.76409137 | Acanthoceras zachariasii | 451788 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.31e-15 | NTclustered | gi|1418588907|ref|NC_038009.1| | 451788 | g9762 | i0 | 91.304 | 56 | 69 | 6 | 41 | 0 | 1 | 69 | 71403 | 71471 | Acanthoceras zachariasii chloroplast, complete genome | blastn | 9464 | 95.3 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Acanthocerataceae | Acanthoceras | Acanthoceras zachariasii | ||
| 16746614 | 16746614 | PRJNA1036688_P_NODE_12294_length_150_cov_1.362832_g12002_i0 | PRJNA1036688 | 12294 | 150 | 1.362832 | 2.044248 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.97e-25 | NTclustered | gi|47176397|gb|AY617977.1| | 94289 | g12002 | i0 | 87.5 | 6.81333333333333 | 112 | 12 | 74 | 2 | 32 | 142 | 455 | 345 | Sterkiella histriomuscorum clone UGC1O0006_M16_R genomic sequence | blastn | 1022 | 128 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 18021508 | 18021508 | PRJNA1036688_P_NODE_11455_length_156_cov_2.588235_g11163_i0 | PRJNA1036688 | 11455 | 156 | 2.588235 | 4.0376466 | Tribonema sp. | 2679974 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.21e-47 | NTclustered | gi|2518133535|gb|OQ243223.1| | 2679974 | g11163 | i0 | 93.382 | 3.25 | 136 | 9 | 87 | 0 | 3 | 138 | 6164 | 6029 | Tribonema sp. strain GXU-A10 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and 28S-18S ribosomal RNA intergenic spacer, complete sequence | blastn | 507 | 202 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema sp. | |||
| 18021538 | 18021538 | PRJNA1036688_P_NODE_5315_length_262_cov_2.640000_g5023_i0 | PRJNA1036688 | 5315 | 262 | 2.64 | 6.9168 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 1.99e-132 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g5023 | i0 | 100 | 101.465648854962 | 262 | 0 | 100 | 0 | 1 | 262 | 450 | 711 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 26584 | 484 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 20570867 | 20570867 | PRJNA1036688_P_NODE_9137_length_179_cov_3.352113_g8845_i0 | PRJNA1036688 | 9137 | 179 | 3.352113 | 6.00028227 | Parabistichella variabilis | 1071703 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.91e-84 | NTclustered | gi|751363249|gb|KP266659.1| | 1071703 | g8845 | i0 | 99.438 | 99.195530726257 | 178 | 1 | 99 | 0 | 1 | 178 | 1528 | 1705 | Parabistichella variabilis isolate B102 28S ribosomal RNA gene, partial sequence | blastn | 17756 | 324 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Parabistichella | Parabistichella variabilis | ||||
| 21846639 | 21846639 | PRJNA1036688_P_NODE_9638_length_174_cov_1.386861_g9346_i0 | PRJNA1036688 | 9638 | 174 | 1.386861 | 2.41313814 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 4.7e-82 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g9346 | i0 | 99.425 | 100 | 174 | 1 | 100 | 0 | 1 | 174 | 699 | 872 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 17400 | 316 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 23960414 | 23960414 | PRJNA1036688_P_NODE_10959_length_161_cov_1.217742_g10667_i0 | PRJNA1036688 | 10959 | 161 | 1.217742 | 1.96056462 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.56e-76 | NTclustered | gi|88660256|gb|DQ388543.1| | 373003 | g10667 | i0 | 100 | 98.888198757764 | 161 | 0 | 100 | 0 | 1 | 161 | 691 | 531 | Spumella-like flagellate 8b3 18S ribosomal RNA gene, partial sequence | blastn | 15921 | 298 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella-like flagellate 8b3 |
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);;