contig_metadata
6 rows where bioproject = "PRJNA896554", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8522331 | 8522331 | PRJNA896554_P_NODE_108587_length_312_cov_1.288703_g101047_i0 | PRJNA896554 | 108587 | 312 | 1.288703 | 4.02075336 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 125 | 8.210000000000001e-33 | NR | KAI9140992.1 | 1500003 | g101047 | i0 | 60.2 | 10.2019230769231 | 108 | 38 | 99 | 2 | 309 | 1 | 12 | 119 | KAI9140992.1 hypothetical protein BKA69DRAFT_1076612 [Paraphysoderma sedebokerense] | diamond | 3183 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 15271734 | 15271734 | PRJNA896554_P_NODE_50052_length_670_cov_2.319933_g42640_i0 | PRJNA896554 | 50052 | 670 | 2.319933 | 15.5435511 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 299 | 5.98e-100 | NR | KNE68240.1 | 578462 | g42640 | i0 | 72.6 | 8.42686567164179 | 208 | 56 | 93.1 | 1 | 661 | 38 | 10 | 216 | KNE68240.1 60S ribosomal protein L1-B [Allomyces macrogynus ATCC 38327] | diamond | 5646 | 299 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 21271670 | 21271670 | PRJNA896554_P_NODE_119357_length_292_cov_1.406393_g111817_i0 | PRJNA896554 | 119357 | 292 | 1.406393 | 4.10666756 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 149 | 2.45e-39 | NR | KAI9142193.1 | 1500003 | g111817 | i0 | 71.9 | 2.95890410958904 | 96 | 27 | 98.6 | 0 | 290 | 3 | 386 | 481 | KAI9142193.1 P-loop containing nucleoside triphosphate hydrolase protein [Paraphysoderma sedebokerense] | diamond | 864 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26960550 | 26960550 | PRJNA896554_P_NODE_140702_length_262_cov_1.222222_g133162_i0 | PRJNA896554 | 140702 | 262 | 1.222222 | 3.20222164 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 93.6 | 5.54e-20 | NR | KAI9139049.1 | 1500003 | g133162 | i0 | 59.3 | 0.984732824427481 | 86 | 28 | 98.5 | 2 | 3 | 260 | 117 | 195 | KAI9139049.1 chaperonin Cpn60/TCP-1 family [Paraphysoderma sedebokerense] | diamond | 258 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32142114 | 32142114 | PRJNA896554_P_NODE_150038_length_251_cov_0.865169_g142498_i0 | PRJNA896554 | 150038 | 251 | 0.865169 | 2.17157419 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 63.9 | 1.41e-9 | NR | KAJ1518241.1 | 945690 | g142498 | i0 | 44.3 | 0.944223107569721 | 79 | 40 | 94.4 | 2 | 3 | 239 | 567 | 641 | KAJ1518241.1 hypothetical protein HMI55_001117 [Coelomomyces lativittatus] | diamond | 237 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32624035 | 32624035 | PRJNA896554_P_NODE_86920_length_372_cov_0.916388_g79380_i0 | PRJNA896554 | 86920 | 372 | 0.916388 | 3.40896336 | Eukaryota | 2759 | Fungi | Fungi | 124 | 8.109999999999999e-31 | NR | KAJ3364053.1 | 64505 | g79380 | i0 | 54.7 | 9.37096774193548 | 117 | 50 | 92.7 | 2 | 345 | 1 | 85 | 200 | KAJ3364053.1 protein phosphatase 2A regulatory subunit cdc55 [Allomyces javanicus] | diamond | 3486 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus |
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);;