contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20704304 | 20704304 | PRJNA1156092_P_NODE_31377_length_242_cov_0.911243_g31247_i0 | PRJNA1156092 | 31377 | 242 | 0.911243 | 2.20520806 | Agaricales | 5338 | Fungi | Fungi | 118 | 4.809999999999999e-31 | NR | AFU72288.1 | 67730 | g31247 | i0 | 75.3 | 6.02479338842975 | 81 | 19 | 99.2 | 1 | 240 | 1 | 115 | 195 | AFU72288.1 40S ribosomal protein S1, partial [Amanita strobiliformis] | diamond | 1458 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita strobiliformis | |
| 27217491 | 27217491 | PRJNA1156092_P_NODE_27462_length_246_cov_0.890173_g27332_i0 | PRJNA1156092 | 27462 | 246 | 0.890173 | 2.18982558 | Ustilaginales | 5267 | Fungi | Fungi | 135 | 8.67e-37 | NR | XP_011389944.1 | 5270 | g27332 | i0 | 78 | 21 | 82 | 18 | 100 | 0 | 246 | 1 | 215 | 296 | XP_011389944.1 putative PNO1 protein [Mycosarcoma maydis] | diamond | 5166 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 27704065 | 27704065 | PRJNA1156092_P_NODE_22544_length_251_cov_0.865169_g22414_i0 | PRJNA1156092 | 22544 | 251 | 0.865169 | 2.17157419 | Gymnopilus dilepis | 231916 | Fungi | Fungi | 49.7 | 1.35e-4 | NR | PPR05319.1 | 231916 | g22414 | i0 | 35.2 | 1.43426294820717 | 71 | 37 | 74.1 | 3 | 192 | 7 | 145 | 215 | PPR05319.1 hypothetical protein CVT26_011577, partial [Gymnopilus dilepis] | diamond | 360 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Gymnopilus | Gymnopilus dilepis | |
| 28544261 | 28544261 | PRJNA1156092_P_NODE_22867_length_250_cov_1.180791_g22737_i0 | PRJNA1156092 | 22867 | 250 | 1.180791 | 2.9519775 | Agaricomycetes | 155619 | Fungi | Fungi | 42.7 | 0.0378 | NR | XP_041186839.1 | 48587 | g22737 | i0 | 69 | 1.044 | 29 | 9 | 34.8 | 0 | 250 | 164 | 175 | 203 | XP_041186839.1 uncharacterized protein BJ212DRAFT_1394370 [Suillus subaureus] | diamond | 261 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus subaureus | |
| 28745691 | 28745691 | PRJNA1156092_P_NODE_28247_length_245_cov_0.895349_g28117_i0 | PRJNA1156092 | 28247 | 245 | 0.895349 | 2.19360505 | Serendipita vermifera | 109899 | Fungi | Fungi | 96.7 | 3.850000000000001e-21 | NR | PVG00635.1 | 109899 | g28117 | i0 | 56.3 | 1.97142857142857 | 80 | 31 | 95.5 | 2 | 10 | 243 | 36 | 113 | PVG00635.1 hypothetical protein CPB86DRAFT_181593 [Serendipita vermifera] | diamond | 483 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 29301877 | 29301877 | PRJNA1156092_P_NODE_31569_length_242_cov_0.911243_g31439_i0 | PRJNA1156092 | 31569 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Fungi | Fungi | 129 | 9.47e-33 | NR | CDO75282.1 | 5643 | g31439 | i0 | 72.2 | 13.698347107438 | 79 | 22 | 97.9 | 0 | 242 | 6 | 209 | 287 | CDO75282.1 hypothetical protein BN946_scf184497.g13 [Trametes cinnabarina] | diamond | 3315 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes cinnabarina | |
| 30040289 | 30040289 | PRJNA1156092_P_NODE_15871_length_292_cov_1.780822_g15741_i0 | PRJNA1156092 | 15871 | 292 | 1.780822 | 5.20000024 | Phanerochaete sordida | 48140 | Fungi | Fungi | 170 | 6.85e-47 | NR | GJE93447.1 | 48140 | g15741 | i0 | 87.5 | 3.94520547945205 | 96 | 12 | 98.6 | 0 | 3 | 290 | 231 | 326 | GJE93447.1 DEAD/DEAH box helicase [Phanerochaete sordida] | diamond | 1152 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete sordida | |
| 30261727 | 30261727 | PRJNA1156092_P_NODE_28532_length_245_cov_0.895349_g28402_i0 | PRJNA1156092 | 28532 | 245 | 0.895349 | 2.19360505 | Peniophora sp. CONT | 1314672 | Fungi | Fungi | 88.6 | 1.38e-18 | NR | KZV60735.1 | 1314672 | g28402 | i0 | 60 | 0.979591836734694 | 80 | 27 | 93.1 | 3 | 243 | 16 | 159 | 237 | KZV60735.1 hypothetical protein PENSPDRAFT_659397 [Peniophora sp. CONT] | diamond | 240 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 30313008 | 30313008 | PRJNA1156092_P_NODE_29232_length_244_cov_0.900585_g29102_i0 | PRJNA1156092 | 29232 | 244 | 0.900585 | 2.1974274 | Tremellomycetes | 155616 | Fungi | Fungi | 77 | 3.64e-15 | NR | KAK1923319.1 | 5418 | g29102 | i0 | 44.3 | 3.92213114754098 | 79 | 44 | 97.1 | 0 | 244 | 8 | 61 | 139 | KAK1923319.1 putative Rho GTPase [Papiliotrema laurentii] | diamond | 957 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema laurentii | |
| 30988300 | 30988300 | PRJNA1156092_P_NODE_29714_length_244_cov_0.900585_g29584_i0 | PRJNA1156092 | 29714 | 244 | 0.900585 | 2.1974274 | Naematelia encephala | 71784 | Fungi | Fungi | 90.5 | 6.5e-22 | NR | ORY35885.1 | 71784 | g29584 | i0 | 69.7 | 1.62295081967213 | 66 | 20 | 81.1 | 0 | 32 | 229 | 1 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 396 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 31177473 | 31177473 | PRJNA1156092_P_NODE_20335_length_261_cov_1.430851_g20205_i0 | PRJNA1156092 | 20335 | 261 | 1.430851 | 3.73452111 | Punctularia strigosozonata HHB-11173 SS5 | 741275 | Fungi | Fungi | 124 | 7.96e-33 | NR | XP_007379911.1 | 741275 | g20205 | i0 | 75 | 1.88505747126437 | 80 | 20 | 92 | 0 | 20 | 259 | 3 | 82 | XP_007379911.1 uncharacterized protein PUNSTDRAFT_130597 [Punctularia strigosozonata HHB-11173 SS5] | diamond | 492 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Corticiales | Punctulariaceae | Punctularia | Punctularia strigosozonata | |
| 32746452 | 32746452 | PRJNA1156092_P_NODE_30820_length_243_cov_0.905882_g30690_i0 | PRJNA1156092 | 30820 | 243 | 0.905882 | 2.20129326 | Agaricales | 5338 | Fungi | Fungi | 49.7 | 9.67e-5 | NR | KAF9450758.1 | 1400762 | g30690 | i0 | 44 | 3.55555555555556 | 50 | 28 | 61.7 | 0 | 165 | 16 | 5 | 54 | KAF9450758.1 hypothetical protein P691DRAFT_797728 [Macrolepiota fuliginosa MF-IS2] | diamond | 864 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Macrolepiota | Macrolepiota fuliginosa |
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);;