contig_metadata
19 rows where bioproject = "PRJNA1028258", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5265854 | 5265854 | PRJNA1028258_P_NODE_107505_length_254_cov_2.113514_g106942_i0 | PRJNA1028258 | 107505 | 254 | 2.113514 | 5.36832556 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 143 | 2.03e-37 | NR | EPZ35747.1 | 988480 | g106942 | i0 | 81.9 | 2.94094488188976 | 83 | 15 | 98 | 0 | 251 | 3 | 441 | 523 | EPZ35747.1 ATPase, F1/V1/A1 complex, alpha/beta subunit domain-containing protein [Rozella allomycis CSF55] | diamond | 747 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 5267664 | 5267664 | PRJNA1028258_P_NODE_43565_length_383_cov_2.700637_g43002_i0 | PRJNA1028258 | 43565 | 383 | 2.700637 | 10.34343971 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 221 | 6.87e-71 | NR | EPZ35492.1 | 988480 | g43002 | i0 | 82.7 | 3.97911227154047 | 127 | 22 | 99.5 | 0 | 381 | 1 | 2 | 128 | EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55] | diamond | 1524 | 221 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 10369027 | 10369027 | PRJNA1028258_P_NODE_91029_length_270_cov_1.412935_g90466_i0 | PRJNA1028258 | 91029 | 270 | 1.412935 | 3.8149245 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 137 | 2.18e-38 | NR | PJF17524.1 | 1246581 | g90466 | i0 | 71.8 | 4.72222222222222 | 85 | 24 | 94.4 | 0 | 270 | 16 | 122 | 206 | PJF17524.1 hypothetical protein PSACC_02620 [Paramicrosporidium saccamoebae] | diamond | 1275 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 12483514 | 12483514 | PRJNA1028258_P_NODE_140830_length_233_cov_0.865854_g140267_i0 | PRJNA1028258 | 140830 | 233 | 0.865854 | 2.01743982 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 77.4 | 7.96e-15 | NR | RKP16786.1 | 988480 | g140267 | i0 | 48.6 | 0.901287553648069 | 70 | 36 | 90.1 | 0 | 22 | 231 | 14 | 83 | RKP16786.1 mitochondrial carrier protein [Rozella allomycis CSF55] | diamond | 210 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 18014904 | 18014904 | PRJNA1028258_P_NODE_108555_length_253_cov_2.880435_g107992_i0 | PRJNA1028258 | 108555 | 253 | 2.880435 | 7.28750055 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 117 | 6.089999999999999e-31 | NR | EPZ34500.1 | 988480 | g107992 | i0 | 69.9 | 6.05928853754941 | 73 | 22 | 86.6 | 0 | 2 | 220 | 110 | 182 | EPZ34500.1 60S ribosomal protein L11 [Rozella allomycis CSF55] | diamond | 1533 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 21841665 | 21841665 | PRJNA1028258_P_NODE_39738_length_401_cov_2.000000_g39175_i0 | PRJNA1028258 | 39738 | 401 | 2 | 8.02 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 196 | 3.98e-57 | NR | RKP16896.1 | 988480 | g39175 | i0 | 69.2 | 0.99501246882793 | 133 | 41 | 99.5 | 0 | 1 | 399 | 438 | 570 | RKP16896.1 ribosome biogenesis ATPase [Rozella allomycis CSF55] | diamond | 399 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26781957 | 26781957 | PRJNA1028258_P_NODE_138841_length_234_cov_0.860606_g138278_i0 | PRJNA1028258 | 138841 | 234 | 0.860606 | 2.01381804 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 43.5 | 0.0181 | NR | EPZ33796.1 | 988480 | g138278 | i0 | 34.6 | 1 | 78 | 48 | 98.7 | 2 | 1 | 231 | 226 | 301 | EPZ33796.1 hypothetical protein O9G_002508 [Rozella allomycis CSF55] | diamond | 234 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26845459 | 26845459 | PRJNA1028258_P_NODE_97661_length_263_cov_1.463918_g97098_i0 | PRJNA1028258 | 97661 | 263 | 1.463918 | 3.85010434 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 85.1 | 5.92e-17 | NR | PJF19227.1 | 1246581 | g97098 | i0 | 50 | 0.889733840304182 | 78 | 37 | 86.7 | 1 | 22 | 249 | 442 | 519 | PJF19227.1 PMT-domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 234 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27129472 | 27129472 | PRJNA1028258_P_NODE_80722_length_287_cov_1.302752_g80159_i0 | PRJNA1028258 | 80722 | 287 | 1.302752 | 3.73889824 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 60.5 | 2.38e-9 | NR | EPZ35332.1 | 988480 | g80159 | i0 | 38.9 | 3.79442508710801 | 90 | 55 | 94.1 | 0 | 286 | 17 | 2 | 91 | EPZ35332.1 Prefoldin domain-containing protein [Rozella allomycis CSF55] | diamond | 1089 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27635504 | 27635504 | PRJNA1028258_P_NODE_53384_length_348_cov_0.982079_g52821_i0 | PRJNA1028258 | 53384 | 348 | 0.982079 | 3.41763492 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 147 | 2.08e-39 | NR | EPZ31343.1 | 988480 | g52821 | i0 | 56.1 | 1.95689655172414 | 114 | 49 | 98.3 | 1 | 343 | 2 | 212 | 324 | EPZ31343.1 DUF1900 domain-containing protein [Rozella allomycis CSF55] | diamond | 681 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28014434 | 28014434 | PRJNA1028258_P_NODE_44645_length_379_cov_1.367742_g44082_i0 | PRJNA1028258 | 44645 | 379 | 1.367742 | 5.18374218 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 186 | 4.319999999999999e-54 | NR | EPZ31343.1 | 988480 | g44082 | i0 | 64.8 | 0.989445910290237 | 125 | 44 | 98.9 | 0 | 4 | 378 | 188 | 312 | EPZ31343.1 DUF1900 domain-containing protein [Rozella allomycis CSF55] | diamond | 375 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28108771 | 28108771 | PRJNA1028258_P_NODE_146045_length_232_cov_0.871166_g145482_i0 | PRJNA1028258 | 146045 | 232 | 0.871166 | 2.02110512 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 110 | 5.0199999999999993e-29 | NR | EPZ34940.1 | 988480 | g145482 | i0 | 63.2 | 4.92672413793103 | 76 | 28 | 98.3 | 0 | 232 | 5 | 35 | 110 | EPZ34940.1 40S ribosomal protein S19-A [Rozella allomycis CSF55] | diamond | 1143 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29529833 | 29529833 | PRJNA1028258_P_NODE_128150_length_237_cov_2.535714_g127587_i0 | PRJNA1028258 | 128150 | 237 | 2.535714 | 6.00964218 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 82.4 | 6.92e-17 | NR | EPZ34692.1 | 988480 | g127587 | i0 | 66.2 | 3.9746835443038 | 65 | 21 | 81 | 1 | 225 | 34 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29584699 | 29584699 | PRJNA1028258_P_NODE_142330_length_233_cov_0.865854_g141767_i0 | PRJNA1028258 | 142330 | 233 | 0.865854 | 2.01743982 | Eukaryota | 2759 | Fungi | Fungi | 140 | 5.46e-41 | NR | EPZ32425.1 | 988480 | g141767 | i0 | 85.7 | 6.91416309012876 | 77 | 11 | 99.1 | 0 | 1 | 231 | 6 | 82 | EPZ32425.1 40S ribosomal protein S15a-4 [Rozella allomycis CSF55] | diamond | 1611 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30192915 | 30192915 | PRJNA1028258_P_NODE_114092_length_249_cov_1.411111_g113529_i0 | PRJNA1028258 | 114092 | 249 | 1.411111 | 3.51366639 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 100 | 2.57e-22 | NR | PJF19185.1 | 1246581 | g113529 | i0 | 56.1 | 0.987951807228916 | 82 | 36 | 98.8 | 0 | 2 | 247 | 294 | 375 | PJF19185.1 hypothetical protein PSACC_00999 [Paramicrosporidium saccamoebae] | diamond | 246 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31544201 | 31544201 | PRJNA1028258_P_NODE_174316_length_225_cov_1.679487_g173753_i0 | PRJNA1028258 | 174316 | 225 | 1.679487 | 3.77884575 | Fungi | 4751 | Fungi | Fungi | 52.4 | 2.42e-6 | NR | PJF17821.1 | 1246581 | g173753 | i0 | 73.3 | 4.17333333333333 | 30 | 7 | 40 | 1 | 93 | 4 | 1 | 29 | PJF17821.1 Rec8 subunit of sister chromatid cohesion complex [Paramicrosporidium saccamoebae] | diamond | 939 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31710208 | 31710208 | PRJNA1028258_P_NODE_60437_length_328_cov_1.293436_g59874_i0 | PRJNA1028258 | 60437 | 328 | 1.293436 | 4.24247008 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 79.7 | 1.05e-14 | NR | RKP16896.1 | 988480 | g59874 | i0 | 50.5 | 0.832317073170732 | 91 | 27 | 83.2 | 2 | 274 | 2 | 4 | 76 | RKP16896.1 ribosome biogenesis ATPase [Rozella allomycis CSF55] | diamond | 273 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31765445 | 31765445 | PRJNA1028258_P_NODE_174957_length_225_cov_0.910256_g174394_i0 | PRJNA1028258 | 174957 | 225 | 0.910256 | 2.048076 | Fungi | 4751 | Fungi | Fungi | 130 | 2.63e-36 | NR | EPZ35492.1 | 988480 | g174394 | i0 | 83.8 | 5.92 | 74 | 12 | 98.7 | 0 | 224 | 3 | 7 | 80 | EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55] | diamond | 1332 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32784722 | 32784722 | PRJNA1028258_P_NODE_163920_length_228_cov_0.893082_g163357_i0 | PRJNA1028258 | 163920 | 228 | 0.893082 | 2.03622696 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 90.5 | 1.03e-19 | NR | PJF19047.1 | 1246581 | g163357 | i0 | 55.6 | 0.947368421052632 | 72 | 32 | 94.7 | 0 | 1 | 216 | 33 | 104 | PJF19047.1 Carbohydrate esterase family 4 protein [Paramicrosporidium saccamoebae] | diamond | 216 | 90.5 | 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);;