contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1409843 | 1409843 | PRJEB7366_P_NODE_22202_length_160_cov_1.280000_g21768_i0 | PRJEB7366 | 22202 | 160 | 1.28 | 2.048 | Phytopythium sindhum | 795340 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 2.19e-10 | NTclustered | gi|440919558|gb|JX436356.1| | 795340 | g21768 | i0 | 94.118 | 1.48125 | 51 | 3 | 32 | 0 | 91 | 141 | 438 | 388 | Phytopythium sindhum axoneme central apparatus PF16 gene, partial cds | blastn | 237 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium sindhum | ||
| 6513348 | 6513348 | PRJEB7366_P_NODE_1866_length_718_cov_12.525622_g1527_i0 | PRJEB7366 | 1866 | 718 | 12.525622 | 89.93396596 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.02 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g1527 | i0 | 100 | 0.0403899721448468 | 29 | 0 | 4 | 0 | 683 | 711 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 6513391 | 6513391 | PRJEB7366_P_NODE_6406_length_348_cov_10.821086_g5972_i0 | PRJEB7366 | 6406 | 348 | 10.821086 | 37.65737928 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g5972 | i0 | 100 | 0.0833333333333333 | 29 | 0 | 8 | 0 | 313 | 341 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 7787644 | 7787644 | PRJEB7366_P_NODE_3187_length_531_cov_9.336694_g2780_i0 | PRJEB7366 | 3187 | 531 | 9.336694 | 49.57784514 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 1.34e-57 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g2780 | i0 | 91.329 | 32.7815442561205 | 173 | 15 | 33 | 0 | 1 | 173 | 182 | 354 | Phytophthora sojae hypothetical protein mRNA | blastn | 17407 | 237 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10338304 | 10338304 | PRJEB7366_P_NODE_22809_length_157_cov_2.295082_g22375_i0 | PRJEB7366 | 22809 | 157 | 2.295082 | 3.60327874 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|813155594|ref|XM_012346002.1| | 695850 | g22375 | i0 | 100 | 0.178343949044586 | 28 | 0 | 18 | 0 | 95 | 122 | 194 | 167 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10338314 | 10338314 | PRJEB7366_P_NODE_2549_length_605_cov_9.538596_g2160_i0 | PRJEB7366 | 2549 | 605 | 9.538596 | 57.7085058 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g2160 | i0 | 100 | 0.0479338842975207 | 29 | 0 | 5 | 0 | 154 | 182 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 23948033 | 23948033 | PRJEB7366_P_NODE_11719_length_237_cov_1.747525_g11285_i0 | PRJEB7366 | 11719 | 237 | 1.747525 | 4.14163425 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.21e-39 | NTclustered | gi|2794916836|ref|XM_067893665.1| | 164328 | g11285 | i0 | 84.153 | 5.60337552742616 | 183 | 27 | 77 | 2 | 56 | 237 | 413 | 232 | Phytophthora ramorum Elongator complex protein 3 (KRP23_8248), partial mRNA | blastn | 1328 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum |
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);;