contig_metadata
10 rows where bioproject = "PRJNA1174234", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5419092 | 5419092 | PRJNA1174234_P_NODE_10045_length_435_cov_1.486188_g9849_i0 | PRJNA1174234 | 10045 | 435 | 1.486188 | 6.4649178 | Fungi | 4751 | Fungi | Fungi | 180 | 1.74e-54 | NR | KAI9145380.1 | 1500003 | g9849 | i0 | 66.9 | 4.00689655172414 | 145 | 44 | 100 | 1 | 1 | 435 | 69 | 209 | KAI9145380.1 ribosomal protein L6e-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1743 | 181 | 0.994475138121547 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 6694036 | 6694036 | PRJNA1174234_P_NODE_21826_length_295_cov_2.693694_g21630_i0 | PRJNA1174234 | 21826 | 295 | 2.693694 | 7.9463973 | Fungi | 4751 | Fungi | Fungi | 110 | 1.8e-29 | NR | NP_043745.1 | 28583 | g21630 | i0 | 80.8 | 2.94915254237288 | 73 | 14 | 74.2 | 0 | 287 | 69 | 2 | 74 | NP_043745.1 H(+)-transporting ATPase, F0 subunit 9 [Allomyces macrogynus] | diamond | 870 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 16893208 | 16893208 | PRJNA1174234_P_NODE_26074_length_268_cov_2.030769_g25878_i0 | PRJNA1174234 | 26074 | 268 | 2.030769 | 5.44246092 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 140 | 2.83e-41 | NR | KNE59758.1 | 578462 | g25878 | i0 | 80.5 | 4.61194029850746 | 82 | 16 | 91.8 | 0 | 23 | 268 | 1 | 82 | KNE59758.1 60S ribosomal protein L37a [Allomyces macrogynus ATCC 38327] | diamond | 1236 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 21992708 | 21992708 | PRJNA1174234_P_NODE_20458_length_305_cov_1.637931_g20262_i0 | PRJNA1174234 | 20458 | 305 | 1.637931 | 4.99568955 | Opisthokonta | 33154 | Fungi | Fungi | 127 | 1.76e-34 | NR | KAI9216776.1 | 64508 | g20262 | i0 | 65.3 | 11.0655737704918 | 101 | 34 | 99.3 | 1 | 303 | 1 | 89 | 188 | KAI9216776.1 ribosomal protein S8e/ribosomal biogenesis NSA2 [Blastocladiella britannica] | diamond | 3375 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27356789 | 27356789 | PRJNA1174234_P_NODE_25263_length_273_cov_1.525000_g25067_i0 | PRJNA1174234 | 25263 | 273 | 1.525 | 4.16325 | Blastocladiella britannica | 64508 | Fungi | Fungi | 119 | 3.91e-29 | NR | KAI9221452.1 | 64508 | g25067 | i0 | 62.2 | 0.989010989010989 | 90 | 34 | 98.9 | 0 | 2 | 271 | 394 | 483 | KAI9221452.1 chaperonin Cpn60/TCP-1 family [Blastocladiella britannica] | diamond | 270 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29282475 | 29282475 | PRJNA1174234_P_NODE_18849_length_318_cov_1.057143_g18653_i0 | PRJNA1174234 | 18849 | 318 | 1.057143 | 3.36171474 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 75.5 | 4.36e-15 | NR | KAI9140871.1 | 1500003 | g18653 | i0 | 60 | 0.566037735849057 | 60 | 24 | 56.6 | 0 | 314 | 135 | 22 | 81 | KAI9140871.1 high mobility group box domain-containing protein [Paraphysoderma sedebokerense] | diamond | 180 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29365088 | 29365088 | PRJNA1174234_P_NODE_24649_length_277_cov_1.446078_g24453_i0 | PRJNA1174234 | 24649 | 277 | 1.446078 | 4.00563606 | Fungi | 4751 | Fungi | Fungi | 84.3 | 1.63e-18 | NR | ORZ39709.1 | 765915 | g24453 | i0 | 48.3 | 4.64620938628159 | 87 | 45 | 94.2 | 0 | 261 | 1 | 6 | 92 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 1287 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29471803 | 29471803 | PRJNA1174234_P_NODE_14950_length_356_cov_4.625442_g14754_i0 | PRJNA1174234 | 14950 | 356 | 4.625442 | 16.46657352 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 75.1 | 2.4e-14 | NR | ORZ39441.1 | 765915 | g14754 | i0 | 57.8 | 3.0252808988764 | 64 | 27 | 53.9 | 0 | 82 | 273 | 60 | 123 | ORZ39441.1 high mobility group box domain-containing protein [Catenaria anguillulae PL171] | diamond | 1077 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30944551 | 30944551 | PRJNA1174234_P_NODE_17414_length_330_cov_1.797665_g17218_i0 | PRJNA1174234 | 17414 | 330 | 1.797665 | 5.9322945 | Eukaryota | 2759 | Fungi | Fungi | 63.2 | 9.6e-10 | NR | KAI9218065.1 | 64508 | g17218 | i0 | 48.2 | 5.10909090909091 | 56 | 29 | 50.9 | 0 | 252 | 85 | 5 | 60 | KAI9218065.1 40S ribosomal protein S17-like protein [Blastocladiella britannica] | diamond | 1686 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31513703 | 31513703 | PRJNA1174234_P_NODE_14176_length_365_cov_10.359589_g13980_i0 | PRJNA1174234 | 14176 | 365 | 10.359589 | 37.81249985 | Fungi | 4751 | Fungi | Fungi | 121 | 5.12e-33 | NR | KAI9221418.1 | 64508 | g13980 | i0 | 59.8 | 4.78356164383562 | 97 | 39 | 79.7 | 0 | 338 | 48 | 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 |
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);;