contig_metadata
8 rows where bioproject = "PRJNA1204310", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13082381 | 13082381 | PRJNA1204310_P_NODE_18531_length_417_cov_2.261628_g18234_i0 | PRJNA1204310 | 18531 | 417 | 2.261628 | 9.43098876 | Eukaryota | 2759 | Fungi | Fungi | 208 | 1.56e-62 | NR | EPZ32670.1 | 988480 | g18234 | i0 | 73.3 | 3.90647482014389 | 131 | 35 | 94.2 | 0 | 1 | 393 | 46 | 176 | EPZ32670.1 Eukaryotic translation initiation factor 2 subunit gamma [Rozella allomycis CSF55] | diamond | 1629 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 16907039 | 16907039 | PRJNA1204310_P_NODE_9194_length_575_cov_6.155378_g8904_i0 | PRJNA1204310 | 9194 | 575 | 6.155378 | 35.3934235 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 272 | 2.8399999999999993e-89 | NR | EPZ33659.1 | 988480 | g8904 | i0 | 70.8 | 65.6295652173913 | 185 | 54 | 96.5 | 0 | 555 | 1 | 1 | 185 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 37737 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28007616 | 28007616 | PRJNA1204310_P_NODE_3965_length_836_cov_15.955439_g3515_i1 | PRJNA1204310 | 3965 | 836 | 15.955439 | 133.38747004 | Fungi | 4751 | Fungi | Fungi | 356 | 7.279999999999998e-121 | NR | EPZ32691.1 | 988480 | g3515 | i1 | 66.1 | 12.7858851674641 | 251 | 85 | 90.1 | 0 | 817 | 65 | 1 | 251 | EPZ32691.1 40S ribosomal protein S4 [Rozella allomycis CSF55] | diamond | 10689 | 356 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28335874 | 28335874 | PRJNA1204310_P_NODE_41686_length_287_cov_1.457944_g41389_i0 | PRJNA1204310 | 41686 | 287 | 1.457944 | 4.18429928 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 54.7 | 1.01e-6 | NR | PJF18485.1 | 1246581 | g41389 | i0 | 46 | 0.522648083623693 | 50 | 27 | 52.3 | 0 | 154 | 5 | 63 | 112 | PJF18485.1 FAM210B-like Protein [Paramicrosporidium saccamoebae] | diamond | 150 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30104055 | 30104055 | PRJNA1204310_P_NODE_11452_length_519_cov_1.771300_g11156_i0 | PRJNA1204310 | 11452 | 519 | 1.7713 | 9.193047 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 70.9 | 1.04e-10 | NR | EPZ36196.1 | 988480 | g11156 | i0 | 46.5 | 0.410404624277457 | 71 | 38 | 41 | 0 | 288 | 76 | 549 | 619 | EPZ36196.1 High mobility group (HMG) box domain-containing protein [Rozella allomycis CSF55] | diamond | 213 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30122937 | 30122937 | PRJNA1204310_P_NODE_3752_length_855_cov_18.191816_g3515_i0 | PRJNA1204310 | 3752 | 855 | 18.191816 | 155.5400268 | Fungi | 4751 | Fungi | Fungi | 356 | 9.15e-121 | NR | EPZ32691.1 | 988480 | g3515 | i0 | 66.1 | 12.5017543859649 | 251 | 85 | 88.1 | 0 | 20 | 772 | 1 | 251 | EPZ32691.1 40S ribosomal protein S4 [Rozella allomycis CSF55] | diamond | 10689 | 356 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31463257 | 31463257 | PRJNA1204310_P_NODE_22016_length_388_cov_1.339683_g21719_i0 | PRJNA1204310 | 22016 | 388 | 1.339683 | 5.19797004 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 104 | 1.24e-24 | NR | EPZ31899.1 | 988480 | g21719 | i0 | 34.1 | 0.951030927835051 | 123 | 75 | 90.5 | 1 | 35 | 385 | 44 | 166 | EPZ31899.1 hypothetical protein O9G_004722 [Rozella allomycis CSF55] | diamond | 369 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32570618 | 32570618 | PRJNA1204310_P_NODE_15739_length_449_cov_1.662234_g15442_i0 | PRJNA1204310 | 15739 | 449 | 1.662234 | 7.46343066 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 103 | 2.16e-25 | NR | PJF17674.1 | 1246581 | g15442 | i0 | 44.9 | 0.848552338530067 | 127 | 59 | 77.5 | 3 | 5 | 352 | 2 | 128 | PJF17674.1 hypothetical protein PSACC_02525 [Paramicrosporidium saccamoebae] | diamond | 381 | 103 | 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);;