contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1233260 | 1233260 | PRJNA849646_P_NODE_27021_length_255_cov_1.692308_g26903_i0 | PRJNA849646 | 27021 | 255 | 1.692308 | 4.3153854 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.28e-12 | NTclustered | gi|2315199850|gb|OP604698.1| | 271679 | g26903 | i0 | 86.842 | 23.3294117647059 | 76 | 10 | 30 | 0 | 1 | 76 | 2430 | 2505 | Polykrikos kofoidii isolate Pk-FC1 large subunit ribosomal RNA gene, partial sequence | blastn | 5949 | 86.1 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Gymnodiniaceae | Polykrikos | Polykrikos kofoidii | |||
| 2113882 | 2113882 | PRJNA849646_P_NODE_8642_length_290_cov_4.041475_g8524_i0 | PRJNA849646 | 8642 | 290 | 4.041475 | 11.7202775 | Phytophthora angustata | 3073753 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.18e-40 | NTclustered | gi|2689410834|gb|OR588318.1| | 3073753 | g8524 | i0 | 78.007 | 8.15862068965517 | 291 | 60 | 99 | 4 | 2 | 290 | 37 | 325 | Phytophthora angustata isolate NI121 60S ribosomal protein L10 (rpl10) gene, partial cds | blastn | 2366 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora angustata | ||
| 5061267 | 5061267 | PRJNA849646_P_NODE_18304_length_271_cov_4.429293_g18186_i0 | PRJNA849646 | 18304 | 271 | 4.429293 | 12.00338403 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 7.540000000000001e-122 | NTclustered | gi|174166|gb|M98367.1|CLPRRLSA | 5980 | g18186 | i0 | 96.31 | 98.8819188191882 | 271 | 9 | 100 | 1 | 1 | 271 | 340 | 71 | Colpoda inflata large subunit ribosomal RNA, 5' end | blastn | 26797 | 451 | 0.995565410199557 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 5941537 | 5941537 | PRJNA849646_P_NODE_36445_length_243_cov_1.811765_g36327_i0 | PRJNA849646 | 36445 | 243 | 1.811765 | 4.40258895 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1e-10 | NTclustered | gi|915141676|ref|XM_013482159.1| | 5804 | g36327 | i0 | 84.81 | 30.5308641975309 | 79 | 12 | 33 | 0 | 1 | 79 | 4782 | 4860 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 7419 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 7216237 | 7216237 | PRJNA849646_P_NODE_1706_length_405_cov_3.385542_g1589_i0 | PRJNA849646 | 1706 | 405 | 3.385542 | 13.7114451 | Spumella sp. HFCC100 | 459029 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.12e-69 | NTclustered | gi|161015703|gb|EF681937.1| | 459029 | g1589 | i0 | 85.556 | 56.8913580246914 | 270 | 31 | 66 | 6 | 1 | 268 | 697 | 434 | Spumella sp. HFCC100 28S ribosomal RNA gene, partial sequence | blastn | 23041 | 276 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. HFCC100 | |||
| 7216436 | 7216436 | PRJNA849646_P_NODE_33386_length_246_cov_4.670520_g33268_i0 | PRJNA849646 | 33386 | 246 | 4.67052 | 11.4894792 | Sterkiella histriomuscorum | 94289 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.04e-92 | NTclustered | gi|220966760|gb|FJ545743.1| | 94289 | g33268 | i0 | 92.276 | 81.5447154471545 | 246 | 19 | 100 | 0 | 1 | 246 | 5687 | 5932 | Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear | blastn | 20060 | 350 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 9766356 | 9766356 | PRJNA849646_P_NODE_35408_length_244_cov_2.304094_g35290_i0 | PRJNA849646 | 35408 | 244 | 2.304094 | 5.62198936 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.699999999999998e-116 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g35290 | i0 | 98.361 | 81.5040983606557 | 244 | 4 | 100 | 0 | 1 | 244 | 3604 | 3361 | Colpoda sp. isolate JGP15 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 | 19887 | 429 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11041734 | 11041734 | PRJNA849646_P_NODE_13389_length_281_cov_1.480769_g13271_i0 | PRJNA849646 | 13389 | 281 | 1.480769 | 4.16096089 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 3.84e-85 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g13271 | i0 | 87.762 | 46.0106761565836 | 286 | 27 | 99 | 6 | 2 | 281 | 1595 | 1878 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 12929 | 327 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13986980 | 13986980 | PRJNA849646_P_NODE_12171_length_283_cov_2.657143_g12053_i0 | PRJNA849646 | 12171 | 283 | 2.657143 | 7.51971469 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.14e-142 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g12053 | i0 | 99.647 | 99.9964664310954 | 283 | 1 | 100 | 0 | 1 | 283 | 940 | 1222 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 28299 | 523 | 0.990439770554493 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 14866236 | 14866236 | PRJNA849646_P_NODE_2972_length_332_cov_3.644788_g2854_i0 | PRJNA849646 | 2972 | 332 | 3.644788 | 12.10069616 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 2.79e-82 | NTclustered | gi|166044589|emb|CU367498.1| | 100861 | g2854 | i0 | 100 | 79.0632530120482 | 172 | 0 | 61 | 0 | 1 | 172 | 177 | 348 | Aphanomyces euteiches cDNA | blastn | 26249 | 318 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16535896 | 16535896 | PRJNA849646_P_NODE_23753_length_261_cov_2.117021_g23635_i0 | PRJNA849646 | 23753 | 261 | 2.117021 | 5.52542481 | root | 1 | Root_unresolved | Root_unresolved | 477 | 3.3099999999999986e-130 | NTclustered | gi|166046482|emb|CU367599.1| | 100861 | g23635 | i0 | 99.617 | 100 | 261 | 1 | 100 | 0 | 1 | 261 | 153 | 413 | Aphanomyces euteiches cDNA | blastn | 26100 | 477 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19964580 | 19964580 | PRJNA849646_P_NODE_19956_length_268_cov_2.800000_g19838_i0 | PRJNA849646 | 19956 | 268 | 2.8 | 7.504 | uncultured alveolate | 175274 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.39e-134 | NTclustered | gi|157688355|gb|EU162620.1| | 175274 | g19838 | i0 | 99.627 | 99.9962686567164 | 268 | 1 | 100 | 0 | 1 | 268 | 23 | 290 | Uncultured alveolate clone PAC10SP2005 18S ribosomal RNA gene, partial sequence | blastn | 26799 | 490 | 1 | Eukaryota | Sar | uncultured alveolate | |||||||
| 19964871 | 19964871 | PRJNA849646_P_NODE_676_length_596_cov_2.879541_g561_i0 | PRJNA849646 | 676 | 596 | 2.879541 | 17.16206436 | Spumella sp. | 1955568 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 2.1399999999999998e-175 | NTclustered | gi|2055919756|gb|MZ420314.1| | 1955568 | g561 | i0 | 86.093 | 101.015100671141 | 604 | 61 | 100 | 19 | 1 | 596 | 1398 | 1986 | Spumella sp. strain Woeam021018A5 large subunit ribosomal RNA gene, partial sequence | blastn | 60205 | 628 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. | |||
| 21240147 | 21240147 | PRJNA849646_P_NODE_16957_length_274_cov_2.039801_g16839_i0 | PRJNA849646 | 16957 | 274 | 2.039801 | 5.58905474 | Cyclotrichium cyclokaryon | 696133 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.97e-92 | NTclustered | gi|375305436|gb|JF975396.1| | 696133 | g16839 | i0 | 93.939 | 55.6277372262774 | 231 | 14 | 84 | 0 | 44 | 274 | 1 | 231 | Cyclotrichium cyclokaryon isolate LWW07111501 28S ribosomal RNA gene, partial sequence | blastn | 15242 | 350 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Didiniidae | Cyclotrichium | Cyclotrichium cyclokaryon | ||
| 22514863 | 22514863 | PRJNA849646_P_NODE_16998_length_274_cov_1.825871_g16880_i0 | PRJNA849646 | 16998 | 274 | 1.825871 | 5.00288654 | Aureococcus anophagefferens | 44056 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|676388378|ref|XM_009039220.1| | 44056 | g16880 | i0 | 94.286 | 0.22992700729927 | 35 | 2 | 13 | 0 | 91 | 125 | 1520 | 1486 | Aureococcus anophagefferens hypothetical protein partial mRNA | blastn | 63 | 54.7 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 23790672 | 23790672 | PRJNA849646_P_NODE_5659_length_310_cov_2.877637_g5541_i0 | PRJNA849646 | 5659 | 310 | 2.877637 | 8.9206747 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.029 | NTclustered | gi|749159684|ref|XM_011133169.1| | 110365 | g5541 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 117 | 144 | 439 | 466 | Gregarina niphandrodes hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 25064438 | 25064438 | PRJNA849646_P_NODE_320_length_939_cov_11.543880_g223_i0 | PRJNA849646 | 320 | 939 | 11.54388 | 108.3970332 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 1005 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g223 | i0 | 95.016 | 7.71884984025559 | 642 | 28 | 82 | 3 | 299 | 939 | 935 | 1573 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 7248 | 1005 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii |
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);;