contig_metadata
12 rows where bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1587080 | 1587080 | PRJNA1166865_P_NODE_26422_length_418_cov_2.113043_g26181_i0 | PRJNA1166865 | 26422 | 418 | 2.113043 | 8.83251974 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 211 | 9.12e-67 | NR | EPZ33870.1 | 988480 | g26181 | i0 | 77 | 0.9688995215311 | 135 | 31 | 96.9 | 0 | 14 | 418 | 1 | 135 | EPZ33870.1 60S ribosomal protein L13a [Rozella allomycis CSF55] | diamond | 405 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 2864322 | 2864322 | PRJNA1166865_P_NODE_67843_length_267_cov_2.252577_g67602_i0 | PRJNA1166865 | 67843 | 267 | 2.252577 | 6.01438059 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 159 | 2.999999999999999e-47 | NR | EPZ35492.1 | 988480 | g67602 | i0 | 85.4 | 14.9887640449438 | 89 | 13 | 100 | 0 | 267 | 1 | 2 | 90 | EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55] | diamond | 4002 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 16889588 | 16889588 | PRJNA1166865_P_NODE_27034_length_413_cov_2.717647_g26793_i0 | PRJNA1166865 | 27034 | 413 | 2.717647 | 11.22388211 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 198 | 2e-62 | NR | PJF20044.1 | 1246581 | g26793 | i0 | 74.4 | 7.6634382566586 | 125 | 32 | 90.8 | 0 | 412 | 38 | 40 | 164 | PJF20044.1 hypothetical protein PSACC_00140 [Paramicrosporidium saccamoebae] | diamond | 3165 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 18164517 | 18164517 | PRJNA1166865_P_NODE_4295_length_971_cov_9.850780_g4140_i0 | PRJNA1166865 | 4295 | 971 | 9.85078 | 95.6510738 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 287 | 4.05e-93 | NR | PJF16902.1 | 1246581 | g4140 | i0 | 64.4 | 7.62203913491246 | 236 | 81 | 72.6 | 3 | 165 | 869 | 24 | 257 | PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] | diamond | 7401 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 23264746 | 23264746 | PRJNA1166865_P_NODE_29819_length_394_cov_1.919003_g29578_i0 | PRJNA1166865 | 29819 | 394 | 1.919003 | 7.56087182 | Eukaryota | 2759 | Fungi | Fungi | 110 | 1.06e-26 | NR | PJF16516.1 | 1246581 | g29578 | i0 | 73.3 | 1.75126903553299 | 75 | 19 | 57.1 | 1 | 4 | 228 | 149 | 222 | PJF16516.1 hypothetical protein PSACC_03723 [Paramicrosporidium saccamoebae] | diamond | 690 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 25265944 | 25265944 | PRJNA1166865_P_NODE_78100_length_250_cov_0.870056_g77859_i0 | PRJNA1166865 | 78100 | 250 | 0.870056 | 2.17514 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 105 | 9.77e-27 | NR | PJF20154.1 | 1246581 | g77859 | i0 | 68.4 | 1.896 | 79 | 25 | 94.8 | 0 | 14 | 250 | 3 | 81 | PJF20154.1 Ribosomal protein L22 [Paramicrosporidium saccamoebae] | diamond | 474 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27103537 | 27103537 | PRJNA1166865_P_NODE_19222_length_490_cov_1.129496_g18981_i0 | PRJNA1166865 | 19222 | 490 | 1.129496 | 5.5345304 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 184 | 1.99e-50 | NR | PJF19231.1 | 1246581 | g18981 | i0 | 56.4 | 0.997959183673469 | 163 | 69 | 99.8 | 1 | 490 | 2 | 1291 | 1451 | PJF19231.1 Aminoacyl-tRNA synthetase, class Ia domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 489 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27798784 | 27798784 | PRJNA1166865_P_NODE_49964_length_312_cov_1.288703_g49723_i0 | PRJNA1166865 | 49964 | 312 | 1.288703 | 4.02075336 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 136 | 1.95e-36 | NR | EPZ36987.1 | 988480 | g49723 | i0 | 56.9 | 2.94230769230769 | 102 | 44 | 98.1 | 0 | 308 | 3 | 66 | 167 | EPZ36987.1 4-hydroxyphenylpyruvate dioxygenase [Rozella allomycis CSF55] | diamond | 918 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28019789 | 28019789 | PRJNA1166865_P_NODE_49745_length_313_cov_0.962500_g49504_i0 | PRJNA1166865 | 49745 | 313 | 0.9625 | 3.012625 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 154 | 4.45e-41 | NR | PJF19231.1 | 1246581 | g49504 | i0 | 67.3 | 0.996805111821086 | 104 | 33 | 98.7 | 1 | 4 | 312 | 1157 | 1260 | PJF19231.1 Aminoacyl-tRNA synthetase, class Ia domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 312 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29535199 | 29535199 | PRJNA1166865_P_NODE_96050_length_222_cov_4.281879_g95809_i0 | PRJNA1166865 | 96050 | 222 | 4.281879 | 9.50577138 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 81.3 | 1.56e-16 | NR | EPZ34692.1 | 988480 | g95809 | i0 | 66.2 | 4.24324324324324 | 65 | 21 | 86.5 | 1 | 13 | 204 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30754886 | 30754886 | PRJNA1166865_P_NODE_23314_length_445_cov_1.655914_g23073_i0 | PRJNA1166865 | 23314 | 445 | 1.655914 | 7.3688173 | Fungi | 4751 | Fungi | Fungi | 94 | 3.09e-19 | NR | PJF16610.1 | 1246581 | g23073 | i0 | 36.3 | 8.07640449438202 | 146 | 91 | 97.1 | 2 | 442 | 11 | 109 | 254 | PJF16610.1 Peptidase M16, zinc-binding site domain-containing protein, partial [Paramicrosporidium saccamoebae] | diamond | 3594 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31083156 | 31083156 | PRJNA1166865_P_NODE_69095_length_264_cov_2.816754_g68854_i0 | PRJNA1166865 | 69095 | 264 | 2.816754 | 7.43623056 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 114 | 3.61e-29 | NR | EPZ30786.1 | 988480 | g68854 | i0 | 64.2 | 2.71590909090909 | 81 | 29 | 92 | 0 | 243 | 1 | 168 | 248 | EPZ30786.1 Ribosomal protein L22/L17, eukaryotic/archaeal domain-containing protein [Rozella allomycis CSF55] | diamond | 717 | 114 | 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);;