contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3956061 | 3956061 | PRJEB65099_P_NODE_6704_length_243_cov_0.917647_g6599_i0 | PRJEB65099 | 6704 | 243 | 0.917647 | 2.22988221 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 124 | 1.53e-33 | NR | CAD6580790.1 | 2778381 | g6599 | i0 | 79 | 4.98765432098765 | 81 | 17 | 100 | 0 | 1 | 243 | 60 | 140 | CAD6580790.1 MAG: 60S ribosomal protein L19C [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 1212 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 6508180 | 6508180 | PRJEB65099_P_NODE_6306_length_245_cov_0.906977_g6201_i0 | PRJEB65099 | 6306 | 245 | 0.906977 | 2.22209365 | Dothideomycetes | 147541 | Fungi | Fungi | 144 | 1.74e-40 | NR | XP_069228530.1 | 1052096 | g6201 | i0 | 86.4 | 8.87755102040816 | 81 | 11 | 99.2 | 0 | 3 | 245 | 174 | 254 | XP_069228530.1 uncharacterized protein WHR41_05639 [Cladosporium halotolerans] | diamond | 2175 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26615175 | 26615175 | PRJEB65099_P_NODE_4961_length_253_cov_0.866667_g4856_i0 | PRJEB65099 | 4961 | 253 | 0.866667 | 2.19266751 | Basidiomycota | 5204 | Fungi | Fungi | 82 | 6.24e-16 | NR | KNZ58666.1 | 27349 | g4856 | i0 | 52.6 | 9.77075098814229 | 78 | 37 | 92.5 | 0 | 241 | 8 | 421 | 498 | KNZ58666.1 dolichyl-phosphate-mannose-protein mannosyltransferase [Puccinia sorghi] | diamond | 2472 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 27033888 | 27033888 | PRJEB65099_P_NODE_6282_length_245_cov_0.906977_g6177_i0 | PRJEB65099 | 6282 | 245 | 0.906977 | 2.22209365 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 142 | 2.66e-38 | NR | XP_023622043.1 | 112498 | g6177 | i0 | 85.2 | 0.991836734693878 | 81 | 12 | 99.2 | 0 | 3 | 245 | 100 | 180 | XP_023622043.1 related to oxidase [Ramularia collo-cygni] | diamond | 243 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 27476317 | 27476317 | PRJEB65099_P_NODE_5763_length_248_cov_0.891429_g5658_i0 | PRJEB65099 | 5763 | 248 | 0.891429 | 2.21074392 | Malassezia restricta | 76775 | Fungi | Fungi | 151 | 6.88e-41 | NR | XP_027483197.1 | 76775 | g5658 | i0 | 79.3 | 1.98387096774194 | 82 | 17 | 99.2 | 0 | 246 | 1 | 181 | 262 | XP_027483197.1 aldehyde dehydrogenase [Malassezia restricta] | diamond | 492 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28265483 | 28265483 | PRJEB65099_P_NODE_5906_length_247_cov_0.896552_g5801_i0 | PRJEB65099 | 5906 | 247 | 0.896552 | 2.21448344 | Malassezia sp. CBS 17886 | 3031751 | Fungi | Fungi | 68.2 | 4.18e-11 | NR | WFD29689.1 | 3031751 | g5801 | i0 | 50 | 0.923076923076923 | 76 | 37 | 92.3 | 1 | 3 | 230 | 393 | 467 | WFD29689.1 hypothetical protein MSPP1_000700 [Malassezia sp. CBS 17886] | diamond | 228 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sp. CBS 17886 | |
| 28739283 | 28739283 | PRJEB65099_P_NODE_5287_length_251_cov_0.876404_g5182_i0 | PRJEB65099 | 5287 | 251 | 0.876404 | 2.19977404 | Kockovaella imperatae | 4999 | Fungi | Fungi | 99.4 | 5.02e-22 | NR | XP_021869823.1 | 4999 | g5182 | i0 | 66.2 | 0.920318725099602 | 77 | 9 | 92 | 1 | 233 | 3 | 387 | 446 | XP_021869823.1 hypothetical protein BD324DRAFT_631038 [Kockovaella imperatae] | diamond | 231 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 30065370 | 30065370 | PRJEB65099_P_NODE_3272_length_312_cov_0.945607_g3167_i0 | PRJEB65099 | 3272 | 312 | 0.945607 | 2.95029384 | Rhizoctonia solani | 456999 | Fungi | Fungi | 43.5 | 0.0427 | NR | CAE6484529.1 | 456999 | g3167 | i0 | 39.3 | 0.586538461538462 | 61 | 34 | 55.8 | 1 | 23 | 196 | 410 | 470 | CAE6484529.1 unnamed protein product [Rhizoctonia solani] | diamond | 183 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 30065371 | 30065371 | PRJEB65099_P_NODE_4292_length_270_cov_1.319797_g4187_i0 | PRJEB65099 | 4292 | 270 | 1.319797 | 3.5634519 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 160 | 1.6599999999999996e-43 | NR | GHJ87931.1 | 104408 | g4187 | i0 | 82 | 0.988888888888889 | 89 | 16 | 98.9 | 0 | 1 | 267 | 386 | 474 | GHJ87931.1 hypothetical protein NliqN6_4333 [Naganishia liquefaciens] | diamond | 267 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 30318825 | 30318825 | PRJEB65099_P_NODE_5412_length_250_cov_0.881356_g5307_i0 | PRJEB65099 | 5412 | 250 | 0.881356 | 2.20339 | Ganoderma sinense ZZ | 36075 | Fungi | Fungi | 70.1 | 9.65e-12 | NR | PIL22694.1 | 1077348 | g5307 | i0 | 50.6 | 0.996 | 83 | 27 | 99.6 | 2 | 1 | 249 | 3 | 71 | PIL22694.1 transporter [Ganoderma sinense ZZ0214-1] | diamond | 249 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma sinense | |
| 30444795 | 30444795 | PRJEB65099_P_NODE_6833_length_242_cov_0.923077_g6728_i0 | PRJEB65099 | 6833 | 242 | 0.923077 | 2.23384634 | Armillaria ostoyae | 47428 | Fungi | Fungi | 151 | 4.87e-44 | NR | SJL02587.1 | 47428 | g6728 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 241 | 2 | 59 | 138 | SJL02587.1 uncharacterized protein ARMOST_05918 [Armillaria ostoyae] | diamond | 240 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria ostoyae | |
| 32144974 | 32144974 | PRJEB65099_P_NODE_5238_length_251_cov_0.876404_g5133_i0 | PRJEB65099 | 5238 | 251 | 0.876404 | 2.19977404 | Malassezia | 55193 | Fungi | Fungi | 50.8 | 5.63e-5 | NR | KAI3624460.1 | 55194 | g5133 | i0 | 85.7 | 1.00398406374502 | 28 | 4 | 33.5 | 0 | 83 | 166 | 46 | 73 | KAI3624460.1 ADE13 [Malassezia furfur] | diamond | 252 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 32215304 | 32215304 | PRJEB65099_P_NODE_6458_length_244_cov_0.912281_g6353_i0 | PRJEB65099 | 6458 | 244 | 0.912281 | 2.22596564 | Neonectria magnoliae | 2732573 | Fungi | Fungi | 43.9 | 0.0153 | NR | KAK7426093.1 | 2732573 | g6353 | i0 | 38.6 | 1.02049180327869 | 83 | 43 | 99.6 | 4 | 243 | 1 | 65 | 141 | KAK7426093.1 hypothetical protein QQZ08_007403 [Neonectria magnoliae] | diamond | 249 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Neonectria | Neonectria magnoliae | |
| 32278711 | 32278711 | PRJEB65099_P_NODE_5659_length_249_cov_0.886364_g5554_i0 | PRJEB65099 | 5659 | 249 | 0.886364 | 2.20704636 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 128 | 1.77e-32 | NR | XP_069233952.1 | 1052096 | g5554 | i0 | 78 | 0.987951807228916 | 82 | 18 | 98.8 | 0 | 3 | 248 | 61 | 142 | XP_069233952.1 uncharacterized protein WHR41_00197 [Cladosporium halotolerans] | diamond | 246 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32468608 | 32468608 | PRJEB65099_P_NODE_6139_length_246_cov_0.901734_g6034_i0 | PRJEB65099 | 6139 | 246 | 0.901734 | 2.21826564 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 155 | 9.61e-42 | NR | XP_022404618.1 | 1160497 | g6034 | i0 | 95.1 | 0.98780487804878 | 81 | 4 | 98.8 | 0 | 1 | 243 | 1204 | 1284 | XP_022404618.1 uncharacterized protein ASPGLDRAFT_79637 [Aspergillus glaucus CBS 516.65] | diamond | 243 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 32689114 | 32689114 | PRJEB65099_P_NODE_6440_length_244_cov_0.912281_g6335_i0 | PRJEB65099 | 6440 | 244 | 0.912281 | 2.22596564 | Acrodontium crateriforme | 150365 | Fungi | Fungi | 130 | 1.7e-34 | NR | WPH00996.1 | 150365 | g6335 | i0 | 82.7 | 0.995901639344262 | 81 | 14 | 99.6 | 0 | 243 | 1 | 202 | 282 | WPH00996.1 mediator of rna polymerase ii transcription subunit 6 [Acrodontium crateriforme] | diamond | 243 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme |
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);;