contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1829957 | 1829957 | PRJNA565584_P_NODE_112622_length_286_cov_2.070423_g111470_i0 | PRJNA565584 | 112622 | 286 | 2.070423 | 5.92140978 | Linderina pennispora | 61395 | Fungi | Fungi | 174 | 5.41e-39 | NTclustered | gi|2028325320|ref|XM_040884791.1| | 61395 | g111470 | i0 | 80.909 | 5.09440559440559 | 220 | 42 | 77 | 0 | 1 | 220 | 421 | 202 | Linderina pennispora uncharacterized protein (DL89DRAFT_226065), partial mRNA | blastn | 1457 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 8208349 | 8208349 | PRJNA565584_P_NODE_159407_length_256_cov_1.540984_g158255_i0 | PRJNA565584 | 159407 | 256 | 1.540984 | 3.94491904 | Linderina pennispora | 61395 | Fungi | Fungi | 195 | 3.65e-45 | NTclustered | gi|2028316002|ref|XM_040886800.1| | 61395 | g158255 | i0 | 85.052 | 40.9453125 | 194 | 25 | 75 | 4 | 40 | 231 | 139 | 330 | Linderina pennispora ribosomal protein S3 (DL89DRAFT_265740), partial mRNA | blastn | 10482 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 9485558 | 9485558 | PRJNA565584_P_NODE_56268_length_396_cov_1.934985_g55117_i0 | PRJNA565584 | 56268 | 396 | 1.934985 | 7.6625406 | Kickxella alabastrina | 61397 | Fungi | Fungi | 255 | 2.69e-63 | NTclustered | gi|2324018834|ref|XM_051536871.1| | 61397 | g55117 | i0 | 82.06 | 72.7449494949495 | 301 | 52 | 76 | 2 | 10 | 309 | 168 | 467 | Kickxella alabastrina 40S ribosomal protein S23 (BX661DRAFT_185785), mRNA | blastn | 28807 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 10761364 | 10761364 | PRJNA565584_P_NODE_46069_length_439_cov_4.087432_g44918_i0 | PRJNA565584 | 46069 | 439 | 4.087432 | 17.94382648 | Kickxella alabastrina | 61397 | Fungi | Fungi | 178 | 6.71e-40 | NTclustered | gi|2324008288|ref|XM_051539526.1| | 61397 | g44918 | i0 | 79.767 | 1.86332574031891 | 257 | 42 | 57 | 10 | 107 | 358 | 415 | 164 | Kickxella alabastrina ribosomal protein S10 domain-containing protein (BX661DRAFT_85603), mRNA | blastn | 818 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 12034509 | 12034509 | PRJNA565584_P_NODE_156390_length_258_cov_1.583784_g155238_i0 | PRJNA565584 | 156390 | 258 | 1.583784 | 4.08616272 | Linderina pennispora | 61395 | Fungi | Fungi | 80.5 | 1.08e-10 | NTclustered | gi|2028323122|ref|XM_040885139.1| | 61395 | g155238 | i0 | 94.231 | 25.9651162790698 | 52 | 3 | 20 | 0 | 3 | 54 | 627 | 678 | Linderina pennispora ubiquitin (DL89DRAFT_247944), partial mRNA | blastn | 6699 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 13308992 | 13308992 | PRJNA565584_P_NODE_136691_length_271_cov_1.484848_g135539_i0 | PRJNA565584 | 136691 | 271 | 1.484848 | 4.02393808 | Linderina pennispora | 61395 | Fungi | Fungi | 143 | 1.43e-29 | NTclustered | gi|2028320666|ref|XM_040889247.1| | 61395 | g135539 | i0 | 80.749 | 5.4760147601476 | 187 | 32 | 68 | 4 | 87 | 271 | 483 | 299 | Linderina pennispora 60S ribosomal protein L11 (DL89DRAFT_274988), partial mRNA | blastn | 1484 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 15858286 | 15858286 | PRJNA565584_P_NODE_171273_length_250_cov_1.672316_g170121_i0 | PRJNA565584 | 171273 | 250 | 1.672316 | 4.18079 | Kickxella alabastrina | 61397 | Fungi | Fungi | 78.7 | 3.74e-10 | NTclustered | gi|2324008288|ref|XM_051539526.1| | 61397 | g170121 | i0 | 88.889 | 3.996 | 63 | 7 | 25 | 0 | 35 | 97 | 223 | 161 | Kickxella alabastrina ribosomal protein S10 domain-containing protein (BX661DRAFT_85603), mRNA | blastn | 999 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 17134186 | 17134186 | PRJNA565584_P_NODE_24354_length_632_cov_1.887299_g23221_i0 | PRJNA565584 | 24354 | 632 | 1.887299 | 11.92772968 | Linderina pennispora | 61395 | Fungi | Fungi | 296 | 2.63e-75 | NTclustered | gi|2028325320|ref|XM_040884791.1| | 61395 | g23221 | i0 | 78.004 | 34.6993670886076 | 491 | 94 | 77 | 11 | 22 | 505 | 16 | 499 | Linderina pennispora uncharacterized protein (DL89DRAFT_226065), partial mRNA | blastn | 21930 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 22812901 | 22812901 | PRJNA565584_P_NODE_99598_length_299_cov_1.703540_g98446_i0 | PRJNA565584 | 99598 | 299 | 1.70354 | 5.0935846 | Fungi | 4751 | Fungi | Fungi | 357 | 5.26e-94 | NTclustered | gi|2028323432|ref|XM_040888084.1| | 61395 | g98446 | i0 | 88.699 | 97.5819397993311 | 292 | 33 | 98 | 0 | 8 | 299 | 992 | 701 | Linderina pennispora 40S ribosomal protein S5 (DL89DRAFT_268926), mRNA | blastn | 29177 | 359 | 0.994428969359331 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 25360396 | 25360396 | PRJNA565584_P_NODE_137940_length_270_cov_1.563452_g136788_i0 | PRJNA565584 | 137940 | 270 | 1.563452 | 4.2213204 | Fungi | 4751 | Fungi | Fungi | 303 | 6.19e-78 | NTclustered | gi|2028325604|ref|XM_040889545.1| | 61395 | g136788 | i0 | 87.085 | 98.7962962962963 | 271 | 31 | 99 | 4 | 2 | 270 | 472 | 204 | Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA | blastn | 26675 | 305 | 0.99344262295082 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora |
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);;