contig_metadata
13 rows where bioproject = "PRJNA515078", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1761957 | 1761957 | PRJNA515078_P_NODE_10922_length_272_cov_1.161702_g10689_i0 | PRJNA515078 | 10922 | 272 | 1.161702 | 3.15982944 | Fungi | 4751 | Fungi | Fungi | 92.8 | 3.88e-22 | NR | KAI9221418.1 | 64508 | g10689 | i0 | 58.4 | 16.5441176470588 | 77 | 32 | 84.9 | 0 | 3 | 233 | 34 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 4500 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 6864507 | 6864507 | PRJNA515078_P_NODE_1126_length_910_cov_6.187858_g984_i0 | PRJNA515078 | 1126 | 910 | 6.187858 | 56.3095078 | Fungi | 4751 | Fungi | Fungi | 361 | 6.25e-122 | NR | KAI9223593.1 | 64508 | g984 | i0 | 65.2 | 13.4769230769231 | 296 | 100 | 97.6 | 1 | 905 | 18 | 3 | 295 | KAI9223593.1 hypothetical protein BC828DRAFT_403026 [Blastocladiella britannica] | diamond | 12264 | 363 | 0.994490358126722 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 7489017 | 7489017 | PRJNA515078_P_NODE_1746_length_736_cov_5.127325_g1568_i0 | PRJNA515078 | 1746 | 736 | 5.127325 | 37.737112 | Allomyces arbusculus | 64504 | Fungi | Fungi | 278 | 3.46e-91 | NR | KAJ3366916.1 | 64504 | g1568 | i0 | 73.3 | 0.778532608695652 | 191 | 51 | 77.9 | 0 | 7 | 579 | 1 | 191 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 573 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 10690575 | 10690575 | PRJNA515078_P_NODE_1749_length_735_cov_3.273639_g1571_i0 | PRJNA515078 | 1749 | 735 | 3.273639 | 24.06124665 | Allomyces arbusculus | 64504 | Fungi | Fungi | 245 | 3.76e-78 | NR | KAJ3366916.1 | 64504 | g1571 | i0 | 71.8 | 1.42857142857143 | 170 | 48 | 69.4 | 0 | 69 | 578 | 22 | 191 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 1050 | 245 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 26649239 | 26649239 | PRJNA515078_P_NODE_4421_length_457_cov_4.776190_g4189_i0 | PRJNA515078 | 4421 | 457 | 4.77619 | 21.8271883 | Fungi | 4751 | Fungi | Fungi | 145 | 2.08e-41 | NR | KAI9159512.1 | 1313167 | g4189 | i0 | 57 | 6.03938730853392 | 149 | 57 | 94.5 | 2 | 6 | 437 | 1 | 147 | KAI9159512.1 60S ribosomal protein L24 [Blastocladiella emersonii ATCC 22665] | diamond | 2760 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28371954 | 28371954 | PRJNA515078_P_NODE_28886_length_162_cov_1.560000_g28653_i0 | PRJNA515078 | 28886 | 162 | 1.56 | 2.5272 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 52 | 2.61e-6 | NR | KAI9183207.1 | 1313167 | g28653 | i0 | 47.5 | 0.740740740740741 | 40 | 21 | 74.1 | 0 | 39 | 158 | 127 | 166 | KAI9183207.1 hypothetical protein H9P43_004124 [Blastocladiella emersonii ATCC 22665] | diamond | 120 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28656330 | 28656330 | PRJNA515078_P_NODE_32087_length_155_cov_1.313559_g31854_i0 | PRJNA515078 | 32087 | 155 | 1.313559 | 2.03601645 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 77.8 | 4.88e-15 | NR | KAI9145646.1 | 1500003 | g31854 | i0 | 62 | 0.967741935483871 | 50 | 18 | 96.8 | 1 | 6 | 155 | 586 | 634 | KAI9145646.1 glycoside hydrolase superfamily [Paraphysoderma sedebokerense] | diamond | 150 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29161637 | 29161637 | PRJNA515078_P_NODE_20409_length_192_cov_1.490323_g20176_i0 | PRJNA515078 | 20409 | 192 | 1.490323 | 2.86142016 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 71.2 | 4.95e-13 | NR | KAI9179452.1 | 1313167 | g20176 | i0 | 48.3 | 0.9375 | 60 | 31 | 93.8 | 0 | 6 | 185 | 71 | 130 | KAI9179452.1 hypothetical protein H9P43_004775 [Blastocladiella emersonii ATCC 22665] | diamond | 180 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31103471 | 31103471 | PRJNA515078_P_NODE_6475_length_368_cov_2.429003_g6242_i0 | PRJNA515078 | 6475 | 368 | 2.429003 | 8.93873104 | Fungi | 4751 | Fungi | Fungi | 121 | 5.47e-33 | NR | KAI9183534.1 | 1313167 | g6242 | i0 | 56.7 | 2.35597826086957 | 97 | 42 | 79.1 | 0 | 60 | 350 | 14 | 110 | KAI9183534.1 Glutaredoxin [Blastocladiella emersonii ATCC 22665] | diamond | 867 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 32037087 | 32037087 | PRJNA515078_P_NODE_31938_length_155_cov_1.644068_g31705_i0 | PRJNA515078 | 31938 | 155 | 1.644068 | 2.5483054 | Blastocladiella britannica | 64508 | Fungi | Fungi | 56.2 | 1.93e-7 | NR | KAI9219926.1 | 64508 | g31705 | i0 | 71 | 2.34193548387097 | 31 | 9 | 60 | 0 | 3 | 95 | 456 | 486 | KAI9219926.1 actin family [Blastocladiella britannica] | diamond | 363 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32147434 | 32147434 | PRJNA515078_P_NODE_10698_length_275_cov_1.789916_g10465_i0 | PRJNA515078 | 10698 | 275 | 1.789916 | 4.922269 | Eukaryota | 2759 | Fungi | Fungi | 58.5 | 9.99e-8 | NR | KNE60834.1 | 578462 | g10465 | i0 | 35.2 | 4.62545454545455 | 88 | 50 | 93.8 | 3 | 2 | 259 | 175 | 257 | KNE60834.1 hypothetical protein AMAG_06600 [Allomyces macrogynus ATCC 38327] | diamond | 1272 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32195293 | 32195293 | PRJNA515078_P_NODE_33098_length_153_cov_1.043103_g32865_i0 | PRJNA515078 | 33098 | 153 | 1.043103 | 1.59594759 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 42.7 | 0.0114 | NR | KNE57986.1 | 578462 | g32865 | i0 | 45 | 1.45098039215686 | 40 | 22 | 78.4 | 0 | 144 | 25 | 422 | 461 | KNE57986.1 hypothetical protein AMAG_18362 [Allomyces macrogynus ATCC 38327] | diamond | 222 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32747657 | 32747657 | PRJNA515078_P_NODE_20000_length_194_cov_1.484076_g19767_i0 | PRJNA515078 | 20000 | 194 | 1.484076 | 2.87910744 | Eukaryota | 2759 | Fungi | Fungi | 60.5 | 1.06e-8 | NR | KAI9221620.1 | 64508 | g19767 | i0 | 51.7 | 1.91752577319588 | 58 | 28 | 89.7 | 0 | 2 | 175 | 315 | 372 | KAI9221620.1 hypothetical protein BC828DRAFT_380556 [Blastocladiella britannica] | diamond | 372 | 60.5 | 1 | 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);;