contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7238514 | 7238514 | PRJNA884104_S_NODE_2146_length_1351_cov_3.676839_g1842_i0 | PRJNA884104 | 2146 | 1351 | 3.676839 | 49.67409489 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 688 | 0 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g1842 | i0 | 77.691 | 76.1014063656551 | 1152 | 239 | 85 | 16 | 115 | 1257 | 1383 | 241 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 102813 | 688 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8513046 | 8513046 | PRJNA884104_S_NODE_11027_length_608_cov_1.609346_g10307_i0 | PRJNA884104 | 11027 | 608 | 1.609346 | 9.78482368 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 374 | 1.13e-98 | NTclustered | gi|2432147654|ref|XM_053111044.1| | 110093 | g10307 | i0 | 82.517 | 65.4128289473684 | 429 | 71 | 70 | 4 | 148 | 574 | 1024 | 1450 | Polychytrium aggregatum Enolase, C-terminal TIM barrel domain-containing protein (BJ171DRAFT_505639), mRNA | blastn | 39771 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8513415 | 8513415 | PRJNA884104_S_NODE_29807_length_373_cov_2.180000_g29064_i0 | PRJNA884104 | 29807 | 373 | 2.18 | 8.1314 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 342 | 1.88e-89 | NTclustered | gi|2432130078|ref|XM_053109045.1| | 110093 | g29064 | i0 | 83.651 | 44.8552278820375 | 367 | 57 | 98 | 3 | 2 | 366 | 1199 | 834 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_484843), mRNA | blastn | 16731 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8514247 | 8514247 | PRJNA884104_S_NODE_72427_length_249_cov_0.875000_g71684_i0 | PRJNA884104 | 72427 | 249 | 0.875 | 2.17875 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 176 | 1.28e-39 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g71684 | i0 | 85.976 | 12.3574297188755 | 164 | 23 | 66 | 0 | 84 | 247 | 51 | 214 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 3077 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9788998 | 9788998 | PRJNA884104_S_NODE_57248_length_276_cov_2.182266_g56505_i0 | PRJNA884104 | 57248 | 276 | 2.182266 | 6.02305416 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 183 | 8.629999999999998e-42 | NTclustered | gi|2432129754|ref|XM_053108222.1| | 110093 | g56505 | i0 | 78.623 | 17.536231884058 | 276 | 59 | 100 | 0 | 1 | 276 | 897 | 1172 | Polychytrium aggregatum DEAD box ATP-dependent RNA helicase (BJ171DRAFT_453702), mRNA | blastn | 4840 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11063727 | 11063727 | PRJNA884104_S_NODE_10949_length_610_cov_1.666667_g10229_i0 | PRJNA884104 | 10949 | 610 | 1.666667 | 10.1666687 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 134 | 2.1e-26 | NTclustered | gi|2432173894|ref|XM_053107895.1| | 110093 | g10229 | i0 | 72.941 | 13.2377049180328 | 425 | 100 | 69 | 13 | 1 | 419 | 545 | 130 | Polychytrium aggregatum ARM repeat-containing protein (BJ171DRAFT_430377), partial mRNA | blastn | 8075 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11064662 | 11064662 | PRJNA884104_S_NODE_59249_length_272_cov_0.914573_g58506_i0 | PRJNA884104 | 59249 | 272 | 0.914573 | 2.48763856 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 139 | 1.86e-28 | NTclustered | gi|2432165172|ref|XM_053107803.1| | 110093 | g58506 | i0 | 78.281 | 0.8125 | 221 | 44 | 81 | 4 | 53 | 271 | 1836 | 1618 | Polychytrium aggregatum FAD binding domain-containing protein (BJ171DRAFT_427326), partial mRNA | blastn | 221 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16163228 | 16163228 | PRJNA884104_S_NODE_28813_length_379_cov_2.052288_g28070_i0 | PRJNA884104 | 28813 | 379 | 2.052288 | 7.77817152 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 307 | 6.980000000000001e-79 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g28070 | i0 | 81.53 | 81.3852242744063 | 379 | 64 | 99 | 6 | 4 | 379 | 1367 | 992 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 30845 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21263629 | 21263629 | PRJNA884104_S_NODE_8697_length_686_cov_12.812398_g8001_i0 | PRJNA884104 | 8697 | 686 | 12.812398 | 87.89305028 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 211 | 1.0700000000000001e-49 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g8001 | i0 | 76.98 | 22.1574344023324 | 404 | 71 | 58 | 16 | 218 | 613 | 523 | 134 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 15200 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22537304 | 22537304 | PRJNA884104_S_NODE_31258_length_365_cov_6.883562_g30515_i0 | PRJNA884104 | 31258 | 365 | 6.883562 | 25.1250013 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 152 | 3.32e-32 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g30515 | i0 | 83.234 | 19.0602739726027 | 167 | 27 | 46 | 1 | 188 | 354 | 181 | 346 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 6957 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 23813325 | 23813325 | PRJNA884104_S_NODE_57959_length_275_cov_1.108911_g57216_i0 | PRJNA884104 | 57959 | 275 | 1.108911 | 3.04950525 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 183 | 8.59e-42 | NTclustered | gi|2432164384|ref|XM_053112101.1| | 110093 | g57216 | i0 | 78.832 | 67.1927272727273 | 274 | 56 | 99 | 2 | 3 | 275 | 1018 | 1290 | Polychytrium aggregatum asparagine synthase (BJ171DRAFT_517157), mRNA | blastn | 18478 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23813503 | 23813503 | PRJNA884104_S_NODE_67099_length_254_cov_0.861878_g66356_i0 | PRJNA884104 | 67099 | 254 | 0.861878 | 2.18917012 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 82.4 | 2.94e-11 | NTclustered | gi|1026971811|ref|XM_016751649.1| | 645134 | g66356 | i0 | 87.671 | 3.20472440944882 | 73 | 5 | 28 | 3 | 11 | 81 | 422 | 492 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S23 (SPPG_03379), mRNA | blastn | 814 | 82.4 | 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);;