contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA222400" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3607014 | 3607014 | PRJNA222400_P_NODE_1083_length_496_cov_3.872483_g1050_i0 | PRJNA222400 | 1083 | 496 | 3.872483 | 19.20751568 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 4.329999999999999e-82 | NTclustered | gi|2795050181|ref|XM_067944756.1| | 4785 | g1050 | i0 | 88.06 | 52.9233870967742 | 268 | 32 | 54 | 0 | 160 | 427 | 268 | 1 | Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_19694), partial mRNA | blastn | 26250 | 320 | 0.99375 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 4194294 | 4194294 | PRJNA222400_P_NODE_4384_length_212_cov_1.276074_g4351_i0 | PRJNA222400 | 4384 | 212 | 1.276074 | 2.70527688 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.8e-27 | NTclustered | gi|301098809|ref|XM_002898451.1| | 403677 | g4351 | i0 | 81.065 | 0.797169811320755 | 169 | 32 | 80 | 0 | 44 | 212 | 447 | 279 | Phytophthora infestans T30-4 ubiquitin-conjugating enzyme E2, putative (PITG_14594), partial mRNA | blastn | 169 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 5470577 | 5470577 | PRJNA222400_P_NODE_725_length_613_cov_4.416667_g694_i0 | PRJNA222400 | 725 | 613 | 4.416667 | 27.07416871 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 3.22e-89 | NTclustered | gi|695389557|ref|XM_009521174.1| | 67593 | g694 | i0 | 86.495 | 243.003262642741 | 311 | 42 | 51 | 0 | 303 | 613 | 924 | 614 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 148961 | 342 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5470598 | 5470598 | PRJNA222400_P_NODE_8865_length_164_cov_0.895652_g8832_i0 | PRJNA222400 | 8865 | 164 | 0.895652 | 1.46886928 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.27e-5 | NTclustered | gi|675172810|ref|XM_008897042.1| | 761204 | g8832 | i0 | 92.857 | 0.25609756097561 | 42 | 3 | 26 | 0 | 1 | 42 | 1258 | 1299 | Phytophthora parasitica INRA-310 hypothetical protein partial mRNA | blastn | 42 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 6159276 | 6159276 | PRJNA222400_P_NODE_645_length_645_cov_6.976510_g615_i0 | PRJNA222400 | 645 | 645 | 6.97651 | 44.9984895 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 4.33e-98 | NTclustered | gi|813168393|ref|XM_012348507.1| | 695850 | g615 | i0 | 86 | 55.8604651162791 | 350 | 45 | 54 | 4 | 1 | 348 | 996 | 1343 | Saprolegnia parasitica CBS 223.65 tubulin beta chain mRNA | blastn | 36030 | 372 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 8020639 | 8020639 | PRJNA222400_P_NODE_7447_length_168_cov_0.873950_g7414_i0 | PRJNA222400 | 7447 | 168 | 0.87395 | 1.468236 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.35e-32 | NTclustered | gi|813163350|ref|XM_012347346.1| | 695850 | g7414 | i0 | 85.714 | 11.6845238095238 | 147 | 18 | 86 | 3 | 3 | 147 | 657 | 512 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 1963 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 9295290 | 9295290 | PRJNA222400_P_NODE_548_length_691_cov_7.281931_g518_i0 | PRJNA222400 | 548 | 691 | 7.281931 | 50.31814321 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 1.68e-97 | NTclustered | gi|813168393|ref|XM_012348507.1| | 695850 | g518 | i0 | 85.96 | 50.7149059334298 | 349 | 45 | 50 | 4 | 345 | 691 | 1342 | 996 | Saprolegnia parasitica CBS 223.65 tubulin beta chain mRNA | blastn | 35044 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11259730 | 11259730 | PRJNA222400_P_NODE_2709_length_291_cov_2.359504_g2676_i0 | PRJNA222400 | 2709 | 291 | 2.359504 | 6.86615664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 5.71e-14 | NTclustered | gi|1780534029|gb|MK753000.1| | 4799 | g2676 | i0 | 89.041 | 22.4364261168385 | 73 | 8 | 25 | 0 | 219 | 291 | 1321 | 1249 | Pythium torulosum isolate MISO_8-29.1 beta-tubulin mRNA, complete cds | blastn | 6529 | 91.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium torulosum | ||
| 11845792 | 11845792 | PRJNA222400_P_NODE_4890_length_201_cov_1.710526_g4857_i0 | PRJNA222400 | 4890 | 201 | 1.710526 | 3.43815726 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.82e-25 | NTclustered | gi|301121759|ref|XM_002908561.1| | 403677 | g4857 | i0 | 83.099 | 4.85074626865672 | 142 | 22 | 70 | 2 | 60 | 200 | 564 | 424 | Phytophthora infestans T30-4 succinyl-CoA ligase subunit alpha, mitochondrial precursor (PITG_02026), partial mRNA | blastn | 975 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 13809954 | 13809954 | PRJNA222400_P_NODE_8031_length_166_cov_0.982906_g7998_i0 | PRJNA222400 | 8031 | 166 | 0.982906 | 1.63162396 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.18e-45 | NTclustered | gi|813233307|ref|XM_012358054.1| | 695850 | g7998 | i0 | 88.75 | 91.5301204819277 | 160 | 16 | 96 | 2 | 8 | 166 | 243 | 85 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a partial mRNA | blastn | 15194 | 195 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15670017 | 15670017 | PRJNA222400_P_NODE_5193_length_196_cov_1.367347_g5160_i0 | PRJNA222400 | 5193 | 196 | 1.367347 | 2.68000012 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.66e-17 | NTclustered | gi|669138291|ref|XM_008606492.1| | 1156394 | g5160 | i0 | 83.929 | 1.0765306122449 | 112 | 13 | 56 | 5 | 76 | 185 | 1114 | 1222 | Saprolegnia diclina VS20 H/ACA ribonucleoprotein complex subunit 4 mRNA | blastn | 211 | 102 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina |
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);;