contig_metadata
15 rows where bioproject = "PRJNA1118794", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1024903 | 1024903 | PRJNA1118794_P_NODE_35741_length_278_cov_1.414634_g34991_i0 | PRJNA1118794 | 35741 | 278 | 1.414634 | 3.93268252 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 112 | 1.32e-26 | NR | KAI9144437.1 | 1500003 | g34991 | i0 | 57.6 | 0.992805755395683 | 92 | 38 | 99.3 | 1 | 2 | 277 | 255 | 345 | KAI9144437.1 hypothetical protein BKA69DRAFT_1112327 [Paraphysoderma sedebokerense] | diamond | 276 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 12984920 | 12984920 | PRJNA1118794_P_NODE_74451_length_241_cov_0.916667_g73701_i0 | PRJNA1118794 | 74451 | 241 | 0.916667 | 2.20916747 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 152 | 8.43e-44 | NR | KAI9144984.1 | 1500003 | g73701 | i0 | 83.8 | 2.98755186721992 | 80 | 13 | 99.6 | 0 | 240 | 1 | 99 | 178 | KAI9144984.1 kinase-like domain-containing protein, partial [Paraphysoderma sedebokerense] | diamond | 720 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 23182780 | 23182780 | PRJNA1118794_P_NODE_2659_length_895_cov_20.565693_g2013_i0 | PRJNA1118794 | 2659 | 895 | 20.565693 | 184.06295235 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 363 | 3.67e-95 | NTclustered | gi|1866582656|gb|MT730831.1| | 1500003 | g2013 | i0 | 76.685 | 80.1620111731844 | 712 | 130 | 79 | 26 | 1 | 704 | 3743 | 4426 | Paraphysoderma sedebokerense isolate JEL0821 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 71745 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 25251328 | 25251328 | PRJNA1118794_P_NODE_58540_length_247_cov_0.885057_g57790_i0 | PRJNA1118794 | 58540 | 247 | 0.885057 | 2.18609079 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 151 | 2.12e-40 | NR | KAJ1508329.1 | 945690 | g57790 | i0 | 85.4 | 5.97570850202429 | 82 | 12 | 99.6 | 0 | 247 | 2 | 1139 | 1220 | KAJ1508329.1 Splicing factor 3B subunit 1 [Coelomomyces lativittatus] | diamond | 1476 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26751200 | 26751200 | PRJNA1118794_P_NODE_55861_length_248_cov_0.880000_g55111_i0 | PRJNA1118794 | 55861 | 248 | 0.88 | 2.1824 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 75.9 | 7.45e-14 | NR | KAI9143955.1 | 1500003 | g55111 | i0 | 65.5 | 3.18145161290323 | 55 | 19 | 66.5 | 0 | 166 | 2 | 1 | 55 | KAI9143955.1 eukaryotic translation initiation factor 5 [Paraphysoderma sedebokerense] | diamond | 789 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27722900 | 27722900 | PRJNA1118794_P_NODE_63124_length_245_cov_0.895349_g62374_i0 | PRJNA1118794 | 63124 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | Fungi | Fungi | 87.8 | 3.02e-18 | NR | KAI9224609.1 | 64508 | g62374 | i0 | 57.1 | 2.73061224489796 | 56 | 24 | 68.6 | 0 | 3 | 170 | 326 | 381 | KAI9224609.1 kinase-like domain-containing protein [Blastocladiella britannica] | diamond | 669 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28489297 | 28489297 | PRJNA1118794_P_NODE_62327_length_245_cov_1.656977_g61577_i0 | PRJNA1118794 | 62327 | 245 | 1.656977 | 4.05959365 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 62.4 | 6.02e-10 | NR | KAI9137739.1 | 1500003 | g61577 | i0 | 51.5 | 0.808163265306122 | 66 | 31 | 79.6 | 1 | 195 | 1 | 1 | 66 | KAI9137739.1 hypothetical protein BKA69DRAFT_1095925 [Paraphysoderma sedebokerense] | diamond | 198 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29593949 | 29593949 | PRJNA1118794_P_NODE_36310_length_277_cov_1.049020_g35560_i0 | PRJNA1118794 | 36310 | 277 | 1.04902 | 2.9057854 | Blastocladiella britannica | 64508 | Fungi | Fungi | 143 | 6.87e-38 | NR | KAI9224928.1 | 64508 | g35560 | i0 | 72.5 | 7.94945848375451 | 91 | 25 | 98.6 | 0 | 277 | 5 | 57 | 147 | KAI9224928.1 isocitrate lyase [Blastocladiella britannica] | diamond | 2202 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29751958 | 29751958 | PRJNA1118794_P_NODE_63771_length_245_cov_0.895349_g63021_i0 | PRJNA1118794 | 63771 | 245 | 0.895349 | 2.19360505 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 43.1 | 0.00748 | NR | KAJ1498502.1 | 945690 | g63021 | i0 | 57.6 | 0.771428571428571 | 33 | 14 | 40.4 | 0 | 243 | 145 | 22 | 54 | KAJ1498502.1 hypothetical protein HMI54_012623 [Coelomomyces lativittatus] | diamond | 189 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30130896 | 30130896 | PRJNA1118794_P_NODE_48332_length_251_cov_1.685393_g47582_i0 | PRJNA1118794 | 48332 | 251 | 1.685393 | 4.23033643 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 94.4 | 1.44e-22 | NR | KNE68415.1 | 578462 | g47582 | i0 | 50.6 | 1.9840637450199201 | 83 | 41 | 99.2 | 0 | 251 | 3 | 42 | 124 | KNE68415.1 hypothetical protein AMAG_13070 [Allomyces macrogynus ATCC 38327] | diamond | 498 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30225995 | 30225995 | PRJNA1118794_P_NODE_56632_length_248_cov_0.880000_g55882_i0 | PRJNA1118794 | 56632 | 248 | 0.88 | 2.1824 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 106 | 1.1399999999999999e-24 | NR | KAI9145401.1 | 1500003 | g55882 | i0 | 60 | 1.94758064516129 | 80 | 32 | 96.8 | 0 | 243 | 4 | 195 | 274 | KAI9145401.1 hypothetical protein BKA69DRAFT_1035505 [Paraphysoderma sedebokerense] | diamond | 483 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31015911 | 31015911 | PRJNA1118794_P_NODE_66175_length_244_cov_0.900585_g65425_i0 | PRJNA1118794 | 66175 | 244 | 0.900585 | 2.1974274 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 44.7 | 0.00806 | NR | KAJ1509204.1 | 945690 | g65425 | i0 | 50 | 1.48770491803279 | 46 | 20 | 56.6 | 1 | 237 | 100 | 129 | 171 | KAJ1509204.1 hypothetical protein HMI55_000068 [Coelomomyces lativittatus] | diamond | 363 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 31576146 | 31576146 | PRJNA1118794_P_NODE_15856_length_368_cov_2.244068_g15106_i0 | PRJNA1118794 | 15856 | 368 | 2.244068 | 8.25817024 | Fungi | 4751 | Fungi | Fungi | 121 | 7.54e-33 | NR | KAI9221418.1 | 64508 | g15106 | i0 | 58.8 | 4.7445652173913 | 97 | 40 | 79.1 | 0 | 346 | 56 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31734017 | 31734017 | PRJNA1118794_P_NODE_14537_length_381_cov_1.237013_g13787_i0 | PRJNA1118794 | 14537 | 381 | 1.237013 | 4.71301953 | Fungi | 4751 | Fungi | Fungi | 141 | 2.56e-37 | NR | KNE70839.1 | 578462 | g13787 | i0 | 69.7 | 6.48818897637795 | 99 | 30 | 78 | 0 | 83 | 379 | 40 | 138 | KNE70839.1 glutaryl-CoA dehydrogenase, mitochondrial [Allomyces macrogynus ATCC 38327] | diamond | 2472 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32754727 | 32754727 | PRJNA1118794_P_NODE_18500_length_348_cov_1.400000_g17750_i0 | PRJNA1118794 | 18500 | 348 | 1.4 | 4.872 | Allomyces arbusculus | 64504 | Fungi | Fungi | 152 | 3.93e-45 | NR | KAJ3373363.1 | 64504 | g17750 | i0 | 70.6 | 4.37931034482759 | 102 | 30 | 87.9 | 0 | 4 | 309 | 32 | 133 | KAJ3373363.1 60S ribosomal protein L32 [Allomyces arbusculus] | diamond | 1524 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus |
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);;