contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA939370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26803377 | 26803377 | PRJNA939370_S_NODE_3141_length_163_cov_0.719298_g3089_i0 | PRJNA939370 | 3141 | 163 | 0.719298 | 1.17245574 | Tulasnella sp. 4 | 1905295 | Fungi | Fungi | 63.2 | 2.56e-11 | NR | KAG8911299.1 | 2600224 | g3089 | i0 | 75 | 0.736196319018405 | 40 | 10 | 73.6 | 0 | 31 | 150 | 3 | 42 | KAG8911299.1 hypothetical protein FRC00_006739 [Tulasnella sp. 408] | diamond | 120 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 408 | |
| 27411550 | 27411550 | PRJNA939370_S_NODE_2203_length_185_cov_0.933824_g2151_i0 | PRJNA939370 | 2203 | 185 | 0.933824 | 1.7275744 | Polyporaceae | 5317 | Fungi | Fungi | 109 | 8.33e-29 | NR | XP_067541643.1 | 1328758 | g2151 | i0 | 88.5 | 1.97837837837838 | 61 | 7 | 98.9 | 0 | 3 | 185 | 48 | 108 | XP_067541643.1 uncharacterized protein L226DRAFT_529520 [Lentinus tigrinus ALCF2SS1-7] | diamond | 366 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 27853249 | 27853249 | PRJNA939370_S_NODE_2804_length_167_cov_0.864407_g2752_i0 | PRJNA939370 | 2804 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | Fungi | Fungi | 46.6 | 1.06e-4 | NR | KAL1741864.1 | 160053 | g2752 | i0 | 46 | 3.62874251497006 | 50 | 27 | 89.8 | 0 | 12 | 161 | 41 | 90 | KAL1741864.1 hypothetical protein HDZ31DRAFT_66524 [Schizophyllum fasciatum] | diamond | 606 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum fasciatum | |
| 28169071 | 28169071 | PRJNA939370_S_NODE_2685_length_169_cov_1.183333_g2633_i0 | PRJNA939370 | 2685 | 169 | 1.183333 | 1.99983277 | Tulasnella | 5240 | Fungi | Fungi | 81.6 | 8.8e-17 | NR | KAG8953499.1 | 2600228 | g2633 | i0 | 74.1 | 1.91715976331361 | 54 | 14 | 95.9 | 0 | 7 | 168 | 206 | 259 | KAG8953499.1 hypothetical protein FRC04_002341 [Tulasnella sp. 424] | diamond | 324 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 424 | |
| 28824837 | 28824837 | PRJNA939370_S_NODE_1768_length_206_cov_0.866242_g1716_i0 | PRJNA939370 | 1768 | 206 | 0.866242 | 1.78445852 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 108 | 7.16e-27 | NR | KAI0752568.1 | 1140402 | g1716 | i0 | 70.6 | 0.990291262135922 | 68 | 20 | 99 | 0 | 1 | 204 | 195 | 262 | KAI0752568.1 ferritin-like domain-containing protein [Daedaleopsis nitida] | diamond | 204 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 28983227 | 28983227 | PRJNA939370_S_NODE_3288_length_161_cov_0.910714_g3236_i0 | PRJNA939370 | 3288 | 161 | 0.910714 | 1.46624954 | Lentinus tigrinus ALCF2SS1-6 | 1328759 | Fungi | Fungi | 79 | 3.19e-16 | NR | RPD63120.1 | 1328759 | g3236 | i0 | 78.4 | 0.950310559006211 | 51 | 11 | 95 | 0 | 5 | 157 | 119 | 169 | RPD63120.1 hypothetical protein L227DRAFT_609021 [Lentinus tigrinus ALCF2SS1-6] | diamond | 153 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 29393551 | 29393551 | PRJNA939370_S_NODE_1629_length_215_cov_1.186747_g1577_i0 | PRJNA939370 | 1629 | 215 | 1.186747 | 2.55150605 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 68.6 | 2.06e-11 | NR | KAI0741778.1 | 1140402 | g1577 | i0 | 58.8 | 0.948837209302326 | 68 | 26 | 92.1 | 1 | 214 | 17 | 4 | 71 | KAI0741778.1 hypothetical protein C8Q80DRAFT_1274145 [Daedaleopsis nitida] | diamond | 204 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 29487976 | 29487976 | PRJNA939370_S_NODE_1870_length_200_cov_0.834437_g1818_i0 | PRJNA939370 | 1870 | 200 | 0.834437 | 1.668874 | Ceratobasidium sp. AG-I | 305860 | Fungi | Fungi | 81.6 | 2.44e-16 | NR | KAF8608763.1 | 305860 | g1818 | i0 | 56.3 | 0.96 | 64 | 28 | 96 | 0 | 193 | 2 | 53 | 116 | KAF8608763.1 hypothetical protein BDV93DRAFT_207408 [Ceratobasidium sp. AG-I] | diamond | 192 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I | |
| 29772158 | 29772158 | PRJNA939370_S_NODE_2811_length_167_cov_0.864407_g2759_i0 | PRJNA939370 | 2811 | 167 | 0.864407 | 1.44355969 | Mycena latifolia | 1033247 | Fungi | Fungi | 72.4 | 2.35e-13 | NR | KAJ7485287.1 | 1033247 | g2759 | i0 | 92.3 | 0.70059880239521 | 39 | 3 | 70.1 | 0 | 166 | 50 | 178 | 216 | KAJ7485287.1 PUA-like domain-containing protein [Mycena latifolia] | diamond | 117 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena latifolia | |
| 30056496 | 30056496 | PRJNA939370_S_NODE_1451_length_228_cov_1.536313_g1399_i0 | PRJNA939370 | 1451 | 228 | 1.536313 | 3.50279364 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 45.1 | 0.00118 | NR | KAI0753469.1 | 1140402 | g1399 | i0 | 48.7 | 1 | 76 | 34 | 98.7 | 3 | 227 | 3 | 11 | 82 | KAI0753469.1 hypothetical protein C8Q80DRAFT_1118584 [Daedaleopsis nitida] | diamond | 228 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 30751810 | 30751810 | PRJNA939370_S_NODE_3034_length_164_cov_0.886957_g2982_i0 | PRJNA939370 | 3034 | 164 | 0.886957 | 1.45460948 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 42 | 0.0234 | NR | KAI0741769.1 | 1140402 | g2982 | i0 | 46.3 | 0.75 | 41 | 22 | 75 | 0 | 124 | 2 | 1 | 41 | KAI0741769.1 hypothetical protein C8Q80DRAFT_155669 [Daedaleopsis nitida] | diamond | 123 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 30973000 | 30973000 | PRJNA939370_S_NODE_294_length_511_cov_2.469697_g243_i0 | PRJNA939370 | 294 | 511 | 2.469697 | 12.62015167 | Cerioporus squamosus | 2829415 | Fungi | Fungi | 47.4 | 0.00187 | NR | KAI0712819.1 | 2829415 | g243 | i0 | 53.1 | 0.37573385518591 | 64 | 27 | 37.6 | 1 | 48 | 239 | 1 | 61 | KAI0712819.1 hypothetical protein C8T65DRAFT_695203 [Cerioporus squamosus] | diamond | 192 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Cerioporus | Cerioporus squamosus | |
| 31984748 | 31984748 | PRJNA939370_S_NODE_2298_length_181_cov_1.159091_g2246_i0 | PRJNA939370 | 2298 | 181 | 1.159091 | 2.09795471 | Ceratobasidium sp. AG-I | 305860 | Fungi | Fungi | 96.3 | 3.24e-22 | NR | KAF8598929.1 | 305860 | g2246 | i0 | 85.7 | 5.76795580110497 | 56 | 8 | 92.8 | 0 | 12 | 179 | 89 | 144 | KAF8598929.1 hypothetical protein BDV93DRAFT_592558 [Ceratobasidium sp. AG-I] | diamond | 1044 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I | |
| 32371682 | 32371682 | PRJNA939370_S_NODE_3179_length_162_cov_0.902655_g3127_i0 | PRJNA939370 | 3179 | 162 | 0.902655 | 1.4623011 | Sordariomycetes | 147550 | Fungi | Fungi | 49.3 | 1.39e-5 | NR | XP_052988130.1 | 1214568 | g3127 | i0 | 96 | 1.38888888888889 | 25 | 1 | 46.3 | 0 | 2 | 76 | 98 | 122 | XP_052988130.1 rpel repeat protein [Diaporthe amygdali] | diamond | 225 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe amygdali | |
| 32743455 | 32743455 | PRJNA939370_S_NODE_1960_length_195_cov_1.178082_g1908_i0 | PRJNA939370 | 1960 | 195 | 1.178082 | 2.2972599 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 69.3 | 8.58e-12 | NR | KAI0741778.1 | 1140402 | g1908 | i0 | 71 | 0.953846153846154 | 62 | 11 | 95.4 | 2 | 10 | 195 | 301 | 355 | KAI0741778.1 hypothetical protein C8Q80DRAFT_1274145 [Daedaleopsis nitida] | diamond | 186 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 32774733 | 32774733 | PRJNA939370_S_NODE_2260_length_183_cov_0.828358_g2208_i0 | PRJNA939370 | 2260 | 183 | 0.828358 | 1.51589514 | Lentinus brumalis | 2498619 | Fungi | Fungi | 42 | 0.00722 | NR | RDX40592.1 | 2498619 | g2208 | i0 | 40.8 | 0.80327868852459 | 49 | 29 | 80.3 | 0 | 161 | 15 | 41 | 89 | RDX40592.1 hypothetical protein OH76DRAFT_1365997, partial [Lentinus brumalis] | diamond | 147 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus brumalis |
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);;