contig_metadata
11 rows where bioproject = "PRJNA326068", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940049 | 2940049 | PRJNA326068_P_NODE_16643_length_202_cov_5.075145_g15680_i0 | PRJNA326068 | 16643 | 202 | 5.075145 | 10.2517929 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.54e-97 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g15680 | i0 | 99.507 | 100.272277227723 | 203 | 0 | 100 | 1 | 1 | 202 | 1864 | 1662 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 20255 | 368 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 4216707 | 4216707 | PRJNA326068_P_NODE_13224_length_247_cov_8.715596_g12261_i0 | PRJNA326068 | 13224 | 247 | 8.715596 | 21.52752212 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.2e-79 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g12261 | i0 | 89.754 | 71.825910931174107 | 244 | 21 | 98 | 4 | 6 | 247 | 1447 | 1688 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 17741 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10593130 | 10593130 | PRJNA326068_P_NODE_19409_length_159_cov_1.292308_g18446_i0 | PRJNA326068 | 19409 | 159 | 1.292308 | 2.05476972 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.67e-44 | NTclustered | gi|673029967|ref|XM_008870723.1| | 157072 | g18446 | i0 | 88.535 | 2.9622641509434 | 157 | 18 | 99 | 0 | 3 | 159 | 891 | 735 | Aphanomyces invadans ribosomal protein S2 mRNA | blastn | 471 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10593161 | 10593161 | PRJNA326068_P_NODE_8629_length_352_cov_94.439628_g7679_i0 | PRJNA326068 | 8629 | 352 | 94.439628 | 332.42749056 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 3.53e-141 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g7679 | i0 | 92.997 | 101.568181818182 | 357 | 17 | 99 | 6 | 2 | 352 | 929 | 575 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 35752 | 514 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 14418295 | 14418295 | PRJNA326068_P_NODE_6812_length_413_cov_16.408854_g5891_i0 | PRJNA326068 | 6812 | 413 | 16.408854 | 67.76856702 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 763 | 0 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g5891 | i0 | 100 | 99.9370460048426 | 413 | 0 | 100 | 0 | 1 | 413 | 163 | 575 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 41274 | 763 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 16966778 | 16966778 | PRJNA326068_P_NODE_17454_length_191_cov_2.055556_g16491_i0 | PRJNA326068 | 17454 | 191 | 2.055556 | 3.92611196 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.67e-20 | NTclustered | gi|59859759|gb|AY729874.1| | 100863 | g16491 | i0 | 79.87 | 34.2879581151832 | 154 | 29 | 80 | 2 | 34 | 186 | 264 | 112 | Plectospira myriandra elongation factor 1 alpha gene, partial cds | blastn | 6549 | 111 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 16966798 | 16966798 | PRJNA326068_P_NODE_4394_length_527_cov_5.204819_g3615_i0 | PRJNA326068 | 4394 | 527 | 5.204819 | 27.42939613 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.06e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g3615 | i0 | 80.533 | 64.1897533206831 | 375 | 65 | 70 | 4 | 31 | 398 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18241055 | 18241055 | PRJNA326068_P_NODE_17135_length_196_cov_5.413174_g16172_i0 | PRJNA326068 | 17135 | 196 | 5.413174 | 10.60982104 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.99e-86 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g16172 | i0 | 96.552 | 103.974489795918 | 203 | 0 | 100 | 1 | 1 | 196 | 63 | 265 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20379 | 329 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 23341316 | 23341316 | PRJNA326068_P_NODE_11679_length_278_cov_2.357430_g10717_i0 | PRJNA326068 | 11679 | 278 | 2.35743 | 6.5536554 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 6.449999999999999e-45 | NR | OQS04692.1 | 74557 | g10717 | i0 | 84.8 | 5.9568345323741 | 92 | 14 | 99.3 | 0 | 3 | 278 | 10 | 101 | OQS04692.1 aspartyl/Asparaginyl beta-hydroxylase [Thraustotheca clavata] | diamond | 1656 | 159 | 0.993710691823899 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 27011230 | 27011230 | PRJNA326068_P_NODE_20002_length_151_cov_2.950820_g19039_i0 | PRJNA326068 | 20002 | 151 | 2.95082 | 4.4557382 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00209 | NR | TYZ63537.1 | 1485010 | g19039 | i0 | 47.4 | 0.754966887417219 | 38 | 20 | 75.5 | 0 | 24 | 137 | 233 | 270 | TYZ63537.1 hypothetical protein PybrP1_010177 [[Pythium] brassicae (nom. inval.)] | diamond | 114 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30881726 | 30881726 | PRJNA326068_P_NODE_5114_length_488_cov_3.342048_g4296_i0 | PRJNA326068 | 5114 | 488 | 3.342048 | 16.30919424 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 5.939999999999999e-43 | NR | XP_024573476.1 | 4781 | g4296 | i0 | 64.7 | 8.40368852459016 | 116 | 41 | 71.3 | 0 | 472 | 125 | 533 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 4101 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii |
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);;