contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA631796" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 603340 | 603340 | PRJNA631796_P_NODE_14241_length_176_cov_4.269565_g13963_i0 | PRJNA631796 | 14241 | 176 | 4.269565 | 7.5144344 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 3.85e-53 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g13963 | i0 | 89.714 | 36.4829545454545 | 175 | 14 | 98 | 4 | 4 | 176 | 1665 | 1493 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 6421 | 220 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 1152036 | 1152036 | PRJNA631796_P_NODE_6441_length_270_cov_1.751196_g6163_i0 | PRJNA631796 | 6441 | 270 | 1.751196 | 4.7282292 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 5.7199999999999984e-133 | NTclustered | gi|1233046848|gb|KX252659.1| | 78236 | g6163 | i0 | 99.257 | 99.7148148148148 | 269 | 2 | 99 | 0 | 2 | 270 | 427 | 159 | Phytophthora quercina isolate 30A5(ex-type) 28S ribosomal RNA gene, partial sequence | blastn | 26923 | 486 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora quercina | ||
| 1879576 | 1879576 | PRJNA631796_P_NODE_8702_length_231_cov_3.741176_g8424_i0 | PRJNA631796 | 8702 | 231 | 3.741176 | 8.64211656 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.349999999999998e-112 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g8424 | i0 | 99.134 | 95.3636363636364 | 231 | 2 | 100 | 0 | 1 | 231 | 370 | 140 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 22029 | 416 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 3703704 | 3703704 | PRJNA631796_P_NODE_8643_length_232_cov_1.701754_g8365_i0 | PRJNA631796 | 8643 | 232 | 1.701754 | 3.94806928 | Vitrellaceae | 2605696 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.06e-7 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g8365 | i0 | 93.478 | 13.8663793103448 | 46 | 3 | 20 | 0 | 28 | 73 | 41661 | 41706 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 3217 | 69.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 4431182 | 4431182 | PRJNA631796_S_NODE_6384_length_323_cov_1.332061_g6217_i0 | PRJNA631796 | 6384 | 323 | 1.332061 | 4.30255703 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 1.26e-80 | NTclustered | gi|2248513842|ref|NC_063815.1| | 907947 | g6217 | i0 | 87.636 | 97.7244582043344 | 275 | 26 | 84 | 6 | 52 | 323 | 2539 | 2270 | Phytopythium vexans culture CBS:119.80 mitochondrion, complete genome | blastn | 31565 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 5707044 | 5707044 | PRJNA631796_P_NODE_9465_length_223_cov_2.259259_g9187_i0 | PRJNA631796 | 9465 | 223 | 2.259259 | 5.03814757 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.689999999999999e-104 | NTclustered | gi|1534885766|gb|MH142315.1| | 542832 | g9187 | i0 | 98.206 | 102.004484304933 | 223 | 4 | 100 | 0 | 1 | 223 | 1010 | 788 | Peronospora effusa isolate R13 mitochondrion, complete genome | blastn | 22747 | 390 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 8256554 | 8256554 | PRJNA631796_P_NODE_2487_length_450_cov_3.105398_g2211_i0 | PRJNA631796 | 2487 | 450 | 3.105398 | 13.974291 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 1.39e-86 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g2211 | i0 | 81.166 | 95.1844444444444 | 446 | 57 | 97 | 19 | 14 | 450 | 572 | 999 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 42833 | 333 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 8256635 | 8256635 | PRJNA631796_S_NODE_45547_length_235_cov_1.310345_g45380_i0 | PRJNA631796 | 45547 | 235 | 1.310345 | 3.07931075 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 4.34e-34 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g45380 | i0 | 82.105 | 155.914893617021 | 190 | 29 | 80 | 5 | 49 | 235 | 1419 | 1232 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 36640 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 8805007 | 8805007 | PRJNA631796_S_NODE_1367_length_489_cov_5.455607_g1200_i0 | PRJNA631796 | 1367 | 489 | 5.455607 | 26.67791823 | root | 1 | Root_unresolved | Root_unresolved | 863 | 0 | NTclustered | gi|613433395|gb|KJ410683.1| | 145522 | g1200 | i0 | 98.963 | 171.742331288344 | 482 | 5 | 99 | 0 | 8 | 489 | 65430 | 64949 | Nannochloropsis oceanica strain LAMB0001 chloroplast, partial genome | blastn | 83982 | 863 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis oceanica | |||
| 9531909 | 9531909 | PRJNA631796_P_NODE_5208_length_302_cov_2.697095_g4930_i0 | PRJNA631796 | 5208 | 302 | 2.697095 | 8.1452269 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.37e-149 | NTclustered | gi|1534885766|gb|MH142315.1| | 542832 | g4930 | i0 | 99.007 | 100.629139072848 | 302 | 3 | 100 | 0 | 1 | 302 | 503 | 804 | Peronospora effusa isolate R13 mitochondrion, complete genome | blastn | 30390 | 542 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 10080454 | 10080454 | PRJNA631796_P_NODE_10368_length_214_cov_3.509804_g10090_i0 | PRJNA631796 | 10368 | 214 | 3.509804 | 7.51098056 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.65e-97 | NTclustered | gi|827085599|gb|KM058092.1| | 120572 | g10090 | i0 | 97.664 | 100.355140186916 | 214 | 5 | 100 | 0 | 1 | 214 | 433 | 646 | Peronospora bulbocapni isolate HV7 28S ribosomal RNA gene, partial sequence | blastn | 21476 | 368 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora bulbocapni | ||
| 13905920 | 13905920 | PRJNA631796_P_NODE_11971_length_205_cov_1.340278_g11693_i0 | PRJNA631796 | 11971 | 205 | 1.340278 | 2.7475699 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.58e-92 | NTclustered | gi|1663822452|gb|MH730824.1| | 120412 | g11693 | i0 | 97.561 | 100.00487804878 | 205 | 5 | 100 | 0 | 1 | 205 | 380 | 584 | Peronospora ficariae voucher GLM63033 28S ribosomal RNA gene, partial sequence | blastn | 20501 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora ficariae | ||
| 14632329 | 14632329 | PRJNA631796_P_NODE_4152_length_341_cov_1.364286_g3874_i0 | PRJNA631796 | 4152 | 341 | 1.364286 | 4.65221526 | uncultured stramenopile | 152704 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 1.5199999999999993e-169 | NTclustered | gi|40787136|gb|AY496523.1| | 152704 | g3874 | i0 | 98.827 | 101.533724340176 | 341 | 4 | 100 | 0 | 1 | 341 | 381 | 41 | Uncultured stramenopile clone ND-58 18S ribosomal RNA gene, partial sequence | blastn | 34623 | 608 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 14632358 | 14632358 | PRJNA631796_P_NODE_9172_length_226_cov_3.254545_g8894_i0 | PRJNA631796 | 9172 | 226 | 3.254545 | 7.3552717 | Gertia stigmatica | 2676190 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.44e-23 | NTclustered | gi|1777430530|dbj|LC490696.1| | 2676190 | g8894 | i0 | 87.619 | 45.7964601769912 | 105 | 11 | 46 | 2 | 1 | 104 | 3327 | 3224 | Gertia stigmatica mdd472-kt genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 10350 | 121 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Kareniaceae | Gertia | Gertia stigmatica | |||
| 15906261 | 15906261 | PRJNA631796_P_NODE_9493_length_223_cov_1.432099_g9215_i0 | PRJNA631796 | 9493 | 223 | 1.432099 | 3.19358077 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 7.999999999999999e-101 | NTclustered | gi|695467811|ref|XM_009541420.1| | 67593 | g9215 | i0 | 97.309 | 84.6681614349776 | 223 | 6 | 100 | 0 | 1 | 223 | 16 | 238 | Phytophthora sojae hypothetical protein mRNA | blastn | 18881 | 379 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 16454776 | 16454776 | PRJNA631796_P_NODE_13133_length_201_cov_0.914286_g12855_i0 | PRJNA631796 | 13133 | 201 | 0.914286 | 1.83771486 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.65e-77 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g12855 | i0 | 93.532 | 100.741293532338 | 201 | 13 | 100 | 0 | 1 | 201 | 710 | 510 | 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 | 20249 | 300 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 17729872 | 17729872 | PRJNA631796_P_NODE_11654_length_206_cov_2.558621_g11376_i0 | PRJNA631796 | 11654 | 206 | 2.558621 | 5.27075926 | root | 1 | Root_unresolved | Root_unresolved | 381 | 2.0199999999999994e-101 | NTclustered | gi|363412127|gb|JN120201.1| | 6026 | g11376 | i0 | 100 | 100.004854368932 | 206 | 0 | 100 | 0 | 1 | 206 | 969 | 764 | Opisthonecta henneguyi isolate 43Opisthonectau1S1S2 18S ribosomal RNA gene, partial sequence | blastn | 20601 | 381 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 17729911 | 17729911 | PRJNA631796_P_NODE_5794_length_286_cov_3.657778_g5516_i0 | PRJNA631796 | 5794 | 286 | 3.657778 | 10.46124508 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.02e-135 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g5516 | i0 | 97.902 | 90.3671328671329 | 286 | 6 | 100 | 0 | 1 | 286 | 366 | 651 | 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 | 25845 | 501 | 0.99001996007984 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 19003448 | 19003448 | PRJNA631796_P_NODE_12455_length_203_cov_2.345070_g12177_i0 | PRJNA631796 | 12455 | 203 | 2.34507 | 4.7604921 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.6e-92 | NTclustered | gi|1238821298|ref|NC_035725.1| | 4792 | g12177 | i0 | 98.01 | 99.0197044334975 | 201 | 4 | 99 | 0 | 1 | 201 | 4927 | 5127 | Phytophthora nicotianae mitochondrion, complete genome | blastn | 20101 | 353 | 0.991501416430595 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 19003508 | 19003508 | PRJNA631796_S_NODE_123275_length_202_cov_0.907801_g123108_i0 | PRJNA631796 | 123275 | 202 | 0.907801 | 1.83375802 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 7.25e-86 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g123108 | i0 | 96.059 | 104.445544554455 | 203 | 7 | 100 | 1 | 1 | 202 | 9120 | 9322 | Saprolegnia ferax mitochondrion, complete genome | blastn | 21098 | 331 | 0.993957703927492 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 21005833 | 21005833 | PRJNA631796_P_NODE_9457_length_223_cov_2.703704_g9179_i0 | PRJNA631796 | 9457 | 223 | 2.703704 | 6.02925992 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.09e-50 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g9179 | i0 | 85.577 | 1.13004484304933 | 208 | 23 | 91 | 7 | 1 | 204 | 602 | 806 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 252 | 211 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24829673 | 24829673 | PRJNA631796_P_NODE_4360_length_332_cov_1.634686_g4082_i0 | PRJNA631796 | 4360 | 332 | 1.634686 | 5.42715752 | Chattonella marina | 90936 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.72e-64 | NTclustered | gi|219687517|dbj|AB445435.1| | 859642 | g4082 | i0 | 80.952 | 100.406626506024 | 336 | 56 | 100 | 7 | 1 | 332 | 123 | 454 | Chattonella marina var. antiqua mitochondrial cox1 pseudogene for cytochrome c oxidase subunit 1, strain: DEM-141 | blastn | 33335 | 259 | 1 | Eukaryota | Sar | Raphidophyceae | Chattonellales | Chattonellaceae | Chattonella | Chattonella marina | |||
| 24829737 | 24829737 | PRJNA631796_S_NODE_7280_length_315_cov_4.181102_g7113_i0 | PRJNA631796 | 7280 | 315 | 4.181102 | 13.1704713 | Nothophytophthora sp. | 2853999 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 2.18e-33 | NTclustered | gi|2240249467|gb|MW648547.1| | 2853999 | g7113 | i0 | 84.524 | 11.1460317460317 | 168 | 14 | 53 | 7 | 99 | 264 | 495 | 652 | Nothophytophthora sp. culture ICMP:18719 mitochondrion, complete genome | blastn | 3511 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. |
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);;