contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Cryptomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2678102 | 2678102 | PRJEB64798_P_NODE_207683_length_165_cov_4.431034_g205917_i0 | PRJEB64798 | 207683 | 165 | 4.431034 | 7.3112061 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 85.5 | 7.95e-18 | NR | EPZ32623.1 | 988480 | g205917 | i0 | 85.1 | 5.07272727272727 | 47 | 7 | 85.5 | 0 | 20 | 160 | 360 | 406 | EPZ32623.1 3-ketoacyl-CoA thiolase A, peroxisomal [Rozella allomycis CSF55] | diamond | 837 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 5229137 | 5229137 | PRJEB64798_P_NODE_116505_length_208_cov_4.962264_g114739_i0 | PRJEB64798 | 116505 | 208 | 4.962264 | 10.32150912 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 87.8 | 2.38e-19 | NR | EPZ36475.1 | 988480 | g114739 | i0 | 56.9 | 1.78846153846154 | 65 | 28 | 93.8 | 0 | 13 | 207 | 55 | 119 | EPZ36475.1 Aspartic peptidase domain-containing protein, partial [Rozella allomycis CSF55] | diamond | 372 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28170835 | 28170835 | PRJEB64798_P_NODE_233206_length_157_cov_8.527778_g231440_i0 | PRJEB64798 | 233206 | 157 | 8.527778 | 13.38861146 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 42 | 0.0197 | NR | EPZ35295.1 | 988480 | g231440 | i0 | 70 | 0.573248407643312 | 30 | 9 | 57.3 | 0 | 93 | 4 | 88 | 117 | EPZ35295.1 Maleylacetoacetate isomerase domain-containing protein [Rozella allomycis CSF55] | diamond | 90 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28448251 | 28448251 | PRJEB64798_P_NODE_204466_length_166_cov_2.965812_g202700_i0 | PRJEB64798 | 204466 | 166 | 2.965812 | 4.92324792 | Fungi | 4751 | Fungi | Fungi | 85.9 | 7.98e-18 | NR | PJF18525.1 | 1246581 | g202700 | i0 | 75.5 | 1.91566265060241 | 53 | 13 | 95.8 | 0 | 3 | 161 | 456 | 508 | PJF18525.1 DNA helicase [Paramicrosporidium saccamoebae] | diamond | 318 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28549884 | 28549884 | PRJEB64798_P_NODE_193307_length_169_cov_3.016667_g191541_i0 | PRJEB64798 | 193307 | 169 | 3.016667 | 5.09816723 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 87.8 | 1.83e-18 | NR | RKP19791.1 | 988480 | g191541 | i0 | 69.8 | 6.58579881656805 | 53 | 16 | 94.1 | 0 | 159 | 1 | 265 | 317 | RKP19791.1 BOP1NT-domain-containing protein [Rozella allomycis CSF55] | diamond | 1113 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28612785 | 28612785 | PRJEB64798_P_NODE_141687_length_192_cov_10.118881_g139921_i0 | PRJEB64798 | 141687 | 192 | 10.118881 | 19.42825152 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 58.2 | 7.08e-8 | NR | EPZ33612.1 | 988480 | g139921 | i0 | 50.8 | 0.984375 | 63 | 31 | 98.4 | 0 | 189 | 1 | 636 | 698 | EPZ33612.1 Glutamine synthetase, catalytic domain-containing protein [Rozella allomycis CSF55] | diamond | 189 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29244353 | 29244353 | PRJEB64798_P_NODE_190709_length_170_cov_2.834711_g188943_i0 | PRJEB64798 | 190709 | 170 | 2.834711 | 4.8190087 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 41.2 | 0.0454 | NR | EPZ30928.1 | 988480 | g188943 | i0 | 53.3 | 0.529411764705882 | 30 | 14 | 52.9 | 0 | 168 | 79 | 198 | 227 | EPZ30928.1 hypothetical protein O9G_002805 [Rozella allomycis CSF55] | diamond | 90 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29686014 | 29686014 | PRJEB64798_P_NODE_201510_length_167_cov_1.533898_g199744_i0 | PRJEB64798 | 201510 | 167 | 1.533898 | 2.56160966 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 44.7 | 0.00278 | NR | PJF16610.1 | 1246581 | g199744 | i0 | 48.1 | 3.44910179640719 | 54 | 27 | 97 | 1 | 6 | 167 | 208 | 260 | PJF16610.1 Peptidase M16, zinc-binding site domain-containing protein, partial [Paramicrosporidium saccamoebae] | diamond | 576 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30065352 | 30065352 | PRJEB64798_P_NODE_86912_length_212_cov_15.926380_g85146_i0 | PRJEB64798 | 86912 | 212 | 15.92638 | 33.7639256 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 54.7 | 1.54e-6 | NR | EPZ34946.1 | 988480 | g85146 | i0 | 80 | 0.849056603773585 | 30 | 6 | 42.5 | 0 | 114 | 203 | 321 | 350 | EPZ34946.1 RNA polymerase Rpb1 5 domain-containing protein [Rozella allomycis CSF55] | diamond | 180 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31582495 | 31582495 | PRJEB64798_P_NODE_181336_length_174_cov_1.408000_g179570_i0 | PRJEB64798 | 181336 | 174 | 1.408 | 2.44992 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 68.6 | 1.13e-11 | NR | PJF17385.1 | 1246581 | g179570 | i0 | 68.9 | 10.1034482758621 | 45 | 14 | 77.6 | 0 | 2 | 136 | 583 | 627 | PJF17385.1 hypothetical protein PSACC_02852 [Paramicrosporidium saccamoebae] | diamond | 1758 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32587955 | 32587955 | PRJEB64798_P_NODE_250159_length_152_cov_2.058252_g248393_i0 | PRJEB64798 | 250159 | 152 | 2.058252 | 3.12854304 | Eukaryota | 2759 | Fungi | Fungi | 56.2 | 1.85e-7 | NR | RKP22189.1 | 988480 | g248393 | i0 | 46.7 | 3.94736842105263 | 45 | 24 | 88.8 | 0 | 18 | 152 | 169 | 213 | RKP22189.1 glycyl-tRNA synthetase 1 [Rozella allomycis CSF55] | diamond | 600 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32594722 | 32594722 | PRJEB64798_P_NODE_176860_length_175_cov_220.341270_g175094_i0 | PRJEB64798 | 176860 | 175 | 220.34127 | 385.5972225 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 49.3 | 3.4e-6 | NR | RKP19416.1 | 988480 | g175094 | i0 | 66.7 | 0.565714285714286 | 33 | 11 | 56.6 | 0 | 42 | 140 | 8 | 40 | RKP19416.1 hypothetical protein ROZALSC1DRAFT_14013, partial [Rozella allomycis CSF55] | diamond | 99 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis |
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);;