contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA846086" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 832869 | 832869 | PRJNA846086_P_NODE_1221_length_337_cov_2.204545_g1155_i0 | PRJNA846086 | 1221 | 337 | 2.204545 | 7.42931665 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 2.0700000000000003e-123 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g1155 | i0 | 91.716 | 79.9910979228487 | 338 | 13 | 100 | 11 | 1 | 337 | 3298 | 2975 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 26957 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 832912 | 832912 | PRJNA846086_P_NODE_4161_length_247_cov_0.885057_g4095_i0 | PRJNA846086 | 4161 | 247 | 0.885057 | 2.18609079 | Puccinia triticina | 208348 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|2436894642|ref|XM_053162716.1| | 208348 | g4095 | i0 | 100 | 1.9919028340081 | 247 | 0 | 100 | 0 | 1 | 247 | 269 | 515 | Puccinia triticina uncharacterized protein (PtA15_13A510), partial mRNA | blastn | 492 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 832921 | 832921 | PRJNA846086_P_NODE_4601_length_245_cov_0.895349_g4535_i0 | PRJNA846086 | 4601 | 245 | 0.895349 | 2.19360505 | Malassezia globosa | 76773 | Fungi | Fungi | 442 | 1.1199999999999994e-119 | NTclustered | gi|164655476|ref|XM_001728816.1| | 425265 | g4535 | i0 | 99.184 | 1 | 245 | 2 | 100 | 0 | 1 | 245 | 2373 | 2129 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4035), partial mRNA | blastn | 245 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 832923 | 832923 | PRJNA846086_P_NODE_4941_length_243_cov_0.905882_g4875_i0 | PRJNA846086 | 4941 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 211 | 3.41e-50 | NTclustered | gi|1546631702|ref|XM_027627511.1| | 76775 | g4875 | i0 | 99.145 | 0.720164609053498 | 117 | 1 | 72 | 0 | 127 | 243 | 163 | 47 | Malassezia restricta urea transporter (MRET_0884), partial mRNA | blastn | 175 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2108361 | 2108361 | PRJNA846086_P_NODE_5522_length_241_cov_0.916667_g5456_i0 | PRJNA846086 | 5522 | 241 | 0.916667 | 2.20916747 | Cystobasidium minutum | 29899 | Fungi | Fungi | 268 | 1.98e-67 | NTclustered | gi|2781624337|ref|XM_066966859.1| | 1397322 | g5456 | i0 | 100 | 0.734439834024896 | 145 | 0 | 73 | 0 | 1 | 145 | 60 | 204 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_190969), mRNA | blastn | 177 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 3783096 | 3783096 | PRJNA846086_P_NODE_2083_length_278_cov_2.502439_g2017_i0 | PRJNA846086 | 2083 | 278 | 2.502439 | 6.95678042 | Opisthokonta | 33154 | Fungi | Fungi | 514 | 2.7199999999999996e-141 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g2017 | i0 | 100 | 100.208633093525 | 278 | 0 | 100 | 0 | 1 | 278 | 214 | 491 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 27858 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5936033 | 5936033 | PRJNA846086_P_NODE_3105_length_251_cov_0.865169_g3039_i0 | PRJNA846086 | 3105 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 250 | 7.52e-62 | NTclustered | gi|1546629979|ref|XM_027626650.1| | 76775 | g3039 | i0 | 94.444 | 0.645418326693227 | 162 | 9 | 65 | 0 | 1 | 162 | 163 | 2 | Malassezia restricta U4/U6 small nuclear ribonucleoprotein SNU13 (MRET_0023), partial mRNA | blastn | 162 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5936042 | 5936042 | PRJNA846086_P_NODE_3565_length_249_cov_0.875000_g3499_i0 | PRJNA846086 | 3565 | 249 | 0.875 | 2.17875 | Malassezia globosa | 76773 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|164662610|ref|XM_001732375.1| | 425265 | g3499 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 222 | 249 | 134 | 161 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0202), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7210963 | 7210963 | PRJNA846086_P_NODE_1646_length_296_cov_2.672646_g1580_i0 | PRJNA846086 | 1646 | 296 | 2.672646 | 7.91103216 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 3.88e-120 | NTclustered | gi|1546634130|ref|XM_027628725.1| | 76775 | g1580 | i0 | 96.296 | 0.912162162162162 | 270 | 10 | 91 | 0 | 27 | 296 | 539 | 270 | Malassezia restricta altered inheritance of mitochondria protein 13 (MRET_2098), partial mRNA | blastn | 270 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11036566 | 11036566 | PRJNA846086_P_NODE_3909_length_248_cov_0.880000_g3843_i0 | PRJNA846086 | 3909 | 248 | 0.88 | 2.1824 | Filobasidium floriforme | 5210 | Fungi | Fungi | 425 | 1.15e-114 | NTclustered | gi|2185531039|ref|XM_046181889.1| | 5210 | g3843 | i0 | 97.581 | 1 | 248 | 6 | 100 | 0 | 1 | 248 | 412 | 165 | Filobasidium floriforme density-regulated protein DRP1 (HD553DRAFT_328745), partial mRNA | blastn | 248 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 12710807 | 12710807 | PRJNA846086_P_NODE_1710_length_291_cov_2.036697_g1644_i0 | PRJNA846086 | 1710 | 291 | 2.036697 | 5.92678827 | Malassezia | 55193 | Fungi | Fungi | 538 | 1.6999999999999994e-148 | NTclustered | gi|353078764|gb|JN651964.1| | 76775 | g1644 | i0 | 100 | 99.8213058419244 | 291 | 0 | 100 | 0 | 1 | 291 | 21 | 311 | Malassezia restricta strain NCCPF 127036 26S ribosomal RNA gene, partial sequence | blastn | 29048 | 538 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17808750 | 17808750 | PRJNA846086_P_NODE_334_length_658_cov_3.174359_g271_i0 | PRJNA846086 | 334 | 658 | 3.174359 | 20.88728222 | Symmetrospora | 1798808 | Fungi | Fungi | 1177 | 0 | NTclustered | gi|1858897746|ref|NG_069416.1| | 5441 | g271 | i0 | 98.936 | 93.5212765957447 | 658 | 7 | 100 | 0 | 1 | 658 | 679 | 22 | Symmetrospora oryzicola CBS 7228 28S rRNA gene, partial sequence; from TYPE material | blastn | 61537 | 1182 | 0.995769881556684 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora oryzicola | ||
| 18684126 | 18684126 | PRJNA846086_P_NODE_3135_length_251_cov_0.865169_g3069_i0 | PRJNA846086 | 3135 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 412 | 9.06e-111 | NTclustered | gi|1546630701|ref|XM_027627011.1| | 76775 | g3069 | i0 | 99.558 | 1.0199203187251 | 226 | 1 | 100 | 0 | 26 | 251 | 1052 | 827 | Malassezia restricta hydroxymethylglutaryl-CoA reductase (NADPH) (MRET_0384), partial mRNA | blastn | 256 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19959266 | 19959266 | PRJNA846086_P_NODE_256_length_764_cov_3.259045_g198_i0 | PRJNA846086 | 256 | 764 | 3.259045 | 24.8991038 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 1164 | 0 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g198 | i0 | 94.241 | 95.3390052356021 | 764 | 41 | 100 | 1 | 1 | 764 | 4355 | 3595 | Cystobasidium laryngis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 72839 | 1164 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 21234985 | 21234985 | PRJNA846086_P_NODE_817_length_404_cov_2.637462_g751_i0 | PRJNA846086 | 817 | 404 | 2.637462 | 10.65534648 | Symmetrospora foliicola | 5434 | Fungi | Fungi | 747 | 0 | NTclustered | gi|1694443665|ref|NG_065486.1| | 5434 | g751 | i0 | 100 | 100 | 404 | 0 | 100 | 0 | 1 | 404 | 519 | 116 | Symmetrospora foliicola JCM 5355 18S rRNA gene, partial sequence; from TYPE material | blastn | 40400 | 747 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora foliicola | ||
| 22509702 | 22509702 | PRJNA846086_P_NODE_3098_length_251_cov_0.865169_g3032_i0 | PRJNA846086 | 3098 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 241 | 4.52e-59 | NTclustered | gi|1546630777|ref|XM_027627049.1| | 76775 | g3032 | i0 | 100 | 0.816733067729084 | 130 | 0 | 52 | 0 | 1 | 130 | 130 | 1 | Malassezia restricta uncharacterized protein (MRET_0422), partial mRNA | blastn | 205 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25457826 | 25457826 | PRJNA846086_P_NODE_920_length_380_cov_2.508143_g854_i0 | PRJNA846086 | 920 | 380 | 2.508143 | 9.5309434 | Cystobasidiomycetes | 432005 | Fungi | Fungi | 697 | 0 | NTclustered | gi|996412224|gb|KJ708433.1| | 5435 | g854 | i0 | 99.737 | 100.010526315789 | 380 | 1 | 100 | 0 | 1 | 380 | 1106 | 727 | Symmetrospora gracilis 18S ribosomal RNA gene, partial sequence | blastn | 38004 | 697 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora gracilis |
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);;