contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 603275 | 603275 | PRJNA631119_P_NODE_4701_length_519_cov_1.751121_g4583_i0 | PRJNA631119 | 4701 | 519 | 1.751121 | 9.08831799 | Linderina pennispora | 61395 | Fungi | Fungi | 300 | 1.64e-76 | NTclustered | gi|2028327270|ref|XM_040888737.1| | 61395 | g4583 | i0 | 85.333 | 57.3872832369942 | 300 | 33 | 57 | 9 | 213 | 508 | 356 | 648 | Linderina pennispora 40S ribosomal protein S2 (DL89DRAFT_270502), mRNA | blastn | 29784 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 1879351 | 1879351 | PRJNA631119_P_NODE_19002_length_302_cov_2.807860_g18884_i0 | PRJNA631119 | 19002 | 302 | 2.80786 | 8.4797372 | Linderina pennispora | 61395 | Fungi | Fungi | 132 | 3.5100000000000004e-26 | NTclustered | gi|2028316108|ref|XM_040886815.1| | 61395 | g18884 | i0 | 83.448 | 6.48344370860927 | 145 | 20 | 47 | 4 | 149 | 291 | 461 | 319 | Linderina pennispora ribosomal 60S subunit protein L29 (DL89DRAFT_265768), partial mRNA | blastn | 1958 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 8256497 | 8256497 | PRJNA631119_P_NODE_9207_length_395_cov_2.726708_g9089_i0 | PRJNA631119 | 9207 | 395 | 2.726708 | 10.7704966 | Linderina pennispora | 61395 | Fungi | Fungi | 327 | 5.61e-85 | NTclustered | gi|2028315762|ref|XM_040886762.1| | 61395 | g9089 | i0 | 85.714 | 81.1113924050633 | 315 | 39 | 80 | 2 | 81 | 395 | 958 | 650 | Linderina pennispora ubiquitin-domain-containing protein (DL89DRAFT_265656), partial mRNA | blastn | 32039 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 9531694 | 9531694 | PRJNA631119_P_NODE_20048_length_296_cov_3.233184_g19930_i0 | PRJNA631119 | 20048 | 296 | 3.233184 | 9.57022464 | Linderina pennispora | 61395 | Fungi | Fungi | 113 | 1.24e-20 | NTclustered | gi|2028322326|ref|XM_040891104.1| | 61395 | g19930 | i0 | 89.888 | 33.2905405405405 | 89 | 7 | 30 | 2 | 193 | 280 | 640 | 553 | Linderina pennispora cytoplasmic inorganic pyrophosphatase (DL89DRAFT_318402), partial mRNA | blastn | 9854 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 10080302 | 10080302 | PRJNA631119_P_NODE_23208_length_281_cov_1.625000_g23090_i0 | PRJNA631119 | 23208 | 281 | 1.625 | 4.56625 | Fungi | 4751 | Fungi | Fungi | 167 | 8.869999999999999e-37 | NTclustered | gi|358030849|dbj|AB609158.1| | 34480 | g23090 | i0 | 84.848 | 24.2918149466192 | 165 | 25 | 59 | 0 | 1 | 165 | 308 | 144 | Basidiobolus ranarum EF2 gene for translation elongation factor 2, partial cds, strain: NRRL 34594 | blastn | 6826 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 13357354 | 13357354 | PRJNA631119_P_NODE_12911_length_348_cov_1.770909_g12793_i0 | PRJNA631119 | 12911 | 348 | 1.770909 | 6.16276332 | Kickxella alabastrina | 61397 | Fungi | Fungi | 191 | 6.69e-44 | NTclustered | gi|2324005298|ref|XM_051534802.1| | 61397 | g12793 | i0 | 81.659 | 57.4166666666667 | 229 | 42 | 66 | 0 | 118 | 346 | 156 | 384 | Kickxella alabastrina ribosomal protein S17-domain-containing protein (BX661DRAFT_178059), mRNA | blastn | 19981 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 24103880 | 24103880 | PRJNA631119_P_NODE_9439_length_391_cov_2.462264_g9321_i0 | PRJNA631119 | 9439 | 391 | 2.462264 | 9.62745224 | Fungi | 4751 | Fungi | Fungi | 313 | 1.55e-80 | NTclustered | gi|2028323356|ref|XM_040888071.1| | 61395 | g9321 | i0 | 81.313 | 86.0562659846547 | 396 | 64 | 100 | 7 | 1 | 391 | 2021 | 2411 | Linderina pennispora P-loop containing nucleoside triphosphate hydrolase protein (DL89DRAFT_268891), mRNA | blastn | 33648 | 315 | 0.993650793650794 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 24829496 | 24829496 | PRJNA631119_P_NODE_29220_length_256_cov_2.098361_g29102_i0 | PRJNA631119 | 29220 | 256 | 2.098361 | 5.37180416 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 167 | 7.969999999999999e-37 | NTclustered | gi|358030847|dbj|AB609157.1| | 61424 | g29102 | i0 | 80.543 | 2.5078125 | 221 | 39 | 86 | 4 | 37 | 255 | 970 | 1188 | Furculomyces boomerangus EF2 gene for translation elongation factor 2, partial cds, strain: BL059 | blastn | 642 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus |
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);;