contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 324776 | 324776 | PRJNA1198392_P_NODE_8981_length_287_cov_1.439252_g8840_i0 | PRJNA1198392 | 8981 | 287 | 1.439252 | 4.13065324 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.73e-123 | NTclustered | gi|166039156|emb|CU355206.1| | 100861 | g8840 | i0 | 95.439 | 17.4878048780488 | 285 | 13 | 99 | 0 | 3 | 287 | 457 | 741 | Aphanomyces euteiches cDNA | blastn | 5019 | 455 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 1599306 | 1599306 | PRJNA1198392_P_NODE_2082_length_512_cov_1.753986_g1941_i0 | PRJNA1198392 | 2082 | 512 | 1.753986 | 8.98040832 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 9.62e-84 | NTclustered | gi|669195261|ref|XM_008624420.1| | 54757 | g1941 | i0 | 78.947 | 81.607421875 | 494 | 90 | 95 | 13 | 26 | 512 | 1131 | 645 | Plasmodium vinckei vinckei actin II, putative (PVVCY_1406140), partial mRNA | blastn | 41783 | 324 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 3594243 | 3594243 | PRJNA1198392_P_NODE_2203_length_500_cov_3.480094_g2062_i0 | PRJNA1198392 | 2203 | 500 | 3.480094 | 17.40047 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 924 | 0 | NTclustered | gi|1411267247|gb|MH549414.1| | 88167 | g2062 | i0 | 100 | 49.534 | 500 | 0 | 100 | 0 | 1 | 500 | 97 | 596 | Poterioochromonas malhamensis strain SAG933-1c internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 24767 | 924 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4871866 | 4871866 | PRJNA1198392_P_NODE_5004_length_353_cov_8.185714_g4863_i0 | PRJNA1198392 | 5004 | 353 | 8.185714 | 28.89557042 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|2647530748|gb|PP112999.1| | 88167 | g4863 | i0 | 100 | 100.640226628895 | 353 | 0 | 100 | 0 | 1 | 353 | 1281 | 1633 | Poterioochromonas malhamensis strain NIES2144 small subunit ribosomal RNA gene, partial sequence | blastn | 35526 | 652 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7977782 | 7977782 | PRJNA1198392_P_NODE_10607_length_279_cov_1.966019_g10466_i0 | PRJNA1198392 | 10607 | 279 | 1.966019 | 5.48519301 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.27e-139 | NTclustered | gi|111035915|emb|AJ781092.1| | 35100 | g10466 | i0 | 99.64 | 100.007168458781 | 278 | 1 | 99 | 0 | 2 | 279 | 342 | 65 | Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 | blastn | 27902 | 508 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 7977950 | 7977950 | PRJNA1198392_P_NODE_17747_length_248_cov_0.880000_g17606_i0 | PRJNA1198392 | 17747 | 248 | 0.88 | 2.1824 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.519999999999999e-101 | NTclustered | gi|166039156|emb|CU355206.1| | 100861 | g17606 | i0 | 94.355 | 3.92338709677419 | 248 | 14 | 100 | 0 | 1 | 248 | 182 | 429 | Aphanomyces euteiches cDNA | blastn | 973 | 381 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7978123 | 7978123 | PRJNA1198392_P_NODE_5987_length_330_cov_1.194553_g5846_i0 | PRJNA1198392 | 5987 | 330 | 1.194553 | 3.9420249 | Proschkinia sp. SZCZR1824 | 2588390 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.43e-10 | NTclustered | gi|1681061561|gb|MH800316.1| | 2588390 | g5846 | i0 | 76.433 | 2.10606060606061 | 157 | 31 | 47 | 6 | 57 | 211 | 4566 | 4414 | Proschkinia sp. SZCZR1824 mitochondrion, complete genome | blastn | 695 | 80.5 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Proschkiniaceae | Proschkinia | Proschkinia sp. SZCZR1824 | ||
| 10528491 | 10528491 | PRJNA1198392_P_NODE_3229_length_421_cov_1.221264_g3088_i0 | PRJNA1198392 | 3229 | 421 | 1.221264 | 5.14152144 | Tetrahymena nigricans | 2704176 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 8.989999999999997e-163 | NTclustered | gi|2082965251|gb|MZ827091.1| | 2704176 | g3088 | i0 | 95.187 | 91.4394299287411 | 374 | 12 | 95 | 5 | 26 | 398 | 517 | 885 | Tetrahymena nigricans isolate VB57 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 38496 | 586 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena nigricans | ||
| 10528532 | 10528532 | PRJNA1198392_P_NODE_5349_length_345_cov_1.562500_g5208_i0 | PRJNA1198392 | 5349 | 345 | 1.5625 | 5.390625 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 4.74e-100 | NTclustered | gi|698802575|ref|XM_009836015.1| | 112090 | g5208 | i0 | 86.905 | 11.8 | 336 | 44 | 97 | 0 | 10 | 345 | 621 | 286 | Aphanomyces astaci hypothetical protein mRNA | blastn | 4071 | 377 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13078409 | 13078409 | PRJNA1198392_P_NODE_8351_length_290_cov_1.184332_g8210_i0 | PRJNA1198392 | 8351 | 290 | 1.184332 | 3.4345628 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.9299999999999995e-121 | NTclustered | gi|1270185585|gb|MG266086.1| | 175275 | g8210 | i0 | 94.483 | 100.096551724138 | 290 | 16 | 100 | 0 | 1 | 290 | 616 | 327 | Uncultured Cercozoa clone MossITSLSU68 large subunit ribosomal RNA gene, partial sequence | blastn | 29028 | 448 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 16346329 | 16346329 | PRJNA1198392_P_NODE_3813_length_392_cov_3.043887_g3672_i0 | PRJNA1198392 | 3813 | 392 | 3.043887 | 11.93203704 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 2.48e-113 | NTclustered | gi|16326553|gb|AF409121.1| | 64707 | g3672 | i0 | 90.214 | 57.1275510204082 | 327 | 26 | 82 | 6 | 1 | 323 | 3602 | 3926 | 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 | 22394 | 422 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chrysolepidomonadaceae | Chrysolepidomonas | Chrysolepidomonas dendrolepidota | |||
| 19450645 | 19450645 | PRJNA1198392_P_NODE_18936_length_245_cov_1.366279_g18795_i0 | PRJNA1198392 | 18936 | 245 | 1.366279 | 3.34738355 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.28e-24 | NTclustered | gi|673016233|ref|XM_008863856.1| | 157072 | g18795 | i0 | 79 | 1.63265306122449 | 200 | 30 | 79 | 8 | 44 | 237 | 389 | 196 | Aphanomyces invadans hypothetical protein mRNA | blastn | 400 | 126 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 20725787 | 20725787 | PRJNA1198392_P_NODE_11497_length_275_cov_1.480198_g11356_i0 | PRJNA1198392 | 11497 | 275 | 1.480198 | 4.0705445 | Colpodella angusta | 1541798 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.26e-134 | NTclustered | gi|972268869|gb|KU159286.1| | 1541798 | g11356 | i0 | 98.909 | 3.90181818181818 | 275 | 3 | 100 | 0 | 1 | 275 | 4183 | 4457 | Colpodella angusta 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1073 | 492 | 1 | Eukaryota | Sar | Colpodellaceae | Colpodella | Colpodella angusta | |||||
| 22001478 | 22001478 | PRJNA1198392_P_NODE_6318_length_322_cov_1.851406_g6177_i0 | PRJNA1198392 | 6318 | 322 | 1.851406 | 5.96152732 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 5.219999999999998e-159 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g6177 | i0 | 98.758 | 2.10869565217391 | 322 | 4 | 100 | 0 | 1 | 322 | 1535 | 1214 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 679 | 573 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24550945 | 24550945 | PRJNA1198392_P_NODE_9360_length_285_cov_1.452830_g9219_i0 | PRJNA1198392 | 9360 | 285 | 1.45283 | 4.1405655 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.16e-40 | NTclustered | gi|813141828|ref|XM_012343699.1| | 695850 | g9219 | i0 | 79.545 | 0.926315789473684 | 264 | 44 | 91 | 8 | 15 | 273 | 69 | 327 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 264 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;