contig_metadata
9 rows where bioproject = "PRJNA911178", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2166900 | 2166900 | PRJNA911178_P_NODE_13402_length_914_cov_5.804994_g11537_i0 | PRJNA911178 | 13402 | 914 | 5.804994 | 53.05764516 | Fungi | 4751 | Fungi | Fungi | 360 | 1.36e-121 | NR | KAI9223593.1 | 64508 | g11537 | i0 | 66.2 | 13.3588621444201 | 290 | 95 | 95.2 | 1 | 880 | 11 | 1 | 287 | KAI9223593.1 hypothetical protein BC828DRAFT_403026 [Blastocladiella britannica] | diamond | 12210 | 362 | 0.994475138121547 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 6354066 | 6354066 | PRJNA911178_P_NODE_22565_length_709_cov_2.748428_g20316_i0 | PRJNA911178 | 22565 | 709 | 2.748428 | 19.48635452 | Allomyces arbusculus | 64504 | Fungi | Fungi | 285 | 4.54e-94 | NR | KAJ3366916.1 | 64504 | g20316 | i0 | 67.7 | 0.943582510578279 | 223 | 72 | 94.4 | 0 | 672 | 4 | 1 | 223 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 669 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 14004365 | 14004365 | PRJNA911178_P_NODE_295631_length_240_cov_2.706587_g293157_i0 | PRJNA911178 | 295631 | 240 | 2.706587 | 6.4958088 | Fungi | 4751 | Fungi | Fungi | 127 | 8.9e-33 | NR | KAI9222482.1 | 64508 | g293157 | i0 | 76.9 | 7.8 | 78 | 18 | 97.5 | 0 | 3 | 236 | 194 | 271 | KAI9222482.1 P-loop containing nucleoside triphosphate hydrolase protein [Blastocladiella britannica] | diamond | 1872 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 20017809 | 20017809 | PRJNA911178_P_NODE_101736_length_358_cov_4.726316_g99266_i0 | PRJNA911178 | 101736 | 358 | 4.726316 | 16.92021128 | Eukaryota | 2759 | Fungi | Fungi | 171 | 8.09e-51 | NR | KAJ3366916.1 | 64504 | g99266 | i0 | 71.8 | 10.8519553072626 | 117 | 33 | 98 | 0 | 7 | 357 | 31 | 147 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 3885 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 27182329 | 27182329 | PRJNA911178_P_NODE_300042_length_234_cov_2.503106_g297568_i0 | PRJNA911178 | 300042 | 234 | 2.503106 | 5.85726804 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 46.2 | 0.00199 | NR | KNE56158.1 | 578462 | g297568 | i0 | 42.1 | 0.730769230769231 | 57 | 32 | 71.8 | 1 | 170 | 3 | 773 | 829 | KNE56158.1 hypothetical protein AMAG_01993 [Allomyces macrogynus ATCC 38327] | diamond | 171 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29866558 | 29866558 | PRJNA911178_P_NODE_122991_length_331_cov_2.352713_g120519_i0 | PRJNA911178 | 122991 | 331 | 2.352713 | 7.78748003 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 104 | 9.35e-26 | NR | ORZ37379.1 | 765915 | g120519 | i0 | 69.2 | 2.82779456193353 | 78 | 24 | 70.7 | 0 | 2 | 235 | 28 | 105 | ORZ37379.1 ribosomal protein L24e-domain-containing protein [Catenaria anguillulae PL171] | diamond | 936 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30624669 | 30624669 | PRJNA911178_P_NODE_245693_length_250_cov_0.870056_g243219_i0 | PRJNA911178 | 245693 | 250 | 0.870056 | 2.17514 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 106 | 6.6e-28 | NR | KAI9140276.1 | 1500003 | g243219 | i0 | 71.4 | 1.728 | 70 | 20 | 84 | 0 | 230 | 21 | 17 | 86 | KAI9140276.1 hypothetical protein BKA69DRAFT_1081169 [Paraphysoderma sedebokerense] | diamond | 432 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31130004 | 31130004 | PRJNA911178_P_NODE_286415_length_242_cov_1.236686_g283941_i0 | PRJNA911178 | 286415 | 242 | 1.236686 | 2.99278012 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 43.1 | 0.0263 | NR | ORZ31498.1 | 765915 | g283941 | i0 | 47.7 | 0.545454545454545 | 44 | 22 | 53.3 | 1 | 90 | 218 | 276 | 319 | ORZ31498.1 hypothetical protein BCR44DRAFT_1265621 [Catenaria anguillulae PL171] | diamond | 132 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 31224985 | 31224985 | PRJNA911178_P_NODE_187855_length_278_cov_2.434146_g185382_i0 | PRJNA911178 | 187855 | 278 | 2.434146 | 6.76692588 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 44.7 | 0.00772 | NR | KAI9143205.1 | 1500003 | g185382 | i0 | 36.4 | 0.830935251798561 | 77 | 38 | 73.4 | 2 | 270 | 67 | 16 | 90 | KAI9143205.1 hypothetical protein BKA69DRAFT_160388 [Paraphysoderma sedebokerense] | diamond | 231 | 44.7 | 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);;