contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA857857" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3395874 | 3395874 | PRJNA857857_P_NODE_37483_length_251_cov_0.865169_g37034_i0 | PRJNA857857 | 37483 | 251 | 0.865169 | 2.17157419 | Rhizoctonia solani | 456999 | Fungi | Fungi | 324 | 4.37e-84 | NTclustered | gi|2086753789|ref|XM_043320690.1| | 456999 | g37034 | i0 | 90 | 1.99601593625498 | 250 | 25 | 99 | 0 | 2 | 251 | 720 | 471 | Rhizoctonia solani ribosomal S3Ae family (RhiXN_00871), partial mRNA | blastn | 501 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 3787669 | 3787669 | PRJNA857857_P_NODE_43263_length_247_cov_0.885057_g42814_i0 | PRJNA857857 | 43263 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | Fungi | Fungi | 313 | 9.28e-81 | NTclustered | gi|2234730693|ref|XM_048014543.1| | 378194 | g42814 | i0 | 89.516 | 96.82995951417 | 248 | 24 | 100 | 2 | 1 | 247 | 247 | 1 | Epithele typhae actin 1 (BXZ73DRAFT_100304), partial mRNA | blastn | 23917 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 4673754 | 4673754 | PRJNA857857_P_NODE_4504_length_730_cov_3.744292_g4105_i0 | PRJNA857857 | 4504 | 730 | 3.744292 | 27.3333316 | Trichosporon asahii | 82508 | Fungi | Fungi | 488 | 4.6999999999999985e-133 | NTclustered | gi|930406120|ref|XM_014321858.1| | 1186058 | g4105 | i0 | 80.365 | 88.4958904109589 | 657 | 118 | 89 | 10 | 11 | 663 | 665 | 16 | Trichosporon asahii var. asahii CBS 2479 heat shock protein 70 (A1Q1_05051), partial mRNA | blastn | 64602 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 4673953 | 4673953 | PRJNA857857_P_NODE_7804_length_556_cov_1.428571_g7376_i0 | PRJNA857857 | 7804 | 556 | 1.428571 | 7.94285476 | Kwoniella heveanensis | 89924 | Fungi | Fungi | 63.9 | 2.53e-5 | NTclustered | gi|2678478526|gb|CP144517.1| | 1296119 | g7376 | i0 | 100 | 1.44784172661871 | 34 | 0 | 6 | 0 | 471 | 504 | 360207 | 360174 | Kwoniella heveanensis CBS 569 chromosome 4 | blastn | 805 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 5948567 | 5948567 | PRJNA857857_P_NODE_42025_length_248_cov_0.868571_g41576_i0 | PRJNA857857 | 42025 | 248 | 0.868571 | 2.15405608 | Marasmius oreades | 181124 | Fungi | Fungi | 265 | 2.6499999999999997e-66 | NTclustered | gi|2320860986|gb|CP097435.1| | 181124 | g41576 | i0 | 85.887 | 14.4959677419355 | 248 | 35 | 100 | 0 | 1 | 248 | 4207163 | 4207410 | Marasmius oreades strain 43B chromosome 1 | blastn | 3595 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius oreades | |
| 7613836 | 7613836 | PRJNA857857_P_NODE_47286_length_244_cov_0.900585_g46837_i0 | PRJNA857857 | 47286 | 244 | 0.900585 | 2.1974274 | Agaricomycetes | 155619 | Fungi | Fungi | 337 | 5.429999999999998e-88 | NTclustered | gi|530408084|gb|JX988996.1| | 456999 | g46837 | i0 | 94.118 | 86.9795081967213 | 221 | 13 | 91 | 0 | 1 | 221 | 240 | 460 | Rhizoctonia solani strain AG-4_HGII isolate 18Rs 28S ribosomal RNA gene, partial sequence | blastn | 21223 | 340 | 0.991176470588235 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 11048846 | 11048846 | PRJNA857857_P_NODE_40729_length_248_cov_1.320000_g40280_i0 | PRJNA857857 | 40729 | 248 | 1.32 | 3.2736 | Ganoderma lucidum | 5315 | Fungi | Fungi | 403 | 5.38e-108 | NTclustered | gi|77379308|gb|DQ208413.1| | 5315 | g40280 | i0 | 95.968 | 106.028225806452 | 248 | 10 | 100 | 0 | 1 | 248 | 1698 | 1451 | Ganoderma lucidum strain C-2 large subunit ribosomal RNA gene, partial sequence | blastn | 26295 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 11048910 | 11048910 | PRJNA857857_P_NODE_43489_length_246_cov_2.491329_g43040_i0 | PRJNA857857 | 43489 | 246 | 2.491329 | 6.12866934 | Coprinopsis cinerea | 5346 | Fungi | Fungi | 305 | 1.54e-78 | NTclustered | gi|299753593|ref|XM_002911838.1| | 240176 | g43040 | i0 | 89.583 | 78.0813008130081 | 240 | 25 | 98 | 0 | 6 | 245 | 1728 | 1489 | Coprinopsis cinerea okayama7#130 heat shock cognate 70 (CC1G_13924), mRNA | blastn | 19208 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 17423128 | 17423128 | PRJNA857857_P_NODE_28374_length_290_cov_1.336406_g27925_i0 | PRJNA857857 | 28374 | 290 | 1.336406 | 3.8755774 | Rhizoctonia solani | 456999 | Fungi | Fungi | 414 | 2.97e-111 | NTclustered | gi|2086748480|ref|XM_043324785.1| | 456999 | g27925 | i0 | 92.414 | 57.8241379310345 | 290 | 22 | 100 | 0 | 1 | 290 | 817 | 528 | Rhizoctonia solani ATP synthase alpha/beta family (RhiXN_04969), partial mRNA | blastn | 16769 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 17423337 | 17423337 | PRJNA857857_P_NODE_39294_length_249_cov_1.301136_g38845_i0 | PRJNA857857 | 39294 | 249 | 1.301136 | 3.23982864 | Dacryopinax primogenitus | 1858805 | Fungi | Fungi | 217 | 7.55e-52 | NTclustered | gi|2028551215|ref|XM_040776370.1| | 1858805 | g38845 | i0 | 82.745 | 10.5983935742972 | 255 | 32 | 100 | 10 | 1 | 249 | 911 | 663 | Dacryopinax primogenitus plasma-membrane proton-e (DACRYDRAFT_79023), mRNA | blastn | 2639 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Dacryopinax | Dacryopinax primogenitus | |
| 17423483 | 17423483 | PRJNA857857_P_NODE_46074_length_245_cov_0.895349_g45625_i0 | PRJNA857857 | 46074 | 245 | 0.895349 | 2.19360505 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 339 | 1.5199999999999998e-88 | NTclustered | gi|955479755|ref|XM_014797928.1| | 84753 | g45625 | i0 | 91.77 | 0.991836734693878 | 243 | 20 | 99 | 0 | 3 | 245 | 609 | 367 | Moesziomyces antarcticus uncharacterized protein (PAN0_080d6634), partial mRNA | blastn | 243 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 17813153 | 17813153 | PRJNA857857_P_NODE_34154_length_261_cov_1.872340_g33705_i0 | PRJNA857857 | 34154 | 261 | 1.87234 | 4.8868074 | Opisthokonta | 33154 | Fungi | Fungi | 483 | 7.12e-132 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g33705 | i0 | 100 | 99.992337164751 | 261 | 0 | 100 | 0 | 1 | 261 | 470 | 210 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 26098 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22521752 | 22521752 | PRJNA857857_P_NODE_30638_length_279_cov_1.058252_g30189_i0 | PRJNA857857 | 30638 | 279 | 1.058252 | 2.95252308 | Malassezia globosa | 76773 | Fungi | Fungi | 460 | 3.5999999999999997e-125 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g30189 | i0 | 96.466 | 41.8172043010753 | 283 | 3 | 99 | 6 | 2 | 279 | 30241 | 29961 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 11667 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 23797089 | 23797089 | PRJNA857857_P_NODE_25559_length_307_cov_2.730769_g25110_i0 | PRJNA857857 | 25559 | 307 | 2.730769 | 8.38346083 | Malassezia restricta | 76775 | Fungi | Fungi | 562 | 1.07e-155 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g25110 | i0 | 99.674 | 77.6807817589577 | 307 | 1 | 100 | 0 | 1 | 307 | 2978 | 3284 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23848 | 562 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23797214 | 23797214 | PRJNA857857_P_NODE_31179_length_276_cov_1.137931_g30730_i0 | PRJNA857857 | 31179 | 276 | 1.137931 | 3.14068956 | Rhizoctonia solani | 456999 | Fungi | Fungi | 259 | 1.39e-64 | NTclustered | gi|2086747592|ref|XM_043324341.1| | 456999 | g30730 | i0 | 85.039 | 4.04710144927536 | 254 | 38 | 92 | 0 | 1 | 254 | 254 | 1 | Rhizoctonia solani glutamine synthetase (RhiXN_04524), partial mRNA | blastn | 1117 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 25071308 | 25071308 | PRJNA857857_P_NODE_39540_length_249_cov_0.875000_g39091_i0 | PRJNA857857 | 39540 | 249 | 0.875 | 2.17875 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 433 | 6.89e-117 | NTclustered | gi|955496341|ref|XM_014802655.1| | 84753 | g39091 | i0 | 97.992 | 15.1285140562249 | 249 | 5 | 100 | 0 | 1 | 249 | 615 | 367 | Moesziomyces antarcticus ATPase (PAN0_003d1697), partial mRNA | blastn | 3767 | 433 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 25071622 | 25071622 | PRJNA857857_P_NODE_7080_length_583_cov_1.717647_g6653_i0 | PRJNA857857 | 7080 | 583 | 1.717647 | 10.01388201 | Rhodofomes roseus | 34475 | Fungi | Fungi | 54.7 | 0.016 | NTclustered | gi|2234695529|ref|XM_047921521.1| | 34475 | g6653 | i0 | 84.746 | 0.101200686106346 | 59 | 4 | 9 | 5 | 304 | 358 | 445 | 502 | Fomitopsis rosea uncharacterized protein (C8Q71DRAFT_722371), partial mRNA | blastn | 59 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Rhodofomes | Rhodofomes roseus |
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);;