contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA550047" 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 |
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);;