contig_metadata
14 rows where bioproject = "PRJNA1136505", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14313448 | 14313448 | PRJNA1136505_P_NODE_38592_length_549_cov_4.136555_g31756_i0 | PRJNA1136505 | 38592 | 549 | 4.136555 | 22.70968695 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 147 | 9.739999999999998e-42 | NR | KAI9142917.1 | 1500003 | g31756 | i0 | 63.6 | 1.9672131147541 | 118 | 43 | 64.5 | 0 | 523 | 170 | 1 | 118 | KAI9142917.1 ribosomal protein L24e-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1080 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 14313452 | 14313452 | PRJNA1136505_P_NODE_45192_length_479_cov_4.253695_g38333_i0 | PRJNA1136505 | 45192 | 479 | 4.253695 | 20.37519905 | Eukaryota | 2759 | Fungi | Fungi | 174 | 2.1e-52 | NR | KAI9222637.1 | 64508 | g38333 | i0 | 56.3 | 12.8455114822547 | 158 | 68 | 98.3 | 1 | 472 | 2 | 1 | 158 | KAI9222637.1 60S ribosomal protein L21-A [Blastocladiella britannica] | diamond | 6153 | 175 | 0.994285714285714 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 21961297 | 21961297 | PRJNA1136505_P_NODE_71698_length_348_cov_1.312727_g64838_i0 | PRJNA1136505 | 71698 | 348 | 1.312727 | 4.56828996 | Eukaryota | 2759 | Fungi | Fungi | 200 | 2.19e-60 | NR | KAI9141171.1 | 1500003 | g64838 | i0 | 87 | 9.91379310344828 | 115 | 14 | 99.1 | 1 | 3 | 347 | 125 | 238 | KAI9141171.1 actin2 [Paraphysoderma sedebokerense] | diamond | 3450 | 202 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26943708 | 26943708 | PRJNA1136505_P_NODE_53102_length_424_cov_1.096866_g46243_i0 | PRJNA1136505 | 53102 | 424 | 1.096866 | 4.65071184 | Blastocladiella britannica | 64508 | Fungi | Fungi | 135 | 1.39e-35 | NR | KAI9221836.1 | 64508 | g46243 | i0 | 52.3 | 2.85849056603774 | 132 | 62 | 92.7 | 1 | 407 | 15 | 26 | 157 | KAI9221836.1 mitochondrial carrier domain-containing protein [Blastocladiella britannica] | diamond | 1212 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26975421 | 26975421 | PRJNA1136505_P_NODE_90462_length_304_cov_2.662338_g83602_i0 | PRJNA1136505 | 90462 | 304 | 2.662338 | 8.09350752 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 80.5 | 1.76e-15 | NR | KAI9183268.1 | 1313167 | g83602 | i0 | 59.1 | 0.651315789473684 | 66 | 27 | 65.1 | 0 | 1 | 198 | 212 | 277 | KAI9183268.1 ribosomal protein P0 (A0) (L10E) [Blastocladiella emersonii ATCC 22665] | diamond | 198 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27133208 | 27133208 | PRJNA1136505_P_NODE_138542_length_248_cov_0.880000_g131682_i0 | PRJNA1136505 | 138542 | 248 | 0.88 | 2.1824 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 136 | 8.270000000000001e-36 | NR | KAI9142446.1 | 1500003 | g131682 | i0 | 79.3 | 2.9758064516129 | 82 | 17 | 99.2 | 0 | 3 | 248 | 164 | 245 | KAI9142446.1 nicotinate phosphoribosyltransferase family-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 738 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28617983 | 28617983 | PRJNA1136505_P_NODE_104307_length_283_cov_0.804762_g97447_i0 | PRJNA1136505 | 104307 | 283 | 0.804762 | 2.27747646 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 107 | 4.93e-26 | NR | KNE64597.1 | 578462 | g97447 | i0 | 53.2 | 0.996466431095406 | 94 | 41 | 96.5 | 1 | 2 | 274 | 97 | 190 | KNE64597.1 hypothetical protein AMAG_09954 [Allomyces macrogynus ATCC 38327] | diamond | 282 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28933627 | 28933627 | PRJNA1136505_P_NODE_107708_length_278_cov_1.502439_g100848_i0 | PRJNA1136505 | 107708 | 278 | 1.502439 | 4.17678042 | Blastocladiella britannica | 64508 | Fungi | Fungi | 58.5 | 1.53e-7 | NR | KAI9223875.1 | 64508 | g100848 | i0 | 35.6 | 0.971223021582734 | 90 | 46 | 93.9 | 4 | 3 | 263 | 115 | 195 | KAI9223875.1 fatty acid desaturase-domain-containing protein [Blastocladiella britannica] | diamond | 270 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29901581 | 29901581 | PRJNA1136505_P_NODE_65691_length_367_cov_1.918367_g58831_i0 | PRJNA1136505 | 65691 | 367 | 1.918367 | 7.04040689 | Blastocladiomycota | 451459 | Fungi | Fungi | 168 | 1.1e-49 | NR | KAJ3374183.1 | 64504 | g58831 | i0 | 69.4 | 5.91008174386921 | 121 | 36 | 98.1 | 1 | 365 | 6 | 53 | 173 | KAJ3374183.1 adenylate kinase [Allomyces arbusculus] | diamond | 2169 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30638948 | 30638948 | PRJNA1136505_P_NODE_115773_length_268_cov_1.312821_g108913_i0 | PRJNA1136505 | 115773 | 268 | 1.312821 | 3.51836028 | Blastocladiella britannica | 64508 | Fungi | Fungi | 61.2 | 1.49e-8 | NR | KAI9221605.1 | 64508 | g108913 | i0 | 35.8 | 0.906716417910448 | 81 | 43 | 90.7 | 2 | 267 | 25 | 160 | 231 | KAI9221605.1 hypothetical protein BC828DRAFT_366082 [Blastocladiella britannica] | diamond | 243 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 30860284 | 30860284 | PRJNA1136505_P_NODE_94154_length_298_cov_1.026667_g87294_i0 | PRJNA1136505 | 94154 | 298 | 1.026667 | 3.05946766 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 95.5 | 2.01e-20 | NR | KAI9146266.1 | 1500003 | g87294 | i0 | 49.5 | 1.96308724832215 | 97 | 49 | 97.7 | 0 | 293 | 3 | 224 | 320 | KAI9146266.1 hypothetical protein BKA69DRAFT_1162856 [Paraphysoderma sedebokerense] | diamond | 585 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31713875 | 31713875 | PRJNA1136505_P_NODE_68177_length_359_cov_0.741259_g61317_i0 | PRJNA1136505 | 68177 | 359 | 0.741259 | 2.66111981 | Blastocladiella britannica | 64508 | Fungi | Fungi | 157 | 1.05e-44 | NR | KAI9222449.1 | 64508 | g61317 | i0 | 65.6 | 9.04178272980501 | 122 | 39 | 99.4 | 1 | 359 | 3 | 50 | 171 | KAI9222449.1 nicotinate-nucleotide pyrophosphorylase [Blastocladiella britannica] | diamond | 3246 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32630867 | 32630867 | PRJNA1136505_P_NODE_113100_length_271_cov_1.555556_g106240_i0 | PRJNA1136505 | 113100 | 271 | 1.555556 | 4.21555676 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 145 | 2.32e-40 | NR | ORZ38374.1 | 765915 | g106240 | i0 | 76.7 | 0.996309963099631 | 90 | 21 | 99.6 | 0 | 1 | 270 | 108 | 197 | ORZ38374.1 translation initiation factor eIF2 alpha subunit, partial [Catenaria anguillulae PL171] | diamond | 270 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32757038 | 32757038 | PRJNA1136505_P_NODE_78180_length_331_cov_1.697674_g71320_i0 | PRJNA1136505 | 78180 | 331 | 1.697674 | 5.61930094 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 60.1 | 7.19e-8 | NR | KAI9137479.1 | 1500003 | g71320 | i0 | 39.8 | 1.02416918429003 | 113 | 56 | 98.8 | 5 | 329 | 3 | 6 | 110 | KAI9137479.1 hypothetical protein BKA69DRAFT_891079 [Paraphysoderma sedebokerense] | diamond | 339 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;