contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3198720 | 3198720 | PRJNA675331_P_NODE_8943_length_329_cov_2.093750_g8771_i0 | PRJNA675331 | 8943 | 329 | 2.09375 | 6.8884375 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 411 | 4.429999999999999e-110 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g8771 | i0 | 89.091 | 100.392097264438 | 330 | 34 | 100 | 2 | 1 | 329 | 690 | 1018 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 33029 | 411 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 7026340 | 7026340 | PRJNA675331_P_NODE_13126_length_282_cov_1.105263_g12954_i0 | PRJNA675331 | 13126 | 282 | 1.105263 | 3.11684166 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 274 | 5.1e-69 | NTclustered | gi|2048770422|gb|MW534135.1| | 437603 | g12954 | i0 | 84.982 | 2.41489361702128 | 273 | 37 | 96 | 4 | 7 | 277 | 332 | 602 | Paramoeba perurans isolate PPER_00019895 multifunctional chaperone mRNA, complete cds | blastn | 681 | 274 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 8301035 | 8301035 | PRJNA675331_P_NODE_10987_length_303_cov_1.608696_g10815_i0 | PRJNA675331 | 10987 | 303 | 1.608696 | 4.87434888 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 307 | 5.46e-79 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g10815 | i0 | 85.05 | 92.4455445544555 | 301 | 45 | 99 | 0 | 3 | 303 | 693 | 393 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 28011 | 307 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 18500077 | 18500077 | PRJNA675331_P_NODE_8015_length_345_cov_1.830882_g7843_i0 | PRJNA675331 | 8015 | 345 | 1.830882 | 6.3165429 | Vexillifera multispinosa | 1105342 | Discosea | other_Eukaryota | 316 | 1.05e-81 | NTclustered | gi|354720322|gb|HQ687481.1| | 1105342 | g7843 | i0 | 85.231 | 53.9130434782609 | 325 | 28 | 93 | 14 | 1 | 321 | 1788 | 1480 | Vexillifera multispinosa strain P124 small subunit ribosomal RNA gene, partial sequence | blastn | 18600 | 316 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera multispinosa | ||
| 23600561 | 23600561 | PRJNA675331_P_NODE_17739_length_252_cov_2.083799_g17567_i0 | PRJNA675331 | 17739 | 252 | 2.083799 | 5.25117348 | Vexillifera expectata | 1789827 | Discosea | other_Eukaryota | 405 | 1.52e-108 | NTclustered | gi|1042160925|dbj|LC102269.1| | 1789827 | g17567 | i0 | 95.635 | 99.3809523809524 | 252 | 11 | 100 | 0 | 1 | 252 | 350 | 99 | Vexillifera expectata gene for actin, partial cds, strain: 4730_cl4 | blastn | 25044 | 405 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera expectata |
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);;