contig_metadata
6 rows where bioproject = "PRJNA605033", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 582612 | 582612 | PRJNA605033_P_NODE_28781_length_282_cov_1.963563_g27215_i0 | PRJNA605033 | 28781 | 282 | 1.963563 | 5.53724766 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 3.97e-65 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g27215 | i0 | 100 | 1.34042553191489 | 141 | 0 | 84 | 0 | 142 | 282 | 871 | 1011 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 378 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 1857979 | 1857979 | PRJNA605033_P_NODE_200182_length_166_cov_0.992366_g198613_i0 | PRJNA605033 | 200182 | 166 | 0.992366 | 1.64732756 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.31e-5 | NTclustered | gi|2795026526|ref|XM_067934115.1| | 4785 | g198613 | i0 | 100 | 0.385542168674699 | 32 | 0 | 19 | 0 | 105 | 136 | 145 | 176 | Phytophthora cinnamomi putative soluble pyridine nucleotide transhydrogenase (IUM83_09663), partial mRNA | blastn | 64 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13336601 | 13336601 | PRJNA605033_P_NODE_235011_length_153_cov_5.533898_g233442_i0 | PRJNA605033 | 235011 | 153 | 5.533898 | 8.46686394 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.3500000000000006e-27 | NTclustered | gi|325195233|emb|FR826028.1| | 890382 | g233442 | i0 | 94.318 | 0.803921568627451 | 88 | 3 | 56 | 2 | 68 | 153 | 185 | 272 | Albugo laibachii Nc14, genomic contig CONTIG_3114_NC14_v4_456_30 | blastn | 123 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 19707865 | 19707865 | PRJNA605033_P_NODE_119196_length_222_cov_1.582888_g117627_i0 | PRJNA605033 | 119196 | 222 | 1.582888 | 3.51401136 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.23e-4 | NTclustered | gi|813141428|ref|XM_012343565.1| | 695850 | g117627 | i0 | 89.362 | 0.211711711711712 | 47 | 3 | 21 | 2 | 30 | 75 | 832 | 787 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 47 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 20271914 | 20271914 | PRJNA605033_P_NODE_235256_length_153_cov_3.957627_g233687_i0 | PRJNA605033 | 235256 | 153 | 3.957627 | 6.05516931 | root | 1 | Root_unresolved | Root_unresolved | 158 | 2.58e-34 | NTclustered | gi|166046600|emb|CU367717.1| | 100861 | g233687 | i0 | 98.876 | 19.1176470588235 | 89 | 0 | 94 | 1 | 66 | 153 | 509 | 597 | Aphanomyces euteiches cDNA | blastn | 2925 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28988255 | 28988255 | PRJNA605033_P_NODE_86348_length_222_cov_2.283422_g84779_i0 | PRJNA605033 | 86348 | 222 | 2.283422 | 5.06919684 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00725 | NR | TMW55191.1 | 41045 | g84779 | i0 | 79.2 | 2.27027027027027 | 24 | 5 | 32.4 | 0 | 149 | 220 | 43 | 66 | TMW55191.1 hypothetical protein Poli38472_013953 [Pythium oligandrum] | diamond | 504 | 44.7 | 0.991051454138702 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;