contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4103752 | 4103752 | PRJNA1120771_S_NODE_37164_length_200_cov_2.216561_g36764_i0 | PRJNA1120771 | 37164 | 200 | 2.216561 | 4.433122 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|695451661|ref|XM_009537490.1| | 67593 | g36764 | i0 | 100 | 0.145 | 29 | 0 | 15 | 0 | 7 | 35 | 338 | 310 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 4856590 | 4856590 | PRJNA1120771_S_NODE_9004_length_348_cov_13.495082_g8604_i0 | PRJNA1120771 | 9004 | 348 | 13.495082 | 46.96288536 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.2499999999999996e-145 | NTclustered | gi|2248513076|ref|NC_063796.1| | 4786 | g8604 | i0 | 96.296 | 92.8620689655172 | 324 | 9 | 93 | 3 | 1 | 323 | 334 | 13 | Phytophthora cryptogea culture CBS:418.71 mitochondrion, complete genome | blastn | 32316 | 529 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cryptogea | ||
| 6131419 | 6131419 | PRJNA1120771_S_NODE_22385_length_250_cov_2.545894_g21985_i0 | PRJNA1120771 | 22385 | 250 | 2.545894 | 6.364735 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 4.1399999999999976e-119 | NTclustered | gi|2248512916|ref|NC_063792.1| | 100870 | g21985 | i0 | 98.4 | 100.008 | 250 | 4 | 100 | 0 | 1 | 250 | 631 | 880 | Phytophthora litchii isolate SHS3 mitochondrion, complete genome | blastn | 25002 | 440 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora litchii | ||
| 8681723 | 8681723 | PRJNA1120771_S_NODE_12687_length_309_cov_2.090226_g12287_i0 | PRJNA1120771 | 12687 | 309 | 2.090226 | 6.45879834 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 7.91e-13 | NTclustered | gi|695450043|ref|XM_009537087.1| | 67593 | g12287 | i0 | 100 | 16.6763754045307 | 47 | 0 | 15 | 0 | 10 | 56 | 1683 | 1729 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 5153 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 9204662 | 9204662 | PRJNA1120771_S_NODE_35428_length_206_cov_2.920245_g35028_i0 | PRJNA1120771 | 35428 | 206 | 2.920245 | 6.0157047 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.8e-33 | NTclustered | gi|673039918|ref|XM_008875698.1| | 157072 | g35028 | i0 | 81.967 | 20.7864077669903 | 183 | 31 | 88 | 2 | 2 | 183 | 450 | 269 | Aphanomyces invadans hypothetical protein mRNA | blastn | 4282 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10480358 | 10480358 | PRJNA1120771_S_NODE_8369_length_358_cov_2.079365_g7969_i0 | PRJNA1120771 | 8369 | 358 | 2.079365 | 7.4441267 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.86e-64 | NTclustered | gi|675211346|ref|XM_008916310.1| | 761204 | g7969 | i0 | 86.307 | 66.8938547486033 | 241 | 30 | 67 | 3 | 120 | 358 | 414 | 175 | Phytophthora parasitica INRA-310 60S ribosomal protein L44 mRNA | blastn | 23948 | 259 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 15056213 | 15056213 | PRJNA1120771_S_NODE_13672_length_300_cov_4.914397_g13272_i0 | PRJNA1120771 | 13672 | 300 | 4.914397 | 14.743191 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 1.07e-140 | NTclustered | gi|827085599|gb|KM058092.1| | 120572 | g13272 | i0 | 98.288 | 97.24 | 292 | 5 | 97 | 0 | 1 | 292 | 18 | 309 | Peronospora bulbocapni isolate HV7 28S ribosomal RNA gene, partial sequence | blastn | 29172 | 512 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora bulbocapni | ||
| 19402459 | 19402459 | PRJNA1120771_S_NODE_23036_length_247_cov_3.764706_g22636_i0 | PRJNA1120771 | 23036 | 247 | 3.764706 | 9.29882382 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 2.11e-42 | NTclustered | gi|2795040529|ref|XM_067944818.1| | 4785 | g22636 | i0 | 84.021 | 40.3522267206478 | 194 | 29 | 78 | 2 | 50 | 242 | 203 | 395 | Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA | blastn | 9967 | 185 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 20678206 | 20678206 | PRJNA1120771_S_NODE_9417_length_343_cov_1.693333_g9017_i0 | PRJNA1120771 | 9417 | 343 | 1.693333 | 5.80813219 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 6.59e-44 | NTclustered | gi|2795032738|ref|XM_067933181.1| | 4785 | g9017 | i0 | 83.495 | 73.7842565597668 | 206 | 32 | 60 | 2 | 112 | 316 | 987 | 783 | Phytophthora cinnamomi Electron transfer flavoprotein subunit alpha, mitochondrial precursor (IUM83_08787), partial mRNA | blastn | 25308 | 191 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21953513 | 21953513 | PRJNA1120771_S_NODE_5138_length_426_cov_5.062663_g4738_i0 | PRJNA1120771 | 5138 | 426 | 5.062663 | 21.56694438 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 8.520000000000001e-29 | NTclustered | gi|673044940|ref|XM_008878209.1| | 157072 | g4738 | i0 | 86.719 | 4.97887323943662 | 128 | 15 | 30 | 2 | 200 | 326 | 1063 | 937 | Aphanomyces invadans hypothetical protein mRNA | blastn | 2121 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 24502482 | 24502482 | PRJNA1120771_S_NODE_14120_length_297_cov_1.452756_g13720_i0 | PRJNA1120771 | 14120 | 297 | 1.452756 | 4.31468532 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 4.24e-60 | NTclustered | gi|695396854|ref|XM_009523296.1| | 67593 | g13720 | i0 | 81.667 | 23.1346801346801 | 300 | 49 | 100 | 6 | 1 | 297 | 323 | 619 | Phytophthora sojae putative GTP-binding ADP-ribosylation factor mRNA | blastn | 6871 | 244 | 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);;