contig_metadata
14 rows where bioproject = "PRJNA744060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10927470 | 10927470 | PRJNA744060_P_NODE_43169_length_254_cov_2.469613_g42840_i0 | PRJNA744060 | 43169 | 254 | 2.469613 | 6.27281702 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 112 | 1.03e-26 | NR | EPZ31958.1 | 988480 | g42840 | i0 | 90.6 | 8.82283464566929 | 53 | 5 | 62.6 | 0 | 253 | 95 | 510 | 562 | EPZ31958.1 Not CCR4-Not complex component domain-containing protein [Rozella allomycis CSF55] | diamond | 2241 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 11402218 | 11402218 | PRJNA744060_P_NODE_1549_length_1170_cov_2.474932_g1373_i0 | PRJNA744060 | 1549 | 1170 | 2.474932 | 28.9567044 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 358 | 2.8399999999999995e-119 | NR | EPZ33240.1 | 988480 | g1373 | i0 | 61.3 | 7.1051282051282 | 315 | 116 | 80.8 | 1 | 1022 | 78 | 1 | 309 | EPZ33240.1 Ribosomal protein L10/acidic P0 domain-containing protein [Rozella allomycis CSF55] | diamond | 8313 | 358 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 13477309 | 13477309 | PRJNA744060_P_NODE_43271_length_254_cov_1.712707_g42942_i0 | PRJNA744060 | 43271 | 254 | 1.712707 | 4.35027578 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 141 | 2.9799999999999996e-37 | NR | EPZ33613.1 | 988480 | g42942 | i0 | 77.4 | 1.98425196850394 | 84 | 19 | 99.2 | 0 | 3 | 254 | 509 | 592 | EPZ33613.1 putative succinate dehydrogenase [ubiquinone] flavoprotein subunit, mitochondrial [Rozella allomycis CSF55] | diamond | 504 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 14752471 | 14752471 | PRJNA744060_P_NODE_47712_length_247_cov_0.896552_g47383_i0 | PRJNA744060 | 47712 | 247 | 0.896552 | 2.21448344 | Fungi | 4751 | Fungi | Fungi | 148 | 3.13e-39 | NR | RKP16771.1 | 988480 | g47383 | i0 | 84.1 | 8.96356275303644 | 82 | 13 | 99.6 | 0 | 247 | 2 | 688 | 769 | RKP16771.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Rozella allomycis CSF55] | diamond | 2214 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 22400865 | 22400865 | PRJNA744060_P_NODE_38878_length_266_cov_2.321244_g38549_i0 | PRJNA744060 | 38878 | 266 | 2.321244 | 6.17450904 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 145 | 1.21e-41 | NR | EPZ31448.1 | 988480 | g38549 | i0 | 83 | 4.91729323308271 | 88 | 15 | 99.2 | 0 | 264 | 1 | 18 | 105 | EPZ31448.1 40S ribosomal protein S8-B [Rozella allomycis CSF55] | diamond | 1308 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 23675970 | 23675970 | PRJNA744060_P_NODE_14239_length_425_cov_5.653409_g13910_i0 | PRJNA744060 | 14239 | 425 | 5.653409 | 24.02698825 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 144 | 8.39e-40 | NR | PJF16614.1 | 1246581 | g13910 | i0 | 69.6 | 0.811764705882353 | 115 | 35 | 81.2 | 0 | 7 | 351 | 128 | 242 | PJF16614.1 40S ribosomal protein S6 [Paramicrosporidium saccamoebae] | diamond | 345 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 26672545 | 26672545 | PRJNA744060_P_NODE_7121_length_597_cov_2.181298_g6798_i0 | PRJNA744060 | 7121 | 597 | 2.181298 | 13.02234906 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 181 | 3.0199999999999996e-54 | NR | EPZ32213.1 | 988480 | g6798 | i0 | 51.6 | 20.1909547738693 | 184 | 80 | 92.5 | 1 | 588 | 37 | 2 | 176 | EPZ32213.1 60S ribosomal protein L20-B [Rozella allomycis CSF55] | diamond | 12054 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26704269 | 26704269 | PRJNA744060_P_NODE_18141_length_379_cov_1.183007_g17812_i0 | PRJNA744060 | 18141 | 379 | 1.183007 | 4.48359653 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 59.7 | 1.19e-7 | NR | EPZ34237.1 | 988480 | g17812 | i0 | 55 | 0.316622691292876 | 40 | 18 | 31.7 | 0 | 54 | 173 | 41 | 80 | EPZ34237.1 hypothetical protein O9G_001850 [Rozella allomycis CSF55] | diamond | 120 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26863185 | 26863185 | PRJNA744060_P_NODE_14621_length_420_cov_2.876081_g14292_i0 | PRJNA744060 | 14621 | 420 | 2.876081 | 12.0795402 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 169 | 2.86e-51 | NR | EPZ31907.1 | 988480 | g14292 | i0 | 68.8 | 1.85714285714286 | 128 | 40 | 91.4 | 0 | 398 | 15 | 1 | 128 | EPZ31907.1 60S ribosomal protein L26-2 [Rozella allomycis CSF55] | diamond | 780 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26904591 | 26904591 | PRJNA744060_P_NODE_30861_length_295_cov_1.725225_g30532_i0 | PRJNA744060 | 30861 | 295 | 1.725225 | 5.08941375 | root | 1 | Root_unresolved | Root_unresolved | 129 | 2.34e-32 | NR | EPZ36233.1 | 988480 | g30532 | i0 | 62.2 | 6.99661016949153 | 98 | 36 | 98.6 | 1 | 293 | 3 | 501 | 598 | EPZ36233.1 Peptidase M36, fungalysin domain-containing protein [Rozella allomycis CSF55] | diamond | 2064 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28357436 | 28357436 | PRJNA744060_P_NODE_54426_length_227_cov_2.019481_g54097_i0 | PRJNA744060 | 54426 | 227 | 2.019481 | 4.58422187 | root | 1 | Root_unresolved | Root_unresolved | 69.3 | 1.3e-11 | NR | PJF18167.1 | 1246581 | g54097 | i0 | 61.1 | 2.15418502202643 | 54 | 21 | 71.4 | 0 | 219 | 58 | 749 | 802 | PJF18167.1 Elongation factor, GTP-binding domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 489 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28947762 | 28947762 | PRJNA744060_P_NODE_37088_length_272_cov_1.562814_g36759_i0 | PRJNA744060 | 37088 | 272 | 1.562814 | 4.25085408 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 81.3 | 1.65e-16 | NR | EPZ35469.1 | 988480 | g36759 | i0 | 50 | 0.860294117647059 | 78 | 36 | 82.7 | 1 | 227 | 3 | 26 | 103 | EPZ35469.1 hypothetical protein O9G_005006 [Rozella allomycis CSF55] | diamond | 234 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29483984 | 29483984 | PRJNA744060_P_NODE_30950_length_295_cov_1.157658_g30621_i0 | PRJNA744060 | 30950 | 295 | 1.157658 | 3.4150911 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 120 | 1.14e-29 | NR | EPZ32163.1 | 988480 | g30621 | i0 | 57.1 | 2.8271186440678 | 91 | 39 | 92.5 | 0 | 22 | 294 | 373 | 463 | EPZ32163.1 Translin domain-containing protein [Rozella allomycis CSF55] | diamond | 834 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29957897 | 29957897 | PRJNA744060_P_NODE_49291_length_245_cov_0.906977_g48962_i0 | PRJNA744060 | 49291 | 245 | 0.906977 | 2.22209365 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 61.6 | 8.46e-9 | NR | EPZ32737.1 | 988480 | g48962 | i0 | 40.3 | 0.881632653061225 | 72 | 43 | 88.2 | 0 | 219 | 4 | 393 | 464 | EPZ32737.1 DUF1929 domain-containing protein [Rozella allomycis CSF55] | diamond | 216 | 61.6 | 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);;