contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003062 | 2003062 | PRJNA752278_P_NODE_19482_length_358_cov_6.357895_g19279_i0 | PRJNA752278 | 19482 | 358 | 6.357895 | 22.761264100000002 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 5.48e-25 | NTclustered | gi|2432097581|ref|XM_053071233.1| | 1396493 | g19279 | i0 | 82.313 | 5.44692737430168 | 147 | 26 | 41 | 0 | 33 | 179 | 83 | 229 | Fimicolochytrium jonesii 30S ribosomal protein S30e (EV422DRAFT_541825), mRNA | blastn | 1950 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 2003316 | 2003316 | PRJNA752278_P_NODE_3162_length_688_cov_71.801626_g2969_i0 | PRJNA752278 | 3162 | 688 | 71.801626 | 493.99518688 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 1.0800000000000001e-44 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g2969 | i0 | 76.238 | 20.2369186046512 | 404 | 74 | 58 | 16 | 217 | 612 | 523 | 134 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 5029024 | 5029024 | PRJNA752278_P_NODE_224_length_1783_cov_4.920468_g165_i0 | PRJNA752278 | 224 | 1783 | 4.920468 | 87.73194444 | Opisthokonta | 33154 | Fungi | Fungi | 1050 | 0 | NTclustered | gi|2432171462|ref|XM_053112561.1| | 110093 | g165 | i0 | 79.721 | 82.6225462703309 | 1504 | 264 | 83 | 31 | 78 | 1559 | 672 | 2156 | Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA | blastn | 147316 | 1050 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7105751 | 7105751 | PRJNA752278_P_NODE_18826_length_363_cov_1.813793_g18623_i0 | PRJNA752278 | 18826 | 363 | 1.813793 | 6.58406859 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 207 | 6.94e-49 | NTclustered | gi|2432132239|ref|XM_053109464.1| | 110093 | g18623 | i0 | 78.947 | 7.72727272727273 | 323 | 54 | 86 | 11 | 1 | 313 | 227 | 545 | Polychytrium aggregatum ribosomal protein S17-domain-containing protein (BJ171DRAFT_489270), mRNA | blastn | 2805 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9655221 | 9655221 | PRJNA752278_P_NODE_104068_length_241_cov_0.916667_g103865_i0 | PRJNA752278 | 104068 | 241 | 0.916667 | 2.20916747 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2432129828|ref|XM_053108226.1| | 110093 | g103865 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 22 | 50 | 369 | 397 | Polychytrium aggregatum NUC169 domain-containing protein (BJ171DRAFT_453745), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9655353 | 9655353 | PRJNA752278_P_NODE_11408_length_433_cov_2.936111_g11205_i0 | PRJNA752278 | 11408 | 433 | 2.936111 | 12.71336063 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 198 | 5.0699999999999996e-46 | NTclustered | gi|2432149348|ref|XM_053111166.1| | 110093 | g11205 | i0 | 80.15 | 18.2886836027714 | 267 | 51 | 61 | 2 | 156 | 421 | 198 | 463 | Polychytrium aggregatum ribosomal protein S19-domain-containing protein (BJ171DRAFT_506928), mRNA | blastn | 7919 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9655538 | 9655538 | PRJNA752278_P_NODE_20288_length_353_cov_2.689286_g20085_i0 | PRJNA752278 | 20288 | 353 | 2.689286 | 9.49317958 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 52.8 | 0.033 | NTclustered | gi|1759167731|ref|XM_031171997.1| | 1806994 | g20085 | i0 | 100 | 0.0793201133144476 | 28 | 0 | 8 | 0 | 245 | 272 | 1565 | 1592 | Synchytrium microbalum uncharacterized protein (SmJEL517_g06071), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 10931155 | 10931155 | PRJNA752278_P_NODE_2669_length_734_cov_11.275340_g2478_i0 | PRJNA752278 | 2669 | 734 | 11.27534 | 82.7609956 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 307 | 1.42e-78 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g2478 | i0 | 82.899 | 45.4632152588556 | 345 | 55 | 47 | 4 | 392 | 734 | 1800 | 1458 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 33370 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14755873 | 14755873 | PRJNA752278_P_NODE_1772_length_853_cov_3.683333_g1596_i0 | PRJNA752278 | 1772 | 853 | 3.683333 | 31.41883049 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 357 | 1.63e-93 | NTclustered | gi|2432132579|ref|XM_053106383.1| | 110093 | g1596 | i0 | 79.879 | 47.8792497069168 | 497 | 92 | 58 | 8 | 1 | 493 | 1269 | 1761 | Polychytrium aggregatum heat shock protein 70 family (BJ171DRAFT_212372), mRNA | blastn | 40841 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14756217 | 14756217 | PRJNA752278_P_NODE_332_length_1594_cov_10.614727_g252_i0 | PRJNA752278 | 332 | 1594 | 10.614727 | 169.19874838 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 649 | 0 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g252 | i0 | 77.083 | 63.3839397741531 | 1152 | 246 | 72 | 16 | 363 | 1505 | 1383 | 241 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 101034 | 649 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14756720 | 14756720 | PRJNA752278_P_NODE_60692_length_267_cov_1.525773_g60489_i0 | PRJNA752278 | 60692 | 267 | 1.525773 | 4.07381391 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 174 | 5e-39 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g60489 | i0 | 85.89 | 59.9475655430712 | 163 | 23 | 61 | 0 | 3 | 165 | 158 | 320 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 16006 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14757047 | 14757047 | PRJNA752278_P_NODE_77572_length_251_cov_1.404494_g77369_i0 | PRJNA752278 | 77572 | 251 | 1.404494 | 3.52527994 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 239 | 1.6300000000000002e-58 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g77369 | i0 | 84.647 | 31.6852589641434 | 241 | 35 | 96 | 2 | 3 | 242 | 61 | 300 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 7953 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16029540 | 16029540 | PRJNA752278_P_NODE_12393_length_420_cov_87.636888_g12190_i0 | PRJNA752278 | 12393 | 420 | 87.636888 | 368.0749296 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 1.09e-22 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g12190 | i0 | 84.252 | 5.11190476190476 | 127 | 16 | 30 | 3 | 253 | 377 | 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 | ||
| 16030379 | 16030379 | PRJNA752278_P_NODE_57253_length_270_cov_1.827411_g57050_i0 | PRJNA752278 | 57253 | 270 | 1.827411 | 4.9340097 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 187 | 6.4999999999999984e-43 | NTclustered | gi|1759149897|ref|XM_031168724.1| | 1806994 | g57050 | i0 | 79.401 | 22.4111111111111 | 267 | 53 | 99 | 2 | 5 | 270 | 3620 | 3355 | Synchytrium microbalum uncharacterized protein (SmJEL517_g02796), partial mRNA | blastn | 6051 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 17306271 | 17306271 | PRJNA752278_P_NODE_77854_length_251_cov_0.865169_g77651_i0 | PRJNA752278 | 77854 | 251 | 0.865169 | 2.17157419 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 189 | 1.6599999999999996e-43 | NTclustered | gi|2432095821|ref|XM_053071168.1| | 1396493 | g77651 | i0 | 89.333 | 37.6653386454183 | 150 | 16 | 60 | 0 | 41 | 190 | 120 | 269 | Fimicolochytrium jonesii ribosomal protein S27-domain-containing protein (EV422DRAFT_540954), mRNA | blastn | 9454 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 21130877 | 21130877 | PRJNA752278_P_NODE_85497_length_248_cov_1.228571_g85294_i0 | PRJNA752278 | 85497 | 248 | 1.228571 | 3.04685608 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 126 | 1.2999999999999998e-24 | NTclustered | gi|1759155094|ref|XM_031169861.1| | 1806994 | g85294 | i0 | 85.833 | 21.1370967741935 | 120 | 15 | 48 | 2 | 96 | 214 | 719 | 601 | Synchytrium microbalum uncharacterized protein (SmJEL517_g03933), partial mRNA | blastn | 5242 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 22404802 | 22404802 | PRJNA752278_P_NODE_3878_length_639_cov_3.019435_g3680_i0 | PRJNA752278 | 3878 | 639 | 3.019435 | 19.29418965 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 381 | 7.129999999999999e-101 | NTclustered | gi|1026954586|ref|XM_016749955.1| | 645134 | g3680 | i0 | 85.479 | 61.4100156494523 | 365 | 53 | 57 | 0 | 243 | 607 | 512 | 148 | Spizellomyces punctatus DAOM BR117 ubiquitin-40S ribosomal protein S27a (SPPG_01636), mRNA | blastn | 39241 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 22405113 | 22405113 | PRJNA752278_P_NODE_5498_length_565_cov_1.774390_g5297_i0 | PRJNA752278 | 5498 | 565 | 1.77439 | 10.0253035 | Piromyces sp. | 45796 | Fungi | Fungi | 241 | 1.11e-58 | NTclustered | gi|1388116266|gb|MH043820.1| | 45796 | g5297 | i0 | 100 | 36.5451327433628 | 130 | 0 | 23 | 0 | 357 | 486 | 130 | 1 | Piromyces sp. strain B5 Glycosyl hydrolase family 43 mRNA, partial cds | blastn | 20648 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. | |
| 24953521 | 24953521 | PRJNA752278_P_NODE_17760_length_370_cov_6.168350_g17557_i0 | PRJNA752278 | 17760 | 370 | 6.16835 | 22.822895 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 117 | 1.2300000000000002e-21 | NTclustered | gi|2432053731|ref|XM_053067537.1| | 1396493 | g17557 | i0 | 81.944 | 3.56216216216216 | 144 | 20 | 38 | 6 | 210 | 350 | 144 | 4 | Fimicolochytrium jonesii cytosolic 60S large ribosomal protein L39 (EV422DRAFT_491467), partial mRNA | blastn | 1318 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;