contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4608482 | 4608482 | PRJNA795983_S_NODE_27504_length_276_cov_1.354680_g27379_i0 | PRJNA795983 | 27504 | 276 | 1.35468 | 3.7389168 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 4.98e-69 | NTclustered | gi|675168842|ref|XM_008895058.1| | 761204 | g27379 | i0 | 85.496 | 21.8115942028986 | 262 | 38 | 95 | 0 | 1 | 262 | 270 | 531 | Phytophthora parasitica INRA-310 guanine nucleotide-binding protein subunit beta-like protein mRNA | blastn | 6020 | 274 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 6320509 | 6320509 | PRJNA795983_S_NODE_16425_length_328_cov_1.082353_g16300_i0 | PRJNA795983 | 16425 | 328 | 1.082353 | 3.55011784 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.73e-49 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g16300 | i0 | 79.861 | 58.5213414634146 | 288 | 56 | 88 | 2 | 2 | 288 | 1021 | 1307 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 19195 | 211 | 0.990521327014218 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 8433067 | 8433067 | PRJNA795983_S_NODE_15567_length_333_cov_2.123077_g15442_i0 | PRJNA795983 | 15567 | 333 | 2.123077 | 7.06984641 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.2899999999999998e-43 | NTclustered | gi|673025997|ref|XM_008868738.1| | 157072 | g15442 | i0 | 80.156 | 34.8228228228228 | 257 | 47 | 77 | 2 | 6 | 260 | 456 | 202 | Aphanomyces invadans 40S ribosomal protein S20 mRNA | blastn | 11596 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 12259749 | 12259749 | PRJNA795983_S_NODE_42930_length_241_cov_0.916667_g42805_i0 | PRJNA795983 | 42930 | 241 | 0.916667 | 2.20916747 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2099999999999997e-54 | NTclustered | gi|669139111|ref|XM_008606902.1| | 1156394 | g42805 | i0 | 84.188 | 43.298755186722 | 234 | 35 | 97 | 2 | 9 | 241 | 847 | 615 | Saprolegnia diclina VS20 ATP-dependent RNA helicase eIF4A mRNA | blastn | 10435 | 226 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 12259830 | 12259830 | PRJNA795983_S_NODE_9650_length_393_cov_2.243750_g9525_i0 | PRJNA795983 | 9650 | 393 | 2.24375 | 8.8179375 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 1.6000000000000004e-65 | NTclustered | gi|673042664|ref|XM_008877071.1| | 157072 | g9525 | i0 | 82.45 | 40.8320610687023 | 302 | 51 | 77 | 2 | 93 | 393 | 492 | 192 | Aphanomyces invadans ubiquitin-40S ribosomal protein S27a mRNA | blastn | 16047 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 13533814 | 13533814 | PRJNA795983_S_NODE_35851_length_251_cov_1.151685_g35726_i0 | PRJNA795983 | 35851 | 251 | 1.151685 | 2.89072935 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|187468407|emb|CU855855.1| | 123356 | g35726 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 115 | 142 | 107949 | 107976 | H.parasitica DNA sequence from clone HpEmoy2-17E12, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 16082648 | 16082648 | PRJNA795983_S_NODE_31493_length_263_cov_1.484211_g31368_i0 | PRJNA795983 | 31493 | 263 | 1.484211 | 3.90347493 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 6.309999999999998e-43 | NTclustered | gi|59894157|gb|AY729861.1| | 100863 | g31368 | i0 | 80.478 | 5.71102661596958 | 251 | 43 | 94 | 4 | 1 | 248 | 1001 | 754 | Plectospira myriandra heat shock protein 90 gene, partial cds | blastn | 1502 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 16519378 | 16519378 | PRJNA795983_S_NODE_14093_length_344_cov_2.601476_g13968_i0 | PRJNA795983 | 14093 | 344 | 2.601476 | 8.94907744 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 5.15e-40 | NTclustered | gi|813142340|ref|XM_012343869.1| | 695850 | g13968 | i0 | 77.558 | 20.8401162790698 | 303 | 63 | 88 | 4 | 39 | 340 | 310 | 608 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S6 mRNA | blastn | 7169 | 178 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;