contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1287770 | 1287770 | PRJEB10320_P_NODE_13022_length_260_cov_1.893333_g12764_i0 | PRJEB10320 | 13022 | 260 | 1.893333 | 4.9226658 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 7.77e-67 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g12764 | i0 | 87.029 | 84.4038461538462 | 239 | 28 | 91 | 3 | 25 | 260 | 1 | 239 | A.bisexualis gene for actin | blastn | 21945 | 267 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 8940454 | 8940454 | PRJEB10320_P_NODE_10688_length_297_cov_1.061069_g10430_i0 | PRJEB10320 | 10688 | 297 | 1.061069 | 3.15137493 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 5.89e-9 | NTclustered | gi|675176002|ref|XM_008898638.1| | 761204 | g10430 | i0 | 85.135 | 0.461279461279461 | 74 | 9 | 25 | 2 | 55 | 127 | 2855 | 2783 | Phytophthora parasitica INRA-310 hypothetical protein partial mRNA | blastn | 137 | 75 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 11491489 | 11491489 | PRJEB10320_P_NODE_13950_length_248_cov_1.690141_g13692_i0 | PRJEB10320 | 13950 | 248 | 1.690141 | 4.19154968 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.29e-29 | NTclustered | gi|2248513156|ref|NC_063798.1| | 325452 | g13692 | i0 | 79.147 | 13.7620967741935 | 211 | 40 | 84 | 3 | 20 | 228 | 31616 | 31824 | Phytophthora kernoviae isolate 00844/4 mitochondrion, complete genome | blastn | 3413 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 12767068 | 12767068 | PRJEB10320_P_NODE_17471_length_212_cov_1.474576_g17213_i0 | PRJEB10320 | 17471 | 212 | 1.474576 | 3.12610112 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.99e-30 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g17213 | i0 | 82.927 | 4.18396226415094 | 164 | 25 | 76 | 3 | 9 | 170 | 364 | 202 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 887 | 145 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16590389 | 16590389 | PRJEB10320_P_NODE_18134_length_206_cov_2.052632_g17876_i0 | PRJEB10320 | 18134 | 206 | 2.052632 | 4.22842192 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 9.999999999999999e-55 | NTclustered | gi|675199806|ref|XM_008910540.1| | 761204 | g17876 | i0 | 86.408 | 90.9417475728155 | 206 | 28 | 100 | 0 | 1 | 206 | 347 | 552 | Phytophthora parasitica INRA-310 calmodulin mRNA | blastn | 18734 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 20414175 | 20414175 | PRJEB10320_P_NODE_28097_length_152_cov_1.025641_g27839_i0 | PRJEB10320 | 28097 | 152 | 1.025641 | 1.55897432 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 4.22e-42 | NTclustered | gi|189084149|gb|BT031665.1| | 4784 | g27839 | i0 | 88.816 | 55.3355263157895 | 152 | 13 | 99 | 3 | 3 | 152 | 1145 | 1294 | Phytophthora capsici clone CBOT53-I08 mRNA sequence | blastn | 8411 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 21690165 | 21690165 | PRJEB10320_P_NODE_23098_length_173_cov_2.608696_g22840_i0 | PRJEB10320 | 23098 | 173 | 2.608696 | 4.51304408 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.35e-25 | NTclustered | gi|2795024423|ref|XM_067938288.1| | 4785 | g22840 | i0 | 81.25 | 1.88439306358382 | 160 | 28 | 92 | 2 | 13 | 171 | 360 | 202 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13598), partial mRNA | blastn | 326 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24239417 | 24239417 | PRJEB10320_P_NODE_1080_length_982_cov_6.515312_g952_i0 | PRJEB10320 | 1080 | 982 | 6.515312 | 63.98036384 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 621 | 6.0499999999999986e-173 | NTclustered | gi|166044823|emb|CU351082.1| | 100861 | g952 | i0 | 81.242 | 25.561099796334 | 773 | 141 | 79 | 4 | 202 | 972 | 920 | 150 | Aphanomyces euteiches cDNA | blastn | 25101 | 621 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;