contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944330 | 944330 | PRJNA971593_P_NODE_26781_length_244_cov_1.350877_g26632_i0 | PRJNA971593 | 26781 | 244 | 1.350877 | 3.29613988 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 176 | 1.25e-39 | NTclustered | gi|66826022|ref|XM_641274.1| | 352472 | g26632 | i0 | 82.673 | 6.67622950819672 | 202 | 31 | 82 | 3 | 7 | 206 | 1 | 200 | Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds | blastn | 1629 | 176 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 12745422 | 12745422 | PRJNA971593_P_NODE_11310_length_359_cov_1.615385_g11161_i0 | PRJNA971593 | 11310 | 359 | 1.615385 | 5.79923215 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 316 | 1.09e-81 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g11161 | i0 | 83.929 | 90.891364902507 | 336 | 49 | 93 | 5 | 17 | 350 | 71 | 403 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 32630 | 316 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16247263 | 16247263 | PRJNA971593_P_NODE_6453_length_479_cov_2.172414_g6305_i0 | PRJNA971593 | 6453 | 479 | 2.172414 | 10.40586306 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 374 | 8.76e-99 | NTclustered | gi|831792529|ref|XM_012904619.1| | 1410327 | g6305 | i0 | 81.898 | 68.4885177453027 | 453 | 73 | 94 | 7 | 1 | 450 | 565 | 1011 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 32806 | 374 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21346328 | 21346328 | PRJNA971593_P_NODE_21817_length_251_cov_2.073034_g21668_i0 | PRJNA971593 | 21817 | 251 | 2.073034 | 5.20331534 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 122 | 1.7099999999999998e-23 | NTclustered | gi|1160571044|ref|XM_020575016.1| | 670386 | g21668 | i0 | 81.046 | 1.12749003984064 | 153 | 29 | 61 | 0 | 3 | 155 | 283 | 435 | Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA | blastn | 283 | 122 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;