contig_metadata
9 rows where bioproject = "PRJNA290839", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1647642 | 1647642 | PRJNA290839_P_NODE_482_length_373_cov_1.026667_g461_i0 | PRJNA290839 | 482 | 373 | 1.026667 | 3.82946791 | Rhodotorula | 5533 | Fungi | Fungi | 170 | 1.47e-46 | NR | KAK4336477.1 | 5286 | g461 | i0 | 69.7 | 6.89276139410188 | 122 | 21 | 98.1 | 2 | 5 | 370 | 274 | 379 | KAK4336477.1 60S ribosomal protein L3 [Rhodotorula toruloides] | diamond | 2571 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 4887441 | 4887441 | PRJNA290839_P_NODE_804_length_286_cov_1.460094_g783_i0 | PRJNA290839 | 804 | 286 | 1.460094 | 4.17586884 | Gjaerumia | 272709 | Fungi | Fungi | 508 | 1.3e-139 | NTclustered | gi|979839318|gb|KP322989.1| | 58917 | g783 | i0 | 98.611 | 99.1573426573427 | 288 | 2 | 100 | 1 | 1 | 286 | 587 | 874 | Gjaerumia minor strain CBS 543.50 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 28359 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Gjaerumiaceae | Gjaerumia | Gjaerumia minor | |
| 26680169 | 26680169 | PRJNA290839_P_NODE_1281_length_248_cov_0.885714_g1260_i0 | PRJNA290839 | 1281 | 248 | 0.885714 | 2.19657072 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 1.04e-4 | NR | KAI5123140.1 | 135589 | g1260 | i0 | 36.2 | 17.2620967741935 | 69 | 42 | 82.3 | 2 | 29 | 232 | 296 | 363 | KAI5123140.1 hypothetical protein M0805_000843 [Coniferiporia weirii] | diamond | 4281 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Coniferiporia | Coniferiporia weirii | |
| 27643051 | 27643051 | PRJNA290839_P_NODE_1344_length_247_cov_0.896552_g1323_i0 | PRJNA290839 | 1344 | 247 | 0.896552 | 2.21448344 | Malassezia equina | 1381935 | Fungi | Fungi | 57 | 3.59e-7 | NR | WFD23951.1 | 1381935 | g1323 | i0 | 31.6 | 2.90283400809717 | 79 | 52 | 96 | 1 | 240 | 4 | 144 | 220 | WFD23951.1 protein disulfide-isomerase [Malassezia equina] | diamond | 717 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia equina | |
| 28432247 | 28432247 | PRJNA290839_P_NODE_786_length_290_cov_1.050691_g765_i0 | PRJNA290839 | 786 | 290 | 1.050691 | 3.0470039 | Mycena epipterygia | 230806 | Fungi | Fungi | 47.8 | 0.00115 | NR | KAJ7113534.1 | 230806 | g765 | i0 | 36.5 | 4.54137931034483 | 63 | 35 | 63.1 | 2 | 94 | 276 | 644 | 703 | KAJ7113534.1 hypothetical protein C8R44DRAFT_984739 [Mycena epipterygia] | diamond | 1317 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena epipterygia | |
| 28905592 | 28905592 | PRJNA290839_P_NODE_1468_length_245_cov_0.901163_g1447_i0 | PRJNA290839 | 1468 | 245 | 0.901163 | 2.20784935 | Mycena olivaceomarginata | 230810 | Fungi | Fungi | 111 | 1.04e-26 | NR | KAJ7794263.1 | 230810 | g1447 | i0 | 58 | 0.991836734693878 | 81 | 34 | 99.2 | 0 | 245 | 3 | 163 | 243 | KAJ7794263.1 hypothetical protein B0H14DRAFT_3159162 [Mycena olivaceomarginata] | diamond | 243 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena olivaceomarginata | |
| 30422129 | 30422129 | PRJNA290839_P_NODE_1493_length_245_cov_0.889535_g1472_i0 | PRJNA290839 | 1493 | 245 | 0.889535 | 2.17936075 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 65.5 | 3.01e-10 | NR | XP_025598439.1 | 58919 | g1472 | i0 | 48.1 | 0.942857142857143 | 77 | 33 | 94.3 | 3 | 244 | 14 | 182 | 251 | XP_025598439.1 RNA-binding domain-containing protein [Tilletiopsis washingtonensis] | diamond | 231 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 32413849 | 32413849 | PRJNA290839_P_NODE_1039_length_252_cov_0.871508_g1018_i0 | PRJNA290839 | 1039 | 252 | 0.871508 | 2.19620016 | Gloeophyllum trabeum ATCC 11539 | 670483 | Fungi | Fungi | 64.7 | 7.51e-10 | NR | XP_007863318.1 | 670483 | g1018 | i0 | 47 | 0.988095238095238 | 83 | 36 | 98.8 | 2 | 251 | 3 | 193 | 267 | XP_007863318.1 polyadenylate binding protein [Gloeophyllum trabeum ATCC 11539] | diamond | 249 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum trabeum | |
| 32494849 | 32494849 | PRJNA290839_P_NODE_739_length_297_cov_1.424107_g718_i0 | PRJNA290839 | 739 | 297 | 1.424107 | 4.22959779 | Agaricomycetes | 155619 | Fungi | Fungi | 79.7 | 3.16e-16 | NR | TFK55919.1 | 5364 | g718 | i0 | 42.6 | 4.02020202020202 | 101 | 52 | 96 | 2 | 13 | 297 | 1 | 101 | TFK55919.1 translationally controlled tumor-associated [Heliocybe sulcata] | diamond | 1194 | 80.1 | 0.995006242197254 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Heliocybe | Heliocybe sulcata |
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);;