contig_metadata
9 rows where bioproject = "PRJNA796753", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4609204 | 4609204 | PRJNA796753_P_NODE_6004_length_552_cov_2.304802_g5696_i0 | PRJNA796753 | 6004 | 552 | 2.304802 | 12.72250704 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 224 | 7.35e-67 | NR | RKP16896.1 | 988480 | g5696 | i0 | 59 | 11.6304347826087 | 178 | 70 | 95.1 | 1 | 1 | 525 | 402 | 579 | RKP16896.1 ribosome biogenesis ATPase [Rozella allomycis CSF55] | diamond | 6420 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 7159117 | 7159117 | PRJNA796753_P_NODE_37806_length_254_cov_1.276243_g37494_i0 | PRJNA796753 | 37806 | 254 | 1.276243 | 3.24165722 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 96.7 | 4.7e-21 | NR | PJF20167.1 | 1246581 | g37494 | i0 | 61 | 14.7283464566929 | 82 | 32 | 96.9 | 0 | 248 | 3 | 682 | 763 | PJF20167.1 DNA-directed RNA polymerase subunit [Paramicrosporidium saccamoebae] | diamond | 3741 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 10984530 | 10984530 | PRJNA796753_P_NODE_1229_length_1104_cov_1.765276_g1049_i0 | PRJNA796753 | 1229 | 1104 | 1.765276 | 19.48864704 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 262 | 9.91e-75 | NR | EPZ32871.1 | 988480 | g1049 | i0 | 45.6 | 0.809782608695652 | 298 | 138 | 80.4 | 5 | 31 | 918 | 915 | 1190 | EPZ32871.1 P-type ATPase domain-containing protein [Rozella allomycis CSF55] | diamond | 894 | 262 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 16083269 | 16083269 | PRJNA796753_P_NODE_40753_length_250_cov_0.870056_g40441_i0 | PRJNA796753 | 40753 | 250 | 0.870056 | 2.17514 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 140 | 2.9999999999999998e-40 | NR | PJF20154.1 | 1246581 | g40441 | i0 | 80.8 | 0.936 | 78 | 15 | 93.6 | 0 | 242 | 9 | 75 | 152 | PJF20154.1 Ribosomal protein L22 [Paramicrosporidium saccamoebae] | diamond | 234 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 22894254 | 22894254 | PRJNA796753_P_NODE_11178_length_417_cov_1.343023_g10866_i0 | PRJNA796753 | 11178 | 417 | 1.343023 | 5.60040591 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 213 | 3.28e-65 | NR | EPZ32623.1 | 988480 | g10866 | i0 | 74.1 | 1.94244604316547 | 135 | 35 | 97.1 | 0 | 415 | 11 | 273 | 407 | EPZ32623.1 3-ketoacyl-CoA thiolase A, peroxisomal [Rozella allomycis CSF55] | diamond | 810 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26673676 | 26673676 | PRJNA796753_P_NODE_41661_length_249_cov_1.750000_g41349_i0 | PRJNA796753 | 41661 | 249 | 1.75 | 4.3575 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 97.4 | 2.28e-21 | NR | PJF18249.1 | 1246581 | g41349 | i0 | 83.6 | 0.662650602409639 | 55 | 9 | 66.3 | 0 | 2 | 166 | 207 | 261 | PJF18249.1 1-pyrroline-5-carboxylate dehydrogenase [Paramicrosporidium saccamoebae] | diamond | 165 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30527743 | 30527743 | PRJNA796753_P_NODE_34313_length_266_cov_1.196891_g34001_i0 | PRJNA796753 | 34313 | 266 | 1.196891 | 3.18373006 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 86.7 | 5.01e-19 | NR | RKP21900.1 | 988480 | g34001 | i0 | 58.3 | 1.96240601503759 | 60 | 24 | 67.7 | 1 | 3 | 182 | 116 | 174 | RKP21900.1 DUF298-domain-containing protein, partial [Rozella allomycis CSF55] | diamond | 522 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32267023 | 32267023 | PRJNA796753_P_NODE_21198_length_322_cov_1.172691_g20886_i0 | PRJNA796753 | 21198 | 322 | 1.172691 | 3.77606502 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 44.7 | 0.0188 | NR | EPZ33796.1 | 988480 | g20886 | i0 | 30.6 | 0.670807453416149 | 72 | 50 | 67.1 | 0 | 320 | 105 | 500 | 571 | EPZ33796.1 hypothetical protein O9G_002508 [Rozella allomycis CSF55] | diamond | 216 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32749652 | 32749652 | PRJNA796753_P_NODE_14060_length_378_cov_1.514754_g13748_i0 | PRJNA796753 | 14060 | 378 | 1.514754 | 5.72577012 | Fungi | 4751 | Fungi | Fungi | 143 | 1.3899999999999999e-40 | NR | EPZ34386.1 | 988480 | g13748 | i0 | 66.1 | 11.3412698412698 | 115 | 34 | 88.1 | 2 | 46 | 378 | 29 | 142 | EPZ34386.1 RNA recognition motif domain-containing protein [Rozella allomycis CSF55] | diamond | 4287 | 143 | 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);;