contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA758770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1204571 | 1204571 | PRJNA758770_S_NODE_14021_length_311_cov_2.945378_g13895_i0 | PRJNA758770 | 14021 | 311 | 2.945378 | 9.16012558 | Hannaella | 663591 | Fungi | Fungi | 575 | 1.3899999999999995e-159 | NTclustered | gi|1869471870|gb|MT756507.1| | 4983 | g13895 | i0 | 100 | 98.9163987138264 | 311 | 0 | 100 | 0 | 1 | 311 | 221 | 531 | Hannaella sinensis strain BRT171 large subunit ribosomal RNA gene, partial sequence | blastn | 30763 | 575 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Hannaella | Hannaella sinensis | |
| 2016548 | 2016548 | PRJNA758770_S_NODE_21062_length_265_cov_1.000000_g20936_i0 | PRJNA758770 | 21062 | 265 | 1 | 2.65 | Cystobasidium minutum | 29899 | Fungi | Fungi | 484 | 2.0199999999999998e-132 | NTclustered | gi|2781610637|ref|XM_066966477.1| | 1397322 | g20936 | i0 | 99.623 | 72.6830188679245 | 265 | 1 | 100 | 0 | 1 | 265 | 536 | 800 | Cystobasidium minutum MCA 4210 putative ADP/ATP carrier of the mitochondrial inner membrane (P389DRAFT_183614), partial mRNA | blastn | 19261 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 3291786 | 3291786 | PRJNA758770_S_NODE_20263_length_269_cov_1.857143_g20137_i0 | PRJNA758770 | 20263 | 269 | 1.857143 | 4.99571467 | Dioszegia hungarica | 4972 | Fungi | Fungi | 392 | 1.28e-104 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g20137 | i0 | 92.989 | 144.918215613383 | 271 | 15 | 100 | 4 | 1 | 269 | 3317 | 3049 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 38983 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 5032910 | 5032910 | PRJNA758770_S_NODE_12964_length_320_cov_4.000000_g12838_i0 | PRJNA758770 | 12964 | 320 | 4 | 12.8 | Hannaella | 663591 | Fungi | Fungi | 592 | 1.4299999999999996e-164 | NTclustered | gi|83284983|gb|DQ297411.1| | 4983 | g12838 | i0 | 100 | 96.59375 | 320 | 0 | 100 | 0 | 1 | 320 | 722 | 403 | Bullera sinensis internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 30910 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Hannaella | Hannaella sinensis | |
| 8393958 | 8393958 | PRJNA758770_S_NODE_27467_length_248_cov_0.891429_g27341_i0 | PRJNA758770 | 27467 | 248 | 0.891429 | 2.21074392 | Cutaneotrichosporon cavernicola | 279322 | Fungi | Fungi | 58.4 | 4.82e-4 | NTclustered | gi|2612487950|ref|XM_060599140.1| | 279322 | g27341 | i0 | 92.857 | 0.971774193548387 | 42 | 0 | 16 | 1 | 12 | 50 | 714 | 755 | Cutaneotrichosporon cavernicola uncharacterized protein (CcaverHIS019_0306680), partial mRNA | blastn | 241 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon cavernicola | |
| 10944750 | 10944750 | PRJNA758770_S_NODE_25489_length_250_cov_2.824859_g25363_i0 | PRJNA758770 | 25489 | 250 | 2.824859 | 7.0621475 | Dioszegia hungarica | 4972 | Fungi | Fungi | 363 | 9.209999999999997e-96 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g25363 | i0 | 92.8 | 118.972 | 250 | 18 | 100 | 0 | 1 | 250 | 2200 | 1951 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 29743 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 10944843 | 10944843 | PRJNA758770_S_NODE_29189_length_246_cov_0.901734_g29063_i0 | PRJNA758770 | 29189 | 246 | 0.901734 | 2.21826564 | Cystobasidium minutum | 29899 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|2781611323|ref|XM_066967538.1| | 1397322 | g29063 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 897 | 652 | Cystobasidium minutum MCA 4210 mitochondrial carrier (P389DRAFT_195979), partial mRNA | blastn | 246 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 13494375 | 13494375 | PRJNA758770_S_NODE_23451_length_253_cov_0.866667_g23325_i0 | PRJNA758770 | 23451 | 253 | 0.866667 | 2.19266751 | Kwoniella mangrovensis | 463800 | Fungi | Fungi | 128 | 3.71e-25 | NTclustered | gi|2736856876|ref|XM_065517170.1| | 1296122 | g23325 | i0 | 82.759 | 1.68379446640316 | 145 | 23 | 57 | 2 | 109 | 252 | 246 | 103 | Kwoniella mangroviensis CBS 8507 40S ribosomal protein S27 (I203_102716), partial mRNA | blastn | 426 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella mangrovensis | |
| 17319035 | 17319035 | PRJNA758770_S_NODE_31734_length_243_cov_0.917647_g31608_i0 | PRJNA758770 | 31734 | 243 | 0.917647 | 2.22988221 | Cystobasidium minutum | 29899 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|2781596446|ref|XM_066969264.1| | 1397322 | g31608 | i0 | 100 | 1 | 243 | 0 | 100 | 0 | 1 | 243 | 1058 | 1300 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_39994), mRNA | blastn | 243 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 23693581 | 23693581 | PRJNA758770_S_NODE_24999_length_251_cov_0.876404_g24873_i0 | PRJNA758770 | 24999 | 251 | 0.876404 | 2.19977404 | Cystobasidium minutum | 29899 | Fungi | Fungi | 464 | 2.47e-126 | NTclustered | gi|2781622177|ref|XM_066964263.1| | 1397322 | g24873 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 689 | 939 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_154498), mRNA | blastn | 251 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 23693672 | 23693672 | PRJNA758770_S_NODE_28759_length_247_cov_0.896552_g28633_i0 | PRJNA758770 | 28759 | 247 | 0.896552 | 2.21448344 | Cystobasidium minutum | 29899 | Fungi | Fungi | 272 | 1.5699999999999999e-68 | NTclustered | gi|2781619415|ref|XM_066968130.1| | 1397322 | g28633 | i0 | 100 | 0.595141700404858 | 147 | 0 | 60 | 0 | 101 | 247 | 1 | 147 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_205404), partial mRNA | blastn | 147 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 24967461 | 24967461 | PRJNA758770_S_NODE_7180_length_402_cov_4.474164_g7054_i0 | PRJNA758770 | 7180 | 402 | 4.474164 | 17.98613928 | Dioszegia hungarica | 4972 | Fungi | Fungi | 573 | 6.649999999999998e-159 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g7054 | i0 | 92.327 | 151.291044776119 | 404 | 29 | 100 | 2 | 1 | 402 | 1483 | 1886 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 60819 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica |
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);;