contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 860468 | 860468 | PRJNA884104_S_NODE_2521_length_1249_cov_3.369048_g2180_i0 | PRJNA884104 | 2521 | 1249 | 3.369048 | 42.07940952 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 287 | 9.15e-92 | NR | PJF16902.1 | 1246581 | g2180 | i0 | 64.4 | 5.92554043234588 | 236 | 81 | 56.4 | 3 | 165 | 869 | 24 | 257 | PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] | diamond | 7401 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 23813411 | 23813411 | PRJNA884104_S_NODE_6179_length_817_cov_14.618280_g5391_i1 | PRJNA884104 | 6179 | 817 | 14.61828 | 119.4313476 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 357 | 1.42e-121 | NR | EPZ32691.1 | 988480 | g5391 | i1 | 64.6 | 16.0832313341493 | 257 | 91 | 94.4 | 0 | 8 | 778 | 1 | 257 | EPZ32691.1 40S ribosomal protein S4 [Rozella allomycis CSF55] | diamond | 13140 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28161070 | 28161070 | PRJNA884104_S_NODE_67045_length_254_cov_1.138122_g66302_i0 | PRJNA884104 | 67045 | 254 | 1.138122 | 2.89082988 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 114 | 1.5e-27 | NR | EPZ32356.1 | 988480 | g66302 | i0 | 59.5 | 3.92125984251969 | 84 | 34 | 99.2 | 0 | 3 | 254 | 213 | 296 | EPZ32356.1 Tyrosine 3-monooxygenase-like domain-containing protein [Rozella allomycis CSF55] | diamond | 996 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28800020 | 28800020 | PRJNA884104_S_NODE_54667_length_283_cov_1.295238_g53924_i0 | PRJNA884104 | 54667 | 283 | 1.295238 | 3.66552354 | Opisthokonta | 33154 | Fungi | Fungi | 102 | 4.5899999999999996e-23 | NR | EPZ33907.1 | 988480 | g53924 | i0 | 50.5 | 3.95406360424028 | 93 | 46 | 98.6 | 0 | 282 | 4 | 231 | 323 | EPZ33907.1 hypothetical protein O9G_002470 [Rozella allomycis CSF55] | diamond | 1119 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29557877 | 29557877 | PRJNA884104_S_NODE_85790_length_241_cov_0.916667_g85047_i0 | PRJNA884104 | 85790 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Fungi | Fungi | 105 | 3.0899999999999993e-24 | NR | EPZ34473.1 | 988480 | g85047 | i0 | 65.4 | 3.85892116182573 | 78 | 27 | 97.1 | 0 | 235 | 2 | 1123 | 1200 | EPZ34473.1 Protein-tyrosine phosphatase, receptor/non-receptor type domain-containing protein [Rozella allomycis CSF55] | diamond | 930 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29707539 | 29707539 | PRJNA884104_S_NODE_46170_length_307_cov_1.299145_g45427_i0 | PRJNA884104 | 46170 | 307 | 1.299145 | 3.98837515 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 151 | 6.1099999999999986e-40 | NR | PJF20135.1 | 1246581 | g45427 | i0 | 71.3 | 0.986970684039088 | 101 | 29 | 98.7 | 0 | 305 | 3 | 423 | 523 | PJF20135.1 Alpha-1,4 glucan phosphorylase [Paramicrosporidium saccamoebae] | diamond | 303 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30718841 | 30718841 | PRJNA884104_S_NODE_47474_length_303_cov_1.382609_g46731_i0 | PRJNA884104 | 47474 | 303 | 1.382609 | 4.18930527 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 44.3 | 0.0199 | NR | RKP19087.1 | 988480 | g46731 | i0 | 30 | 0.891089108910891 | 90 | 59 | 89.1 | 1 | 22 | 291 | 159 | 244 | RKP19087.1 hypothetical protein ROZALSC1DRAFT_22610, partial [Rozella allomycis CSF55] | diamond | 270 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31192464 | 31192464 | PRJNA884104_S_NODE_29715_length_374_cov_1.249169_g28972_i0 | PRJNA884104 | 29715 | 374 | 1.249169 | 4.67189206 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 90.9 | 7.86e-20 | NR | PJF16859.1 | 1246581 | g28972 | i0 | 52 | 1.20320855614973 | 75 | 36 | 60.2 | 0 | 232 | 8 | 40 | 114 | PJF16859.1 hypothetical protein PSACC_03336 [Paramicrosporidium saccamoebae] | diamond | 450 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31635584 | 31635584 | PRJNA884104_S_NODE_37556_length_336_cov_2.733840_g36813_i0 | PRJNA884104 | 37556 | 336 | 2.73384 | 9.1857024 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 75.9 | 3.17e-15 | NR | EPZ31580.1 | 988480 | g36813 | i0 | 53.6 | 1.16071428571429 | 69 | 31 | 60.7 | 1 | 44 | 247 | 4 | 72 | EPZ31580.1 60S acidic ribosomal protein P1-alpha 1 [Rozella allomycis CSF55] | diamond | 390 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31698931 | 31698931 | PRJNA884104_S_NODE_11597_length_593_cov_2.217308_g10873_i0 | PRJNA884104 | 11597 | 593 | 2.217308 | 13.14863644 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 70.1 | 3.32e-10 | NR | EPZ36061.1 | 988480 | g10873 | i0 | 43.9 | 2.88364249578415 | 82 | 40 | 38.4 | 1 | 302 | 529 | 16 | 97 | EPZ36061.1 Alkaline phosphatase-like, alpha/beta/alpha domain-containing protein [Rozella allomycis CSF55] | diamond | 1710 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31793612 | 31793612 | PRJNA884104_S_NODE_63897_length_261_cov_1.015957_g63154_i0 | PRJNA884104 | 63897 | 261 | 1.015957 | 2.65164777 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 84 | 1.15e-16 | NR | EPZ34892.1 | 988480 | g63154 | i0 | 48.7 | 0.873563218390805 | 76 | 39 | 87.4 | 0 | 259 | 32 | 342 | 417 | EPZ34892.1 AMP-dependent synthetase/ligase domain-containing protein [Rozella allomycis CSF55] | diamond | 228 | 84 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31983541 | 31983541 | PRJNA884104_S_NODE_10418_length_625_cov_3.344203_g9704_i0 | PRJNA884104 | 10418 | 625 | 3.344203 | 20.90126875 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 145 | 4.55e-38 | NR | EPZ33073.1 | 988480 | g9704 | i0 | 52.4 | 5.2944 | 145 | 66 | 69.1 | 3 | 624 | 193 | 197 | 339 | EPZ33073.1 60S ribosomal protein L4-A [Rozella allomycis CSF55] | diamond | 3309 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32237160 | 32237160 | PRJNA884104_S_NODE_67318_length_253_cov_1.283333_g66575_i0 | PRJNA884104 | 67318 | 253 | 1.283333 | 3.24683249 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 63.2 | 2.63e-9 | NR | PJF19671.1 | 1246581 | g66575 | i0 | 39 | 0.972332015810277 | 82 | 49 | 96 | 1 | 3 | 245 | 383 | 464 | PJF19671.1 Integral membrane protein [Paramicrosporidium saccamoebae] | diamond | 246 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae |
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);;