contig_metadata
11 rows where bioproject = "PRJNA900028", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 875418 | 875418 | PRJNA900028_P_NODE_28521_length_243_cov_1.561856_g27772_i0 | PRJNA900028 | 28521 | 243 | 1.561856 | 3.79531008 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.25e-39 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g27772 | i0 | 90.441 | 0.860082304526749 | 136 | 10 | 55 | 3 | 1 | 134 | 596 | 730 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 209 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 8528738 | 8528738 | PRJNA900028_P_NODE_73587_length_188_cov_1.100719_g72838_i0 | PRJNA900028 | 73587 | 188 | 1.100719 | 2.06935172 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.01e-26 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g72838 | i0 | 87.069 | 36.4574468085106 | 116 | 15 | 62 | 0 | 65 | 180 | 15406 | 15291 | Achlya hypogyna mitochondrion, complete genome | blastn | 6854 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 10173681 | 10173681 | PRJNA900028_P_NODE_24968_length_253_cov_1.406863_g24219_i0 | PRJNA900028 | 24968 | 253 | 1.406863 | 3.55936339 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g24219 | i0 | 100 | 97.1581027667984 | 253 | 0 | 100 | 0 | 1 | 253 | 598 | 346 | 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 | 24581 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 11078878 | 11078878 | PRJNA900028_P_NODE_2929_length_638_cov_1.660441_g2228_i0 | PRJNA900028 | 2929 | 638 | 1.660441 | 10.59361358 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 935 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g2228 | i0 | 94.702 | 1.61912225705329 | 604 | 28 | 95 | 3 | 1 | 604 | 1534 | 935 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 1033 | 935 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 17453019 | 17453019 | PRJNA900028_P_NODE_153954_length_164_cov_1.286957_g153205_i0 | PRJNA900028 | 153954 | 164 | 1.286957 | 2.11060948 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.45e-73 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g153205 | i0 | 98.171 | 74.3536585365854 | 164 | 3 | 100 | 0 | 1 | 164 | 2283 | 2120 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 12194 | 287 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20002849 | 20002849 | PRJNA900028_P_NODE_99456_length_176_cov_1.251969_g98707_i0 | PRJNA900028 | 99456 | 176 | 1.251969 | 2.20346544 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.04e-75 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g98707 | i0 | 96.591 | 99.8295454545455 | 176 | 6 | 100 | 0 | 1 | 176 | 327 | 502 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 17570 | 292 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 21277693 | 21277693 | PRJNA900028_P_NODE_57597_length_199_cov_2.040000_g56848_i0 | PRJNA900028 | 57597 | 199 | 2.04 | 4.0596 | Peronospora rumicis | 162101 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.019999999999998e-96 | NTclustered | gi|33520206|gb|AY273951.1| | 162101 | g56848 | i0 | 99.497 | 99.9447236180904 | 199 | 1 | 100 | 0 | 1 | 199 | 551 | 749 | Peronospora rumicis large subunit ribosomal RNA gene, partial sequence | blastn | 19889 | 363 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora rumicis | ||
| 28097976 | 28097976 | PRJNA900028_P_NODE_139585_length_166_cov_0.871795_g138836_i0 | PRJNA900028 | 139585 | 166 | 0.871795 | 1.4471797 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 7.76e-7 | NR | OWZ10206.1 | 4795 | g138836 | i0 | 51 | 0.885542168674699 | 49 | 24 | 88.6 | 0 | 149 | 3 | 490 | 538 | OWZ10206.1 Intraflagellar Transport Protein 140 [Phytophthora megakarya] | diamond | 147 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 29518857 | 29518857 | PRJNA900028_P_NODE_73130_length_188_cov_1.251799_g72381_i0 | PRJNA900028 | 73130 | 188 | 1.251799 | 2.35338212 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0468 | NR | KAJ8564287.1 | 4785 | g72381 | i0 | 46.7 | 0.718085106382979 | 45 | 18 | 71.8 | 1 | 29 | 163 | 173 | 211 | KAJ8564287.1 hypothetical protein ON010_g7058 [Phytophthora cinnamomi] | diamond | 135 | 41.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29960965 | 29960965 | PRJNA900028_P_NODE_175631_length_162_cov_1.805310_g174882_i0 | PRJNA900028 | 175631 | 162 | 1.80531 | 2.9246022 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 1.01e-6 | NR | KAH9088249.1 | 100861 | g174882 | i0 | 56.6 | 0.981481481481482 | 53 | 22 | 96.3 | 1 | 161 | 6 | 395 | 447 | KAH9088249.1 hypothetical protein LEN26_019599 [Aphanomyces euteiches] | diamond | 159 | 54.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30940625 | 30940625 | PRJNA900028_P_NODE_153294_length_164_cov_1.330435_g152545_i0 | PRJNA900028 | 153294 | 164 | 1.330435 | 2.1819134 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 40.8 | 0.0274 | NR | KAE9158665.1 | 53985 | g152545 | i0 | 42.2 | 0.823170731707317 | 45 | 26 | 82.3 | 0 | 147 | 13 | 24 | 68 | KAE9158665.1 hypothetical protein PF005_g32355 [Phytophthora fragariae] | diamond | 135 | 40.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae |
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);;