contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1410708 | 1410708 | PRJEB75230_P_NODE_129762_length_249_cov_1.227273_g129580_i0 | PRJEB75230 | 129762 | 249 | 1.227273 | 3.05590977 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 172 | 1.66e-38 | NTclustered | gi|1759146721|ref|XM_031168020.1| | 1806994 | g129580 | i0 | 80.631 | 13.8393574297189 | 222 | 43 | 89 | 0 | 5 | 226 | 1849 | 2070 | Synchytrium microbalum uncharacterized protein (SmJEL517_g02092), partial mRNA | blastn | 3446 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 3962362 | 3962362 | PRJEB75230_P_NODE_140604_length_247_cov_2.597701_g140422_i0 | PRJEB75230 | 140604 | 247 | 2.597701 | 6.41632147 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 172 | 1.64e-38 | NTclustered | gi|2432146242|ref|XM_053110900.1| | 110093 | g140422 | i0 | 80.169 | 26.1862348178138 | 237 | 41 | 95 | 5 | 5 | 238 | 120 | 353 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_503834), mRNA | blastn | 6468 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6514229 | 6514229 | PRJEB75230_P_NODE_12986_length_432_cov_1.980501_g12804_i0 | PRJEB75230 | 12986 | 432 | 1.980501 | 8.55576432 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 217 | 1.4e-51 | NTclustered | gi|2432147654|ref|XM_053111044.1| | 110093 | g12804 | i0 | 85.377 | 58.599537037037 | 212 | 28 | 49 | 3 | 211 | 421 | 1024 | 1233 | Polychytrium aggregatum Enolase, C-terminal TIM barrel domain-containing protein (BJ171DRAFT_505639), mRNA | blastn | 25315 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9064075 | 9064075 | PRJEB75230_P_NODE_185428_length_232_cov_2.905660_g185246_i0 | PRJEB75230 | 185428 | 232 | 2.90566 | 6.7411312 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 100 | 7.3e-17 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g185246 | i0 | 92.754 | 2.62068965517241 | 69 | 5 | 30 | 0 | 4 | 72 | 354 | 286 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 608 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9923998 | 9923998 | PRJEB75230_P_NODE_185708_length_229_cov_14.506410_g185526_i0 | PRJEB75230 | 185708 | 229 | 14.50641 | 33.2196789 | Fungi | 4751 | Fungi | Fungi | 121 | 5.519999999999999e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g185526 | i0 | 84.252 | 11.6113537117904 | 127 | 16 | 55 | 3 | 82 | 206 | 148 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 2659 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11199555 | 11199555 | PRJEB75230_P_NODE_8749_length_493_cov_1.385714_g8567_i0 | PRJEB75230 | 8749 | 493 | 1.385714 | 6.83157002 | Opisthokonta | 33154 | Fungi | Fungi | 460 | 6.749999999999998e-125 | NTclustered | gi|2432171462|ref|XM_053112561.1| | 110093 | g8567 | i0 | 84.388 | 94.3326572008114 | 474 | 68 | 96 | 6 | 23 | 493 | 1522 | 1052 | Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA | blastn | 46506 | 464 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19262814 | 19262814 | PRJEB75230_P_NODE_4556_length_643_cov_3.121053_g4378_i0 | PRJEB75230 | 4556 | 643 | 3.121053 | 20.06837079 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 235 | 5.909999999999999e-57 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g4378 | i0 | 82.079 | 47.4914463452566 | 279 | 46 | 43 | 4 | 367 | 643 | 1800 | 1524 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 30537 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22672891 | 22672891 | PRJEB75230_P_NODE_2378_length_864_cov_3.345133_g2230_i0 | PRJEB75230 | 2378 | 864 | 3.345133 | 28.90194912 | Fungi | 4751 | Fungi | Fungi | 440 | 1.59e-118 | NTclustered | gi|2432132579|ref|XM_053106383.1| | 110093 | g2230 | i0 | 79.589 | 61.5069444444444 | 632 | 115 | 72 | 14 | 209 | 833 | 1761 | 1137 | Polychytrium aggregatum heat shock protein 70 family (BJ171DRAFT_212372), mRNA | blastn | 53142 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23087631 | 23087631 | PRJEB75230_P_NODE_108219_length_257_cov_1.673913_g108037_i0 | PRJEB75230 | 108219 | 257 | 1.673913 | 4.30195641 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 3.67e-45 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g108037 | i0 | 80.876 | 26.8287937743191 | 251 | 44 | 97 | 3 | 1 | 249 | 309 | 61 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 6895 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23088712 | 23088712 | PRJEB75230_P_NODE_184659_length_240_cov_3.407186_g184477_i0 | PRJEB75230 | 184659 | 240 | 3.407186 | 8.1772464 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 147 | 9.63e-31 | NTclustered | gi|2432143306|ref|XM_053110608.1| | 110093 | g184477 | i0 | 87.903 | 16.0666666666667 | 124 | 15 | 52 | 0 | 117 | 240 | 168 | 291 | Polychytrium aggregatum putative 40S ribosomal protein RPS14 (BJ171DRAFT_500769), mRNA | blastn | 3856 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;