contig_metadata
25 rows where bioproject = "PRJNA550047", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 515380 | 515380 | PRJNA550047_P_NODE_358021_length_282_cov_1.885167_g356050_i0 | PRJNA550047 | 358021 | 282 | 1.885167 | 5.31617094 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.91e-38 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g356050 | i0 | 95.37 | 0.382978723404255 | 108 | 5 | 38 | 0 | 175 | 282 | 487 | 380 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 108 | 172 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 1793823 | 1793823 | PRJNA550047_P_NODE_584762_length_202_cov_16.255814_g582789_i0 | PRJNA550047 | 584762 | 202 | 16.255814 | 32.83674428 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.149999999999999e-96 | NTclustered | gi|325194239|emb|FR825095.1| | 890382 | g582789 | i0 | 99.015 | 100.415841584158 | 203 | 1 | 100 | 1 | 1 | 202 | 1376 | 1174 | Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 | blastn | 20284 | 363 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 4343903 | 4343903 | PRJNA550047_P_NODE_470204_length_240_cov_14.035928_g468231_i0 | PRJNA550047 | 470204 | 240 | 14.035928 | 33.6862272 | Peronospora trivialis | 162096 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4199999999999995e-118 | NTclustered | gi|33520205|gb|AY273950.1| | 162096 | g468231 | i0 | 99.583 | 99.7583333333333 | 240 | 1 | 100 | 0 | 1 | 240 | 259 | 20 | Peronospora trivialis large subunit ribosomal RNA gene, partial sequence | blastn | 23942 | 438 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora trivialis | ||
| 5620507 | 5620507 | PRJNA550047_P_NODE_4565_length_867_cov_19.481108_g3073_i0 | PRJNA550047 | 4565 | 867 | 19.481108 | 168.90120636 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 1448 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g3073 | i0 | 96.778 | 1.42099192618224 | 869 | 26 | 100 | 2 | 1 | 867 | 462 | 1330 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 1232 | 1448 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7499854 | 7499854 | PRJNA550047_P_NODE_469266_length_241_cov_3.636905_g467293_i0 | PRJNA550047 | 469266 | 241 | 3.636905 | 8.76494105 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 3.99e-114 | NTclustered | gi|2248513076|ref|NC_063796.1| | 4786 | g467293 | i0 | 98.34 | 102 | 241 | 4 | 100 | 0 | 1 | 241 | 5072 | 5312 | Phytophthora cryptogea culture CBS:418.71 mitochondrion, complete genome | blastn | 24582 | 424 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cryptogea | ||
| 10050063 | 10050063 | PRJNA550047_P_NODE_448568_length_247_cov_14.321839_g446596_i0 | PRJNA550047 | 448568 | 247 | 14.321839 | 35.37494233 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 5.279999999999999e-118 | NTclustered | gi|13309831|gb|AF235955.1|AF235955 | 134698 | g446596 | i0 | 98.381 | 100.04048582996 | 247 | 4 | 100 | 0 | 1 | 247 | 528 | 774 | Peronospora farinosa 28S large subunit ribosomal RNA gene, partial sequence | blastn | 24710 | 440 | 0.990909090909091 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 13268340 | 13268340 | PRJNA550047_P_NODE_27891_length_433_cov_11.027778_g25969_i0 | PRJNA550047 | 27891 | 433 | 11.027778 | 47.75027874 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.88e-25 | NTclustered | gi|325195136|emb|FR825930.1| | 890382 | g25969 | i0 | 84.672 | 0.401847575057737 | 137 | 13 | 38 | 5 | 8 | 136 | 361 | 497 | Albugo laibachii Nc14, genomic contig CONTIG_2990_NC14_v4_499_54 | blastn | 174 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14545190 | 14545190 | PRJNA550047_P_NODE_42392_length_365_cov_24.246575_g40437_i0 | PRJNA550047 | 42392 | 365 | 24.246575 | 88.49999875 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 4.76e-140 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g40437 | i0 | 91.87 | 91.6684931506849 | 369 | 24 | 100 | 5 | 1 | 365 | 110 | 476 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 33459 | 510 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 18369714 | 18369714 | PRJNA550047_P_NODE_571675_length_206_cov_19.609023_g569702_i0 | PRJNA550047 | 571675 | 206 | 19.609023 | 40.39458738 | Perofascia lepidii | 184465 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.0399999999999993e-96 | NTclustered | gi|90655126|gb|DQ361247.1| | 184465 | g569702 | i0 | 98.544 | 101.665048543689 | 206 | 3 | 100 | 0 | 1 | 206 | 283 | 78 | Perofascia lepidii large subunit ribosomal RNA gene, partial sequence | blastn | 20943 | 364 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Perofascia | Perofascia lepidii | ||
| 19640632 | 19640632 | PRJNA550047_P_NODE_272656_length_299_cov_9.504425_g270687_i0 | PRJNA550047 | 272656 | 299 | 9.504425 | 28.41823075 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.55e-62 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g270687 | i0 | 96.689 | 0.969899665551839 | 151 | 5 | 51 | 0 | 1 | 151 | 1380 | 1230 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 290 | 252 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 20246510 | 20246510 | PRJNA550047_P_NODE_13296_length_547_cov_13.352321_g11452_i0 | PRJNA550047 | 13296 | 547 | 13.352321 | 73.03719587 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 854 | 0 | NTclustered | gi|403181303|gb|JN635225.1| | 4788 | g11452 | i0 | 94.891 | 100.184643510055 | 548 | 25 | 99 | 2 | 1 | 545 | 541 | 1088 | Phytophthora megasperma isolate WPC1679A20 18S ribosomal RNA gene, partial sequence | blastn | 54801 | 859 | 0.994179278230501 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 22194603 | 22194603 | PRJNA550047_P_NODE_550598_length_213_cov_13.150000_g548625_i0 | PRJNA550047 | 550598 | 213 | 13.15 | 28.0095 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 8.42e-26 | NTclustered | gi|695423889|ref|XM_009530502.1| | 67593 | g548625 | i0 | 77.725 | 1.88732394366197 | 211 | 47 | 99 | 0 | 1 | 211 | 635 | 845 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 402 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 22195080 | 22195080 | PRJNA550047_P_NODE_591398_length_200_cov_16.708661_g589425_i0 | PRJNA550047 | 591398 | 200 | 16.708661 | 33.417322 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.32e-18 | NTclustered | gi|325195233|emb|FR826028.1| | 890382 | g589425 | i0 | 87.778 | 0.45 | 90 | 11 | 45 | 0 | 111 | 200 | 1 | 90 | Albugo laibachii Nc14, genomic contig CONTIG_3114_NC14_v4_456_30 | blastn | 90 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22797937 | 22797937 | PRJNA550047_P_NODE_273918_length_299_cov_8.504425_g271949_i0 | PRJNA550047 | 273918 | 299 | 8.504425 | 25.42823075 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.5699999999999996e-57 | NTclustered | gi|325181427|emb|FR824061.1| | 890382 | g271949 | i0 | 94.702 | 2 | 151 | 8 | 100 | 0 | 1 | 151 | 114143 | 114293 | Albugo laibachii Nc14, genomic contig CONTIG_16_NC14_v4_210924_216 | blastn | 598 | 235 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 23468202 | 23468202 | PRJNA550047_P_NODE_391459_length_268_cov_9.051282_g389487_i0 | PRJNA550047 | 391459 | 268 | 9.051282 | 24.25743576 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 8.64e-17 | NTclustered | gi|695403836|ref|XM_009525087.1| | 67593 | g389487 | i0 | 89.744 | 2.0410447761194 | 78 | 8 | 29 | 0 | 191 | 268 | 259 | 336 | Phytophthora sojae hypothetical protein mRNA | blastn | 547 | 100 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23470056 | 23470056 | PRJNA550047_P_NODE_541159_length_216_cov_16.629371_g539186_i0 | PRJNA550047 | 541159 | 216 | 16.629371 | 35.91944136 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.74e-67 | NTclustered | gi|325195233|emb|FR826028.1| | 890382 | g539186 | i0 | 91.753 | 0.898148148148148 | 194 | 14 | 89 | 2 | 17 | 209 | 1 | 193 | Albugo laibachii Nc14, genomic contig CONTIG_3114_NC14_v4_456_30 | blastn | 194 | 268 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27773241 | 27773241 | PRJNA550047_P_NODE_476264_length_238_cov_11.460606_g474291_i0 | PRJNA550047 | 476264 | 238 | 11.460606 | 27.27624228 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.26e-4 | NR | CAI5704132.1 | 134698 | g474291 | i0 | 48.9 | 0.592436974789916 | 47 | 24 | 59.2 | 0 | 1 | 141 | 145 | 191 | CAI5704132.1 unnamed protein product [Peronospora farinosa] | diamond | 141 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 28846463 | 28846463 | PRJNA550047_P_NODE_571208_length_207_cov_4.171642_g569235_i0 | PRJNA550047 | 571208 | 207 | 4.171642 | 8.63529894 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.99e-25 | NR | CAH0493560.1 | 134698 | g569235 | i0 | 80.3 | 2.73913043478261 | 61 | 12 | 88.4 | 0 | 2 | 184 | 144 | 204 | CAH0493560.1 unnamed protein product, partial [Peronospora farinosa] | diamond | 567 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 29730423 | 29730423 | PRJNA550047_P_NODE_515850_length_225_cov_9.322368_g513877_i0 | PRJNA550047 | 515850 | 225 | 9.322368 | 20.975328 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.13e-11 | NR | KAF1317267.1 | 82926 | g513877 | i0 | 45.5 | 1.72 | 66 | 36 | 88 | 0 | 202 | 5 | 297 | 362 | KAF1317267.1 Integrase catalytic core protein, partial [Globisporangium splendens] | diamond | 387 | 69.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 30204296 | 30204296 | PRJNA550047_P_NODE_74472_length_345_cov_11.566176_g72512_i0 | PRJNA550047 | 74472 | 345 | 11.566176 | 39.9033072 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 4.19e-20 | NR | CAH0517399.1 | 622444 | g72512 | i0 | 86 | 0.434782608695652 | 50 | 7 | 43.5 | 0 | 2 | 151 | 20 | 69 | CAH0517399.1 unnamed protein product [Peronospora belbahrii] | diamond | 150 | 93.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 30598172 | 30598172 | PRJNA550047_P_NODE_404653_length_263_cov_7.515789_g402681_i0 | PRJNA550047 | 404653 | 263 | 7.515789 | 19.76652507 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0134 | NR | KAG7398242.1 | 109152 | g402681 | i0 | 55.9 | 1.16349809885932 | 34 | 15 | 38.8 | 0 | 249 | 148 | 13 | 46 | KAG7398242.1 putative 28S rRNA (cytosine-C(5))-methyltransferase [Phytophthora boehmeriae] | diamond | 306 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 31419977 | 31419977 | PRJNA550047_P_NODE_494516_length_232_cov_9.163522_g492543_i0 | PRJNA550047 | 494516 | 232 | 9.163522 | 21.25937104 | root | 1 | Root_unresolved | Root_unresolved | 57.4 | 2.24e-7 | NR | KAF0700610.1 | 120398 | g492543 | i0 | 44.8 | 1.61637931034483 | 58 | 31 | 75 | 1 | 175 | 2 | 352 | 408 | KAF0700610.1 hypothetical protein As57867_008842 [Aphanomyces stellatus] | diamond | 375 | 57.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31784584 | 31784584 | PRJNA550047_P_NODE_146017_length_345_cov_4.970588_g144057_i0 | PRJNA550047 | 146017 | 345 | 4.970588 | 17.1485286 | Phytophthora nicotianae P1 | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 1.95e-10 | NR | ETP52203.1 | 1317064 | g144057 | i0 | 63.8 | 0.817391304347826 | 47 | 17 | 40.9 | 0 | 198 | 338 | 131 | 177 | ETP52203.1 hypothetical protein F442_02743 [Phytophthora nicotianae P10297] | diamond | 282 | 67.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 32037880 | 32037880 | PRJNA550047_P_NODE_117358_length_345_cov_6.977941_g115398_i0 | PRJNA550047 | 117358 | 345 | 6.977941 | 24.07389645 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.1e-22 | NR | KAG2915053.1 | 29920 | g115398 | i0 | 49.1 | 0.956521739130435 | 110 | 53 | 95.7 | 1 | 16 | 345 | 151 | 257 | KAG2915053.1 hypothetical protein PC114_g7962 [Phytophthora cactorum] | diamond | 330 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32037995 | 32037995 | PRJNA550047_P_NODE_343778_length_287_cov_14.925234_g341808_i0 | PRJNA550047 | 343778 | 287 | 14.925234 | 42.83542158 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 2.96e-9 | NR | KAF4322330.1 | 1284355 | g341808 | i0 | 66.7 | 2.46689895470383 | 48 | 15 | 49.1 | 1 | 3 | 143 | 364 | 411 | KAF4322330.1 hypothetical protein G195_004463 [Phytophthora kernoviae 00238/432] | diamond | 708 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae |
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);;