contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3272836 | 3272836 | PRJNA741997_P_NODE_46003_length_320_cov_0.935223_g44883_i0 | PRJNA741997 | 46003 | 320 | 0.935223 | 2.9927136 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 296 | 1.26e-75 | NTclustered | gi|1027006864|ref|XM_016754818.1| | 645134 | g44883 | i0 | 86.131 | 84.659375 | 274 | 38 | 86 | 0 | 12 | 285 | 386 | 113 | Spizellomyces punctatus DAOM BR117 hsp71-like protein (SPPG_06618), mRNA | blastn | 27091 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 3272868 | 3272868 | PRJNA741997_P_NODE_52023_length_298_cov_1.493333_g50903_i0 | PRJNA741997 | 52023 | 298 | 1.493333 | 4.45013234 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 246 | 1.18e-60 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g50903 | i0 | 81.879 | 95.9765100671141 | 298 | 48 | 99 | 6 | 1 | 295 | 876 | 1170 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 28601 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 4549905 | 4549905 | PRJNA741997_P_NODE_28704_length_410_cov_1.786350_g27584_i0 | PRJNA741997 | 28704 | 410 | 1.78635 | 7.324035 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 255 | 2.7999999999999997e-63 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g27584 | i0 | 82 | 53.580487804878 | 300 | 54 | 73 | 0 | 106 | 405 | 696 | 397 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 21968 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 5825132 | 5825132 | PRJNA741997_P_NODE_51305_length_300_cov_2.162996_g50185_i0 | PRJNA741997 | 51305 | 300 | 2.162996 | 6.488988 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 180 | 1.2299999999999999e-40 | NTclustered | gi|1027002514|ref|XM_016754407.1| | 645134 | g50185 | i0 | 78.889 | 39.7066666666667 | 270 | 53 | 89 | 4 | 33 | 300 | 489 | 222 | Spizellomyces punctatus DAOM BR117 ubiquitin-40S ribosomal protein S27a (SPPG_06203), partial mRNA | blastn | 11912 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 8374607 | 8374607 | PRJNA741997_P_NODE_13467_length_663_cov_6.238983_g12389_i0 | PRJNA741997 | 13467 | 663 | 6.238983 | 41.36445729 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 200 | 2.23e-46 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g12389 | i0 | 76.485 | 21 | 404 | 73 | 60 | 16 | 76 | 471 | 134 | 523 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8374613 | 8374613 | PRJNA741997_P_NODE_14447_length_634_cov_5.404635_g13355_i0 | PRJNA741997 | 14447 | 634 | 5.404635 | 34.2653859 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 291 | 1.23e-73 | NTclustered | gi|2432157454|ref|XM_053111646.1| | 110093 | g13355 | i0 | 77.756 | 36.1056782334385 | 508 | 89 | 79 | 18 | 18 | 516 | 731 | 239 | Polychytrium aggregatum WD40-repeat-containing domain protein (BJ171DRAFT_512219), mRNA | blastn | 22891 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8374834 | 8374834 | PRJNA741997_P_NODE_53127_length_294_cov_2.628959_g52007_i0 | PRJNA741997 | 53127 | 294 | 2.628959 | 7.72913946 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 143 | 1.57e-29 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g52007 | i0 | 77.686 | 69.530612244898 | 242 | 48 | 81 | 4 | 9 | 247 | 38 | 276 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 20442 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9649851 | 9649851 | PRJNA741997_P_NODE_28508_length_412_cov_1.135693_g27388_i0 | PRJNA741997 | 28508 | 412 | 1.135693 | 4.67905516 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 159 | 2.27e-34 | NTclustered | gi|2432132579|ref|XM_053106383.1| | 110093 | g27388 | i0 | 87.143 | 28.3131067961165 | 140 | 18 | 34 | 0 | 3 | 142 | 1538 | 1677 | Polychytrium aggregatum heat shock protein 70 family (BJ171DRAFT_212372), mRNA | blastn | 11665 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9649996 | 9649996 | PRJNA741997_P_NODE_53428_length_293_cov_5.204545_g52308_i0 | PRJNA741997 | 53428 | 293 | 5.204545 | 15.24931685 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 7.339999999999999e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g52308 | i0 | 84.252 | 7.32764505119454 | 127 | 16 | 43 | 3 | 162 | 286 | 148 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 2147 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17299506 | 17299506 | PRJNA741997_P_NODE_30754_length_394_cov_2.071651_g29634_i0 | PRJNA741997 | 30754 | 394 | 2.071651 | 8.16230494 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 237 | 9.7e-58 | NTclustered | gi|2432095815|ref|XM_053071167.1| | 1396493 | g29634 | i0 | 78.63 | 17.0253807106599 | 365 | 72 | 92 | 6 | 3 | 364 | 524 | 163 | Fimicolochytrium jonesii putative 40S ribosomal protein RPS14 (EV422DRAFT_540950), mRNA | blastn | 6708 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 17299620 | 17299620 | PRJNA741997_P_NODE_48654_length_310_cov_1.299578_g47534_i0 | PRJNA741997 | 48654 | 310 | 1.299578 | 4.0286918 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 307 | 5.6e-79 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g47534 | i0 | 84.516 | 90.5483870967742 | 310 | 48 | 100 | 0 | 1 | 310 | 577 | 268 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 28070 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19848445 | 19848445 | PRJNA741997_P_NODE_3936_length_1392_cov_2.099318_g3420_i0 | PRJNA741997 | 3936 | 1392 | 2.099318 | 29.22250656 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 654 | 0 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g3420 | i0 | 77.17 | 72.4116379310345 | 1152 | 245 | 82 | 16 | 57 | 1199 | 241 | 1383 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 100797 | 654 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21123928 | 21123928 | PRJNA741997_P_NODE_26077_length_434_cov_2.819945_g24957_i0 | PRJNA741997 | 26077 | 434 | 2.819945 | 12.2385613 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 405 | 2.79e-108 | NTclustered | gi|1759157514|ref|XM_031170312.1| | 1806994 | g24957 | i0 | 83.841 | 97.1290322580645 | 427 | 67 | 98 | 2 | 2 | 427 | 298 | 723 | Synchytrium microbalum uncharacterized protein (SmJEL517_g04384), partial mRNA | blastn | 42154 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 21124068 | 21124068 | PRJNA741997_P_NODE_50097_length_305_cov_1.327586_g48977_i0 | PRJNA741997 | 50097 | 305 | 1.327586 | 4.0491373 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 198 | 3.45e-46 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g48977 | i0 | 79.07 | 79.072131147541 | 301 | 53 | 96 | 7 | 1 | 293 | 336 | 38 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 24117 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23674649 | 23674649 | PRJNA741997_P_NODE_73459_length_250_cov_0.870056_g72339_i0 | PRJNA741997 | 73459 | 250 | 0.870056 | 2.17514 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 230 | 9.75e-56 | NTclustered | gi|1026955692|ref|XM_016750072.1| | 645134 | g72339 | i0 | 83.267 | 23.592 | 251 | 40 | 100 | 2 | 1 | 250 | 3430 | 3181 | Spizellomyces punctatus DAOM BR117 splicing factor 3B subunit 1 (SPPG_01758), mRNA | blastn | 5898 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus |
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);;