contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4226846 | 4226846 | PRJNA376117_P_NODE_15124_length_352_cov_2.204301_g14822_i0 | PRJNA376117 | 15124 | 352 | 2.204301 | 7.75913952 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 202 | 3.119999999999999e-47 | NTclustered | gi|2432155304|ref|XM_053111518.1| | 110093 | g14822 | i0 | 79.783 | 11.4573863636364 | 277 | 56 | 79 | 0 | 72 | 348 | 326 | 50 | Polychytrium aggregatum ribosomal L27e protein family-domain-containing protein (BJ171DRAFT_510919), mRNA | blastn | 4033 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 5503275 | 5503275 | PRJNA376117_P_NODE_16325_length_340_cov_5.378277_g16023_i0 | PRJNA376117 | 16325 | 340 | 5.378277 | 18.2861418 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 148 | 3.98e-31 | NTclustered | gi|2432050258|ref|XM_053069071.1| | 1396493 | g16023 | i0 | 83.03 | 34.0411764705882 | 165 | 26 | 48 | 2 | 101 | 264 | 325 | 162 | Fimicolochytrium jonesii component of cytosolic 80S ribosome and 40S small subunit (EV422DRAFT_512505), mRNA | blastn | 11574 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 6777284 | 6777284 | PRJNA376117_P_NODE_10006_length_425_cov_1.812500_g9704_i0 | PRJNA376117 | 10006 | 425 | 1.8125 | 7.703125 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 315 | 4.73e-81 | NTclustered | gi|2432158512|ref|XM_053111712.1| | 110093 | g9704 | i0 | 81.17 | 70.7294117647059 | 393 | 72 | 92 | 2 | 23 | 414 | 150 | 541 | Polychytrium aggregatum 40S ribosomal protein S13 (BJ171DRAFT_513016), mRNA | blastn | 30060 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9327980 | 9327980 | PRJNA376117_P_NODE_28548_length_270_cov_1.563452_g28246_i0 | PRJNA376117 | 28548 | 270 | 1.563452 | 4.2213204 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 220 | 6.41e-53 | NTclustered | gi|1026947816|ref|XM_016748429.1| | 645134 | g28246 | i0 | 81.618 | 47.8962962962963 | 272 | 44 | 99 | 6 | 1 | 269 | 1123 | 855 | Spizellomyces punctatus DAOM BR117 ATP-dependent RNA helicase eIF4A (SPPG_00092), mRNA | blastn | 12932 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 10001758 | 10001758 | PRJNA376117_P_NODE_19328_length_314_cov_1.917012_g19026_i0 | PRJNA376117 | 19328 | 314 | 1.917012 | 6.01941768 | Fungi | 4751 | Fungi | Fungi | 357 | 5.56e-94 | NTclustered | gi|53829559|gb|AY582832.1| | 64517 | g19026 | i0 | 87.22 | 100.363057324841 | 313 | 40 | 99 | 0 | 1 | 313 | 1158 | 846 | Rhizophlyctis rosea strain CBS 57684 HSP70 gene, partial cds | blastn | 31514 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 10603639 | 10603639 | PRJNA376117_P_NODE_30129_length_264_cov_1.612565_g29827_i0 | PRJNA376117 | 30129 | 264 | 1.612565 | 4.2571716 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 187 | 6.34e-43 | NTclustered | gi|2432174060|ref|XM_053106822.1| | 110093 | g29827 | i0 | 81.197 | 84.6212121212121 | 234 | 42 | 88 | 2 | 7 | 239 | 638 | 870 | Polychytrium aggregatum nucleotide-diphospho-sugar transferase (BJ171DRAFT_272837), mRNA | blastn | 22340 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11276884 | 11276884 | PRJNA376117_P_NODE_23829_length_286_cov_2.169014_g23527_i0 | PRJNA376117 | 23829 | 286 | 2.169014 | 6.20338004 | Fungi | 4751 | Fungi | Fungi | 274 | 5.18e-69 | NTclustered | gi|358030871|dbj|AB609169.1| | 281842 | g23527 | i0 | 84.083 | 98.2377622377622 | 289 | 40 | 100 | 6 | 1 | 286 | 1729 | 1444 | Entophlyctis helioformis EF2 gene for translation elongation factor 2, partial cds, isolate: AFTOL-ID 40 | blastn | 28096 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 13153617 | 13153617 | PRJNA376117_P_NODE_26251_length_278_cov_1.848780_g25949_i0 | PRJNA376117 | 26251 | 278 | 1.84878 | 5.1396084 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 115 | 3.2200000000000003e-21 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g25949 | i0 | 80.795 | 1.39208633093525 | 151 | 25 | 54 | 2 | 46 | 194 | 1088 | 940 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 387 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17651199 | 17651199 | PRJNA376117_P_NODE_15674_length_347_cov_1.124088_g15372_i0 | PRJNA376117 | 15674 | 347 | 1.124088 | 3.90058536 | Fungi | 4751 | Fungi | Fungi | 279 | 1.38e-70 | NTclustered | gi|2432162155|ref|XM_053113596.1| | 110093 | g15372 | i0 | 86.538 | 72.0951008645533 | 260 | 28 | 73 | 2 | 95 | 347 | 1521 | 1262 | Polychytrium aggregatum translation elongation factor EF-1 alpha (BJ171DRAFT_569936), mRNA | blastn | 25017 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19525498 | 19525498 | PRJNA376117_P_NODE_12356_length_385_cov_2.689103_g12054_i0 | PRJNA376117 | 12356 | 385 | 2.689103 | 10.35304655 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 176 | 2.09e-39 | NTclustered | gi|2432155304|ref|XM_053111518.1| | 110093 | g12054 | i0 | 79.283 | 8.76363636363636 | 251 | 52 | 65 | 0 | 30 | 280 | 49 | 299 | Polychytrium aggregatum ribosomal L27e protein family-domain-containing protein (BJ171DRAFT_510919), mRNA | blastn | 3374 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20801140 | 20801140 | PRJNA376117_P_NODE_12597_length_382_cov_1.744337_g12295_i0 | PRJNA376117 | 12597 | 382 | 1.744337 | 6.66336734 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 278 | 5.52e-70 | NTclustered | gi|2432144496|ref|XM_053115856.1| | 110093 | g12295 | i0 | 80.912 | 19.8848167539267 | 351 | 67 | 92 | 0 | 1 | 351 | 461 | 111 | Polychytrium aggregatum small GTPase superfamily (BJ171DRAFT_72758), mRNA | blastn | 7596 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20801226 | 20801226 | PRJNA376117_P_NODE_20217_length_307_cov_2.123932_g19915_i0 | PRJNA376117 | 20217 | 307 | 2.123932 | 6.52047124 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 115 | 3.6e-21 | NTclustered | gi|2432150000|ref|XM_053114178.1| | 110093 | g19915 | i0 | 82.014 | 1.37785016286645 | 139 | 22 | 44 | 1 | 3 | 138 | 502 | 640 | Polychytrium aggregatum ribosomal protein S2, flavodoxin-like domain-containing protein (BJ171DRAFT_582387), partial mRNA | blastn | 423 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22750385 | 22750385 | PRJNA376117_P_NODE_10638_length_412_cov_3.619469_g10336_i0 | PRJNA376117 | 10638 | 412 | 3.619469 | 14.91221228 | Opisthokonta | 33154 | Fungi | Fungi | 148 | 4.91e-31 | NTclustered | gi|82398309|gb|DQ273787.1| | 64517 | g10336 | i0 | 98.795 | 33.2378640776699 | 83 | 1 | 38 | 0 | 10 | 92 | 2236 | 2154 | Rhizophlyctis rosea isolate AFTOL-ID 43 28S ribosomal RNA gene, partial sequence | blastn | 13694 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 23352124 | 23352124 | PRJNA376117_P_NODE_5779_length_562_cov_3.141104_g5480_i0 | PRJNA376117 | 5779 | 562 | 3.141104 | 17.65300448 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 368 | 4.84e-97 | NTclustered | gi|2432134333|ref|XM_053109764.1| | 110093 | g5480 | i0 | 78.761 | 95.1281138790036 | 565 | 108 | 99 | 11 | 4 | 562 | 639 | 81 | Polychytrium aggregatum 60S ribosomal protein I1-a (BJ171DRAFT_491703), mRNA | blastn | 53462 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23352145 | 23352145 | PRJNA376117_P_NODE_8559_length_459_cov_1.730570_g8257_i0 | PRJNA376117 | 8559 | 459 | 1.73057 | 7.9433163 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 235 | 4.12e-57 | NTclustered | gi|2432051426|ref|XM_053072055.1| | 1396493 | g8257 | i0 | 78.32 | 16.3006535947712 | 369 | 76 | 80 | 4 | 55 | 421 | 735 | 369 | Fimicolochytrium jonesii ribosomal family S4e-domain-containing protein (EV422DRAFT_563332), partial mRNA | blastn | 7482 | 235 | 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);;