contig_metadata
14 rows where bioproject = "PRJNA1000943", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2695347 | 2695347 | PRJNA1000943_P_NODE_3123_length_437_cov_1.714286_g2986_i0 | PRJNA1000943 | 3123 | 437 | 1.714286 | 7.49142982 | Eukaryota | 2759 | Fungi | Fungi | 207 | 9.43e-63 | NR | KAJ1507281.1 | 945690 | g2986 | i0 | 71.4 | 8.27231121281465 | 133 | 38 | 91.3 | 0 | 13 | 411 | 1 | 133 | KAJ1507281.1 60S ribosomal protein L3 [Coelomomyces lativittatus] | diamond | 3615 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 3971439 | 3971439 | PRJNA1000943_P_NODE_2504_length_483_cov_3.036585_g2367_i0 | PRJNA1000943 | 2504 | 483 | 3.036585 | 14.66670555 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 209 | 1.26e-66 | NR | KAJ1500207.1 | 945690 | g2367 | i0 | 67.8 | 6.46583850931677 | 149 | 48 | 92.5 | 0 | 25 | 471 | 4 | 152 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 3123 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 11623783 | 11623783 | PRJNA1000943_P_NODE_810_length_819_cov_2.735925_g696_i0 | PRJNA1000943 | 810 | 819 | 2.735925 | 22.40722575 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 267 | 5.11e-86 | NR | KAI9142824.1 | 1500003 | g696 | i0 | 60.2 | 4.49084249084249 | 246 | 78 | 88.6 | 2 | 807 | 82 | 30 | 259 | KAI9142824.1 50S ribosomal protein L30e-like protein [Paraphysoderma sedebokerense] | diamond | 3678 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 15447919 | 15447919 | PRJNA1000943_P_NODE_9073_length_276_cov_1.793103_g8935_i0 | PRJNA1000943 | 9073 | 276 | 1.793103 | 4.94896428 | Eukaryota | 2759 | Fungi | Fungi | 145 | 4.3399999999999996e-42 | NR | KAJ3348302.1 | 64505 | g8935 | i0 | 77.5 | 58.0326086956522 | 89 | 20 | 96.7 | 0 | 269 | 3 | 74 | 162 | KAJ3348302.1 ribosomal protein S15 [Allomyces javanicus] | diamond | 16017 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 19270706 | 19270706 | PRJNA1000943_P_NODE_2996_length_446_cov_4.932976_g2859_i0 | PRJNA1000943 | 2996 | 446 | 4.932976 | 22.00107296 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 200 | 1.77e-62 | NR | KAI9189827.1 | 1313167 | g2859 | i0 | 68.5 | 18.390134529148 | 143 | 43 | 94.8 | 1 | 16 | 438 | 52 | 194 | KAI9189827.1 ribosomal 40S subunit protein S13 [Blastocladiella emersonii ATCC 22665] | diamond | 8202 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 21822025 | 21822025 | PRJNA1000943_P_NODE_6538_length_318_cov_1.273469_g6400_i0 | PRJNA1000943 | 6538 | 318 | 1.273469 | 4.04963142 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 191 | 4.22e-58 | NR | KAJ1497899.1 | 945690 | g6400 | i0 | 79.2 | 8 | 106 | 22 | 100 | 0 | 1 | 318 | 198 | 303 | KAJ1497899.1 guanine nucleotide-binding protein subunit beta 1 [Coelomomyces lativittatus] | diamond | 2544 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26970944 | 26970944 | PRJNA1000943_P_NODE_13582_length_246_cov_1.803468_g13444_i0 | PRJNA1000943 | 13582 | 246 | 1.803468 | 4.43653128 | Allomyces arbusculus | 64504 | Fungi | Fungi | 65.9 | 2.79e-10 | NR | KAJ3369301.1 | 64504 | g13444 | i0 | 56 | 3.97560975609756 | 50 | 22 | 61 | 0 | 97 | 246 | 1 | 50 | KAJ3369301.1 hypothetical protein GGF31_005401 [Allomyces arbusculus] | diamond | 978 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 27879866 | 27879866 | PRJNA1000943_P_NODE_15065_length_243_cov_0.917647_g14927_i0 | PRJNA1000943 | 15065 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | Fungi | Fungi | 101 | 5.75e-23 | NR | KAI9216931.1 | 64508 | g14927 | i0 | 62.5 | 3.97530864197531 | 80 | 28 | 98.8 | 1 | 243 | 4 | 246 | 323 | KAI9216931.1 nicotinate phosphoribosyltransferase family-domain-containing protein [Blastocladiella britannica] | diamond | 966 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28164094 | 28164094 | PRJNA1000943_P_NODE_6385_length_321_cov_1.572581_g6247_i0 | PRJNA1000943 | 6385 | 321 | 1.572581 | 5.04798501 | Eukaryota | 2759 | Fungi | Fungi | 123 | 4.3199999999999995e-30 | NR | KAI9164315.1 | 1313167 | g6247 | i0 | 54.1 | 3.05607476635514 | 109 | 46 | 98.1 | 2 | 1 | 315 | 373 | 481 | KAI9164315.1 fimbrin [Blastocladiella emersonii ATCC 22665] | diamond | 981 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28202746 | 28202746 | PRJNA1000943_P_NODE_12886_length_248_cov_0.891429_g12748_i0 | PRJNA1000943 | 12886 | 248 | 0.891429 | 2.21074392 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 108 | 2.71e-25 | NR | KAI9140729.1 | 1500003 | g12748 | i0 | 62.7 | 3.01209677419355 | 83 | 30 | 99.2 | 1 | 2 | 247 | 201 | 283 | KAI9140729.1 acyl-CoA dehydrogenase/oxidase [Paraphysoderma sedebokerense] | diamond | 747 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28543139 | 28543139 | PRJNA1000943_P_NODE_4647_length_367_cov_3.880952_g4510_i0 | PRJNA1000943 | 4647 | 367 | 3.880952 | 14.24309384 | Fungi | 4751 | Fungi | Fungi | 135 | 7.34e-38 | NR | KNE57691.1 | 578462 | g4510 | i0 | 61.9 | 14.6811989100817 | 118 | 43 | 96.5 | 1 | 366 | 13 | 37 | 152 | KNE57691.1 60S ribosomal protein [Allomyces macrogynus ATCC 38327] | diamond | 5388 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30223872 | 30223872 | PRJNA1000943_P_NODE_4592_length_369_cov_3.918919_g4455_i0 | PRJNA1000943 | 4592 | 369 | 3.918919 | 14.46081111 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 188 | 8.719999999999999e-57 | NR | KAJ1509686.1 | 945690 | g4455 | i0 | 83 | 2.73170731707317 | 112 | 18 | 90.2 | 1 | 1 | 333 | 202 | 313 | KAJ1509686.1 hypothetical protein HMI54_002183 [Coelomomyces lativittatus] | diamond | 1008 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30761160 | 30761160 | PRJNA1000943_P_NODE_1894_length_550_cov_4.972746_g1758_i0 | PRJNA1000943 | 1894 | 550 | 4.972746 | 27.350103 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 267 | 1.3299999999999993e-87 | NR | KAJ1508796.1 | 945690 | g1758 | i0 | 69.5 | 23.2527272727273 | 177 | 54 | 96.5 | 0 | 533 | 3 | 1 | 177 | KAJ1508796.1 60S ribosomal protein L8 [Coelomomyces lativittatus] | diamond | 12789 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 31955049 | 31955049 | PRJNA1000943_P_NODE_9277_length_273_cov_1.945000_g9139_i0 | PRJNA1000943 | 9277 | 273 | 1.945 | 5.30985 | Fungi | 4751 | Fungi | Fungi | 94.4 | 1.75e-22 | NR | ORZ39709.1 | 765915 | g9139 | i0 | 47.8 | 4.94505494505495 | 90 | 47 | 98.9 | 0 | 3 | 272 | 6 | 95 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1350 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;