contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax_phylum = "Oomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2514428 | 2514428 | PRJNA879067_P_NODE_27862_length_805_cov_37.857923_g24608_i0 | PRJNA879067 | 27862 | 805 | 37.857923 | 304.75628015 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 3.5799999999999997e-35 | NTclustered | gi|813157874|ref|XM_012346896.1| | 695850 | g24608 | i0 | 77.027 | 2.39254658385093 | 296 | 60 | 36 | 7 | 95 | 386 | 66 | 357 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 1926 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 3790613 | 3790613 | PRJNA879067_P_NODE_100903_length_259_cov_1.430108_g97417_i0 | PRJNA879067 | 100903 | 259 | 1.430108 | 3.70397972 | root | 1 | Root_unresolved | Root_unresolved | 473 | 4.25e-129 | NTclustered | gi|166044485|emb|CU367394.1| | 100861 | g97417 | i0 | 99.614 | 127.610038610039 | 259 | 1 | 100 | 0 | 1 | 259 | 405 | 147 | Aphanomyces euteiches cDNA | blastn | 33051 | 473 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5958313 | 5958313 | PRJNA879067_P_NODE_42825_length_592_cov_3.556840_g39366_i0 | PRJNA879067 | 42825 | 592 | 3.55684 | 21.0564928 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 1.1799999999999999e-48 | NTclustered | gi|325196715|emb|FR827504.1| | 890382 | g39366 | i0 | 96.774 | 0.209459459459459 | 124 | 4 | 21 | 0 | 1 | 124 | 66 | 189 | Albugo laibachii Nc14, genomic contig CONTIG_4671_NC14_v4_189_105 | blastn | 124 | 207 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 10167319 | 10167319 | PRJNA879067_P_NODE_108088_length_245_cov_0.895349_g104602_i0 | PRJNA879067 | 108088 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 442 | 1.1199999999999994e-119 | NTclustered | gi|166046463|emb|CU367580.1| | 100861 | g104602 | i0 | 99.184 | 98.9102040816327 | 245 | 2 | 100 | 0 | 1 | 245 | 346 | 102 | Aphanomyces euteiches cDNA | blastn | 24233 | 442 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11058205 | 11058205 | PRJNA879067_P_NODE_25769_length_850_cov_8.395109_g22567_i0 | PRJNA879067 | 25769 | 850 | 8.395109 | 71.3584265 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 785 | 0 | NTclustered | gi|325193998|emb|FR824926.1| | 890382 | g22567 | i0 | 90.94 | 1.10823529411765 | 585 | 51 | 69 | 2 | 23 | 607 | 2480 | 1898 | Albugo laibachii Nc14, genomic contig CONTIG_1224_NC14_v4_2940_153 | blastn | 942 | 785 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 12335578 | 12335578 | PRJNA879067_P_NODE_95490_length_278_cov_2.800000_g92004_i0 | PRJNA879067 | 95490 | 278 | 2.8 | 7.784 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 7.879999999999999e-112 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g92004 | i0 | 96.813 | 95.0107913669065 | 251 | 5 | 90 | 3 | 1 | 249 | 2250 | 2499 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 26413 | 416 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13607525 | 13607525 | PRJNA879067_P_NODE_109451_length_243_cov_0.905882_g105965_i0 | PRJNA879067 | 109451 | 243 | 0.905882 | 2.20129326 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.4399999999999997e-45 | NTclustered | gi|673016829|ref|XM_008864154.1| | 157072 | g105965 | i0 | 91.489 | 0.580246913580247 | 141 | 12 | 58 | 0 | 103 | 243 | 475 | 335 | Aphanomyces invadans hypothetical protein mRNA | blastn | 141 | 195 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 13609662 | 13609662 | PRJNA879067_P_NODE_76591_length_354_cov_2.615658_g73105_i0 | PRJNA879067 | 76591 | 354 | 2.615658 | 9.25942932 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 1.579999999999999e-169 | NTclustered | gi|1923460157|gb|MW187635.1| | 1982524 | g73105 | i0 | 100 | 93.8813559322034 | 329 | 0 | 93 | 0 | 1 | 329 | 469 | 141 | Aphanomyces sp. isolate CCRJB_30 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 33234 | 608 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 16156456 | 16156456 | PRJNA879067_P_NODE_104573_length_249_cov_1.102273_g101087_i0 | PRJNA879067 | 104573 | 249 | 1.102273 | 2.74465977 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 9.56e-66 | NTclustered | gi|166035705|emb|CU351918.1| | 100861 | g101087 | i0 | 88.636 | 14.3975903614458 | 220 | 20 | 88 | 4 | 1 | 218 | 849 | 633 | Aphanomyces euteiches cDNA | blastn | 3585 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16157227 | 16157227 | PRJNA879067_P_NODE_26713_length_829_cov_25.437831_g23486_i0 | PRJNA879067 | 26713 | 829 | 25.437831 | 210.87961899 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 641 | 3.8899999999999996e-179 | NTclustered | gi|325194852|emb|FR825649.1| | 890382 | g23486 | i0 | 87.257 | 1.6767189384801 | 565 | 69 | 68 | 1 | 1 | 562 | 52 | 616 | Albugo laibachii Nc14, genomic contig CONTIG_2615_NC14_v4_682_163 | blastn | 1390 | 641 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16158208 | 16158208 | PRJNA879067_P_NODE_57793_length_465_cov_1.497449_g54308_i0 | PRJNA879067 | 57793 | 465 | 1.497449 | 6.96313785 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 741 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g54308 | i0 | 97.273 | 101.54623655914 | 440 | 7 | 94 | 3 | 1 | 436 | 6341 | 5903 | Achlya hypogyna mitochondrion, complete genome | blastn | 47219 | 741 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 19090257 | 19090257 | PRJNA879067_P_NODE_107755_length_245_cov_0.895349_g104269_i0 | PRJNA879067 | 107755 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 435 | 1.88e-117 | NTclustered | gi|166044590|emb|CU367499.1| | 100861 | g104269 | i0 | 98.77 | 98.9428571428571 | 244 | 3 | 99 | 0 | 1 | 244 | 219 | 462 | Aphanomyces euteiches cDNA | blastn | 24241 | 435 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19090722 | 19090722 | PRJNA879067_P_NODE_75695_length_358_cov_5.656140_g72209_i0 | PRJNA879067 | 75695 | 358 | 5.65614 | 20.2489812 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.2799999999999996e-145 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g72209 | i0 | 93.333 | 98.2150837988827 | 360 | 21 | 100 | 3 | 1 | 358 | 3115 | 2757 | P.megasperma gene for 28S ribosomal RNA | blastn | 35161 | 534 | 0.99063670411985 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 21258482 | 21258482 | PRJNA879067_P_NODE_92397_length_289_cov_2.606481_g88911_i0 | PRJNA879067 | 92397 | 289 | 2.606481 | 7.53273009 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.2299999999999998e-132 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g88911 | i0 | 100 | 88.8754325259516 | 262 | 0 | 91 | 0 | 1 | 262 | 286 | 25 | Aphanomyces stellatus strain GF 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 | 25685 | 484 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 21641042 | 21641042 | PRJNA879067_P_NODE_32697_length_719_cov_46.196594_g24608_i1 | PRJNA879067 | 32697 | 719 | 46.196594 | 332.15351086 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 3.18e-35 | NTclustered | gi|813157874|ref|XM_012346896.1| | 695850 | g24608 | i1 | 77.027 | 2.67872044506259 | 296 | 60 | 41 | 7 | 334 | 625 | 357 | 66 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 1926 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 23808129 | 23808129 | PRJNA879067_P_NODE_74359_length_365_cov_2.339041_g70874_i0 | PRJNA879067 | 74359 | 365 | 2.339041 | 8.53749965 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.37e-115 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g70874 | i0 | 87.978 | 7.63013698630137 | 366 | 41 | 99 | 3 | 2 | 365 | 42046 | 41682 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 2785 | 429 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23808349 | 23808349 | PRJNA879067_P_NODE_83019_length_326_cov_2.711462_g79533_i0 | PRJNA879067 | 83019 | 326 | 2.711462 | 8.83936612 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 3.4199999999999996e-106 | NTclustered | gi|166048962|emb|CU355871.1| | 100861 | g79533 | i0 | 90.728 | 31.5950920245399 | 302 | 22 | 92 | 4 | 2 | 300 | 842 | 544 | Aphanomyces euteiches cDNA | blastn | 10300 | 398 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25082475 | 25082475 | PRJNA879067_P_NODE_91980_length_291_cov_1.412844_g88494_i0 | PRJNA879067 | 91980 | 291 | 1.412844 | 4.11137604 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 8.359999999999999e-107 | NTclustered | gi|695467766|ref|XM_009541409.1| | 67593 | g88494 | i0 | 92.096 | 87.2096219931271 | 291 | 12 | 100 | 6 | 1 | 291 | 294 | 15 | Phytophthora sojae hypothetical protein mRNA | blastn | 25378 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;