contig_metadata
8 rows where bioproject = "PRJNA309466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4204018 | 4204018 | PRJNA309466_P_NODE_2964_length_365_cov_3.370253_g2908_i0 | PRJNA309466 | 2964 | 365 | 3.370253 | 12.30142345 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 651 | 0 | NTclustered | gi|53693101|gb|AY742752.1| | 123356 | g2908 | i0 | 99.718 | 96.7534246575343 | 355 | 1 | 97 | 0 | 9 | 363 | 1003 | 649 | Hyaloperonospora parasitica 18S ribosomal RNA gene, partial sequence | blastn | 35315 | 651 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 11266288 | 11266288 | PRJNA309466_P_NODE_2089_length_472_cov_9.803783_g2034_i0 | PRJNA309466 | 2089 | 472 | 9.803783 | 46.273855759999996 | Pseudoperonospora | 143452 | SAR_Eukaryotes | SAR_Eukaryotes | 848 | 0 | NTclustered | gi|33520221|gb|AY273966.1| | 162119 | g2034 | i0 | 99.359 | 99.1673728813559 | 468 | 3 | 99 | 0 | 5 | 472 | 7 | 474 | Pseudoperonospora urticae large subunit ribosomal RNA gene, partial sequence | blastn | 46807 | 848 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora urticae | ||
| 15090631 | 15090631 | PRJNA309466_P_NODE_12152_length_185_cov_3.000000_g12095_i0 | PRJNA309466 | 12152 | 185 | 3 | 5.55 | Pseudoperonospora | 143452 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 1.81e-86 | NTclustered | gi|927372602|ref|NC_027859.1| | 143453 | g12095 | i0 | 99.451 | 99.2162162162162 | 182 | 1 | 98 | 0 | 4 | 185 | 3267 | 3086 | Pseudoperonospora cubensis mitochondrion, complete genome | blastn | 18355 | 331 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 18228568 | 18228568 | PRJNA309466_P_NODE_6155_length_236_cov_7.647059_g6098_i0 | PRJNA309466 | 6155 | 236 | 7.647059 | 18.04705924 | Pseudoperonospora cubensis | 143453 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 2.33e-116 | NTclustered | gi|53693109|gb|AY742760.1| | 143453 | g6098 | i0 | 99.576 | 100 | 236 | 1 | 100 | 0 | 1 | 236 | 665 | 900 | Pseudoperonospora cubensis 18S ribosomal RNA gene, partial sequence | blastn | 23600 | 431 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 22053355 | 22053355 | PRJNA309466_P_NODE_18338_length_161_cov_6.580357_g18281_i0 | PRJNA309466 | 18338 | 161 | 6.580357 | 10.59437477 | Pseudoperonospora humuli | 162120 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 5.64e-71 | NTclustered | gi|145242870|gb|AY035497.2| | 162120 | g18281 | i0 | 98.125 | 99.3913043478261 | 160 | 3 | 99 | 0 | 2 | 161 | 202 | 43 | Pseudoperonospora humuli isolate HV 129 large subunit ribosomal RNA gene, partial sequence | blastn | 16002 | 279 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora humuli | ||
| 22053381 | 22053381 | PRJNA309466_P_NODE_4578_length_269_cov_2.881818_g4522_i0 | PRJNA309466 | 4578 | 269 | 2.881818 | 7.75209042 | Hyaloperonospora arabidopsidis | 272952 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 9.61e-126 | NTclustered | gi|2248512796|ref|NC_063789.1| | 272952 | g4522 | i0 | 98.842 | 97.2565055762082 | 259 | 3 | 96 | 0 | 5 | 263 | 2025 | 2283 | Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome | blastn | 26162 | 462 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora arabidopsidis | ||
| 30737625 | 30737625 | PRJNA309466_P_NODE_16674_length_166_cov_0.888889_g16617_i0 | PRJNA309466 | 16674 | 166 | 0.888889 | 1.47555574 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 8.13e-18 | NR | KAF4038961.1 | 4787 | g16617 | i0 | 74.1 | 3.90361445783133 | 54 | 14 | 97.6 | 0 | 2 | 163 | 74 | 127 | KAF4038961.1 hypothetical protein GN244_ATG08951 [Phytophthora infestans] | diamond | 648 | 85.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31274912 | 31274912 | PRJNA309466_P_NODE_17595_length_163_cov_1.657895_g17538_i0 | PRJNA309466 | 17595 | 163 | 1.657895 | 2.70236885 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.53e-4 | NR | GMF39275.1 | 1490495 | g17538 | i0 | 71.4 | 2.30061349693252 | 35 | 10 | 64.4 | 0 | 9 | 113 | 192 | 226 | GMF39275.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 375 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia |
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);;