contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB55122" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12874780 | 12874780 | PRJEB55122_P_NODE_37511_length_168_cov_0.873950_g37114_i0 | PRJEB55122 | 37511 | 168 | 0.87395 | 1.468236 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 90.1 | 8.73e-20 | NR | XP_018277145.1 | 879819 | g37114 | i0 | 76.8 | 1.98214285714286 | 56 | 12 | 98.2 | 1 | 166 | 2 | 118 | 173 | XP_018277145.1 uncharacterized protein COLE_02874 [Cutaneotrichosporon oleaginosum] | diamond | 333 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 27191485 | 27191485 | PRJEB55122_P_NODE_39662_length_166_cov_0.888889_g39265_i0 | PRJEB55122 | 39662 | 166 | 0.888889 | 1.47555574 | Schizophyllum commune Tattone D | 1314663 | Fungi | Fungi | 43.5 | 0.00697 | NR | KAI5830951.1 | 1314663 | g39265 | i0 | 39.2 | 0.921686746987952 | 51 | 30 | 92.2 | 1 | 1 | 153 | 208 | 257 | KAI5830951.1 hypothetical protein K523DRAFT_379861 [Schizophyllum commune Tattone D] | diamond | 153 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 28075762 | 28075762 | PRJEB55122_P_NODE_32965_length_181_cov_1.181818_g32568_i0 | PRJEB55122 | 32965 | 181 | 1.181818 | 2.13909058 | Austropuccinia psidii | 181123 | Fungi | Fungi | 44.3 | 0.00161 | NR | MBW0481233.1 | 1389203 | g32568 | i0 | 34.9 | 1.93922651933702 | 63 | 38 | 99.4 | 1 | 2 | 181 | 1 | 63 | MBW0481233.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 351 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 28801862 | 28801862 | PRJEB55122_P_NODE_36268_length_170_cov_0.917355_g35871_i0 | PRJEB55122 | 36268 | 170 | 0.917355 | 1.5595035 | Naganishia albida | 100951 | Fungi | Fungi | 108 | 4.509999999999999e-28 | NR | KAI5455188.1 | 100951 | g35871 | i0 | 92.5 | 0.935294117647059 | 53 | 4 | 93.5 | 0 | 169 | 11 | 148 | 200 | KAI5455188.1 hypothetical protein NCC49_000006 [Naganishia albida] | diamond | 159 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 30696965 | 30696965 | PRJEB55122_P_NODE_37474_length_168_cov_1.008403_g37077_i0 | PRJEB55122 | 37474 | 168 | 1.008403 | 1.69411704 | Candolleomyces efflorescens | 2917767 | Fungi | Fungi | 42 | 0.0246 | NR | KAJ2918165.1 | 2917767 | g37077 | i0 | 48.6 | 0.660714285714286 | 37 | 19 | 66.1 | 0 | 3 | 113 | 19 | 55 | KAJ2918165.1 hypothetical protein MD484_g2280, partial [Candolleomyces efflorescens] | diamond | 111 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces efflorescens | |
| 31290625 | 31290625 | PRJEB55122_P_NODE_41675_length_164_cov_0.904348_g41278_i0 | PRJEB55122 | 41675 | 164 | 0.904348 | 1.48313072 | Agaricales | 5338 | Fungi | Fungi | 82.4 | 5.16e-17 | NR | KAF7773280.1 | 192524 | g41278 | i0 | 75.9 | 2.96341463414634 | 54 | 13 | 98.8 | 0 | 164 | 3 | 59 | 112 | KAF7773280.1 hypothetical protein Agabi119p4_5447 [Agaricus bisporus var. burnettii] | diamond | 486 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 31329093 | 31329093 | PRJEB55122_P_NODE_38716_length_167_cov_0.881356_g38319_i0 | PRJEB55122 | 38716 | 167 | 0.881356 | 1.47186452 | Tremellales sp. Uapishka_1 | 3038892 | Fungi | Fungi | 83.6 | 4.55e-17 | NR | KAK4687433.1 | 3038892 | g38319 | i0 | 70.9 | 1.97604790419162 | 55 | 16 | 98.8 | 0 | 1 | 165 | 194 | 248 | KAK4687433.1 hypothetical protein P7C73_g2682, partial [Tremellales sp. Uapishka_1] | diamond | 330 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Uapishka_1 | |||
| 31954900 | 31954900 | PRJEB55122_P_NODE_28897_length_196_cov_1.612245_g28500_i0 | PRJEB55122 | 28897 | 196 | 1.612245 | 3.1600002 | Opisthokonta | 33154 | Fungi | Fungi | 72 | 1.92e-13 | NR | KAI8452562.1 | 170000 | g28500 | i0 | 67.3 | 5.3265306122449 | 55 | 18 | 84.2 | 0 | 166 | 2 | 144 | 198 | KAI8452562.1 40S ribosomal protein S8 [Phakopsora pachyrhizi] | diamond | 1044 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 31961676 | 31961676 | PRJEB55122_P_NODE_38778_length_167_cov_0.881356_g38381_i0 | PRJEB55122 | 38778 | 167 | 0.881356 | 1.47186452 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 78.2 | 4.25e-15 | NR | XP_007002981.1 | 578456 | g38381 | i0 | 66 | 2.89221556886228 | 53 | 18 | 95.2 | 0 | 166 | 8 | 266 | 318 | XP_007002981.1 uncharacterized protein TREMEDRAFT_67606 [Tremella mesenterica DSM 1558] | diamond | 483 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica |
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);;