contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1197996" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 323999 | 323999 | PRJNA1197996_S_NODE_19241_length_270_cov_1.563452_g19187_i0 | PRJNA1197996 | 19241 | 270 | 1.563452 | 4.2213204 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 127 | 7.72e-35 | NR | XP_066822792.1 | 1397322 | g19187 | i0 | 82.9 | 0.844444444444444 | 76 | 12 | 84.4 | 1 | 3 | 230 | 104 | 178 | XP_066822792.1 uncharacterized protein P389DRAFT_84242 [Cystobasidium minutum MCA 4210] | diamond | 228 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 6702164 | 6702164 | PRJNA1197996_S_NODE_6446_length_383_cov_1.638710_g6392_i0 | PRJNA1197996 | 6446 | 383 | 1.6387100000000001 | 6.2762593 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 201 | 1.4e-63 | NR | XP_066820800.1 | 1397322 | g6392 | i0 | 99 | 0.7911227154047 | 101 | 1 | 79.1 | 0 | 382 | 80 | 72 | 172 | XP_066820800.1 60S ribosomal protein eL20 [Cystobasidium minutum MCA 4210] | diamond | 303 | 201 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 11802706 | 11802706 | PRJNA1197996_S_NODE_28370_length_241_cov_1.375000_g28316_i0 | PRJNA1197996 | 28370 | 241 | 1.375 | 3.31375 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 93.6 | 1.08e-21 | NR | XP_066820743.1 | 1397322 | g28316 | i0 | 96.4 | 0.697095435684647 | 56 | 2 | 69.7 | 0 | 240 | 73 | 138 | 193 | XP_066820743.1 60S ribosomal protein eL19 [Cystobasidium minutum MCA 4210] | diamond | 168 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 27103970 | 27103970 | PRJNA1197996_S_NODE_20962_length_262_cov_1.396825_g20908_i0 | PRJNA1197996 | 20962 | 262 | 1.396825 | 3.6596815 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 121 | 7.93e-33 | NR | XP_066824854.1 | 1397322 | g20908 | i0 | 83.6 | 0.83587786259542 | 73 | 12 | 83.6 | 0 | 260 | 42 | 89 | 161 | XP_066824854.1 RBP11-like subunits of RNA polymerase [Cystobasidium minutum MCA 4210] | diamond | 219 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 27388781 | 27388781 | PRJNA1197996_S_NODE_29483_length_226_cov_3.248366_g29429_i0 | PRJNA1197996 | 29483 | 226 | 3.248366 | 7.34130716 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 142 | 2.44e-38 | NR | XP_066822236.1 | 1397322 | g29429 | i0 | 90.4 | 0.969026548672566 | 73 | 7 | 96.9 | 0 | 224 | 6 | 372 | 444 | XP_066822236.1 Adenylosuccinate synthetase [Cystobasidium minutum MCA 4210] | diamond | 219 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 27893663 | 27893663 | PRJNA1197996_S_NODE_12085_length_315_cov_1.086777_g12031_i0 | PRJNA1197996 | 12085 | 315 | 1.086777 | 3.42334755 | Gautieria morchelliformis | 112417 | Fungi | Fungi | 43.9 | 0.0342 | NR | KAF8507776.1 | 112417 | g12031 | i0 | 36.5 | 0.6 | 63 | 40 | 60 | 0 | 191 | 3 | 444 | 506 | KAF8507776.1 hypothetical protein JB92DRAFT_2957561 [Gautieria morchelliformis] | diamond | 189 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Gautieria | Gautieria morchelliformis | |
| 28146574 | 28146574 | PRJNA1197996_S_NODE_19625_length_268_cov_1.841026_g19571_i0 | PRJNA1197996 | 19625 | 268 | 1.841026 | 4.93394968 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 105 | 4.54e-24 | NR | XP_066819600.1 | 1397322 | g19571 | i0 | 96.5 | 0.638059701492537 | 57 | 2 | 63.8 | 0 | 2 | 172 | 2687 | 2743 | XP_066819600.1 fatty acid synthase subunit beta [Cystobasidium minutum MCA 4210] | diamond | 171 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 29346265 | 29346265 | PRJNA1197996_S_NODE_24769_length_248_cov_1.760000_g24715_i0 | PRJNA1197996 | 24769 | 248 | 1.76 | 4.3648 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 109 | 1.5e-26 | NR | XP_066825907.1 | 1397322 | g24715 | i0 | 98.2 | 0.665322580645161 | 55 | 1 | 66.5 | 0 | 1 | 165 | 301 | 355 | XP_066825907.1 Cpn10-domain-containing protein [Cystobasidium minutum MCA 4210] | diamond | 165 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 29535617 | 29535617 | PRJNA1197996_S_NODE_25550_length_247_cov_0.885057_g25496_i0 | PRJNA1197996 | 25550 | 247 | 0.885057 | 2.18609079 | Pterula gracilis | 1884261 | Fungi | Fungi | 132 | 5.19e-34 | NR | TFL01231.1 | 1884261 | g25496 | i0 | 79 | 0.983805668016194 | 81 | 17 | 98.4 | 0 | 2 | 244 | 270 | 350 | TFL01231.1 Pyoverdine/dityrosine biosynthesis protein-domain-containing protein [Pterula gracilis] | diamond | 243 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pterulaceae | Pterulicium | Pterulicium gracile | |
| 29946250 | 29946250 | PRJNA1197996_S_NODE_18951_length_272_cov_1.010050_g18897_i0 | PRJNA1197996 | 18951 | 272 | 1.01005 | 2.7473359999999998 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 125 | 6.47e-33 | NR | XP_066820158.1 | 1397322 | g18897 | i0 | 98.4 | 0.705882352941177 | 64 | 1 | 70.6 | 0 | 3 | 194 | 219 | 282 | XP_066820158.1 ras-domain-containing protein [Cystobasidium minutum MCA 4210] | diamond | 192 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 30103979 | 30103979 | PRJNA1197996_S_NODE_15092_length_293_cov_2.700000_g15038_i0 | PRJNA1197996 | 15092 | 293 | 2.7 | 7.911 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 196 | 1.02e-61 | NR | XP_066823082.1 | 1397322 | g15038 | i0 | 92.8 | 0.993174061433447 | 97 | 7 | 99.3 | 0 | 3 | 293 | 85 | 181 | XP_066823082.1 Ham1-like protein [Cystobasidium minutum MCA 4210] | diamond | 291 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 30514846 | 30514846 | PRJNA1197996_S_NODE_22533_length_255_cov_1.269231_g22479_i0 | PRJNA1197996 | 22533 | 255 | 1.269231 | 3.23653905 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 151 | 5.5e-42 | NR | XP_066821565.1 | 1397322 | g22479 | i0 | 98.7 | 0.905882352941176 | 77 | 1 | 90.6 | 0 | 255 | 25 | 305 | 381 | XP_066821565.1 argininosuccinate synthetase [Cystobasidium minutum MCA 4210] | diamond | 231 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 31703338 | 31703338 | PRJNA1197996_S_NODE_24837_length_248_cov_1.320000_g24783_i0 | PRJNA1197996 | 24837 | 248 | 1.32 | 3.2736 | Tremellales | 5234 | Fungi | Fungi | 106 | 7.25e-26 | NR | XP_052944004.1 | 4972 | g24783 | i0 | 63 | 1.97177419354839 | 81 | 28 | 98 | 1 | 248 | 6 | 176 | 254 | XP_052944004.1 putative glutathione S-transferase [Dioszegia hungarica] | diamond | 489 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 31874135 | 31874135 | PRJNA1197996_S_NODE_4417_length_431_cov_3.108939_g4363_i0 | PRJNA1197996 | 4417 | 431 | 3.108939 | 13.39952709 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 83.2 | 9.27e-18 | NR | XP_066826361.1 | 1397322 | g4363 | i0 | 87.8 | 0.341067285382831 | 49 | 6 | 34.1 | 0 | 1 | 147 | 44 | 92 | XP_066826361.1 60S ribosomal protein eL43 [Cystobasidium minutum MCA 4210] | diamond | 147 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 32696126 | 32696126 | PRJNA1197996_S_NODE_14340_length_298_cov_1.711111_g14286_i0 | PRJNA1197996 | 14340 | 298 | 1.711111 | 5.09911078 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 53.5 | 1.09e-5 | NR | XP_066825059.1 | 1397322 | g14286 | i0 | 100 | 0.231543624161074 | 23 | 0 | 23.2 | 0 | 2 | 70 | 363 | 385 | XP_066825059.1 class II peroxidase [Cystobasidium minutum MCA 4210] | diamond | 69 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 32696132 | 32696132 | PRJNA1197996_S_NODE_26560_length_245_cov_0.895349_g26506_i0 | PRJNA1197996 | 26560 | 245 | 0.895349 | 2.19360505 | Atractiella rhizophila | 1938712 | Fungi | Fungi | 50.1 | 9.43e-5 | NR | KAH8928706.1 | 1938712 | g26506 | i0 | 57.1 | 1.21224489795918 | 42 | 18 | 51.4 | 0 | 6 | 131 | 249 | 290 | KAH8928706.1 Pkinase-domain-containing protein [Atractiella rhizophila] | diamond | 297 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Atractiellomycetes | Atractiellales | Hoehnelomycetaceae | Atractiella | Atractiella rhizophila |
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);;