contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2970352 | 2970352 | PRJNA416866_P_NODE_3723_length_344_cov_2.148410_g3580_i0 | PRJNA416866 | 3723 | 344 | 2.14841 | 7.3905304 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.85e-39 | NTclustered | gi|675166828|ref|XM_008894051.1| | 761204 | g3580 | i0 | 83.333 | 9.26453488372093 | 192 | 30 | 56 | 2 | 1 | 191 | 1002 | 812 | Phytophthora parasitica INRA-310 V-type H(+)-translocating pyrophosphatase mRNA | blastn | 3187 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 4246692 | 4246692 | PRJNA416866_P_NODE_1484_length_572_cov_31.056751_g1345_i0 | PRJNA416866 | 1484 | 572 | 31.056751 | 177.64461572 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 3.12e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g1345 | i0 | 79.05 | 13.8548951048951 | 358 | 71 | 62 | 4 | 113 | 468 | 482 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 4246711 | 4246711 | PRJNA416866_P_NODE_4524_length_309_cov_6.302419_g4380_i0 | PRJNA416866 | 4524 | 309 | 6.302419 | 19.47447471 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 3.43e-61 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g4380 | i0 | 87.156 | 68.8608414239482 | 218 | 28 | 71 | 0 | 90 | 307 | 1 | 218 | A.bisexualis gene for actin | blastn | 21278 | 248 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 13837221 | 13837221 | PRJNA416866_P_NODE_1751_length_522_cov_2.208243_g1609_i0 | PRJNA416866 | 1751 | 522 | 2.208243 | 11.52702846 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 3.2899999999999996e-133 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g1609 | i0 | 86.057 | 85.1111111111111 | 459 | 59 | 88 | 4 | 13 | 469 | 483 | 28 | Pythium splendens calmodulin mRNA, complete cds | blastn | 44428 | 492 | 0.991869918699187 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 19545463 | 19545463 | PRJNA416866_P_NODE_1416_length_590_cov_28.098299_g1277_i0 | PRJNA416866 | 1416 | 590 | 28.098299 | 165.7799641 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.83e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g1277 | i0 | 80.533 | 57.335593220339 | 375 | 65 | 62 | 4 | 199 | 566 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21485455 | 21485455 | PRJNA416866_P_NODE_11217_length_203_cov_0.901408_g11073_i0 | PRJNA416866 | 11217 | 203 | 0.901408 | 1.82985824 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 7.51e-66 | NTclustered | gi|299764602|gb|GQ919079.1| | 281402 | g11073 | i0 | 90.196 | 96.871921182266 | 204 | 17 | 100 | 3 | 1 | 203 | 652 | 853 | Saprolegnia australis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19665 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia australis | ||
| 22096086 | 22096086 | PRJNA416866_P_NODE_2558_length_427_cov_1.734973_g2415_i0 | PRJNA416866 | 2558 | 427 | 1.734973 | 7.40833471 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 1.64e-110 | NTclustered | gi|695434207|ref|XM_009533074.1| | 67593 | g2415 | i0 | 85.642 | 55.5081967213115 | 397 | 51 | 92 | 6 | 2 | 395 | 394 | 1 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 23702 | 412 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;