contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11986299 | 11986299 | PRJNA534016_P_NODE_5890_length_344_cov_1.638376_g5800_i0 | PRJNA534016 | 5890 | 344 | 1.638376 | 5.63601344 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|66826106|ref|XM_641316.1| | 352472 | g5800 | i0 | 100 | 0.0813953488372093 | 28 | 0 | 8 | 0 | 78 | 105 | 1976 | 1949 | Dictyostelium discoideum AX4 7-fold repeat in clathrin and VPS proteins repeat-containing protein (vps18) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13261259 | 13261259 | PRJNA534016_P_NODE_13031_length_255_cov_1.692308_g12941_i0 | PRJNA534016 | 13031 | 255 | 1.692308 | 4.3153854 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66802076|ref|XM_629830.1| | 352472 | g12941 | i0 | 100 | 0.117647058823529 | 30 | 0 | 12 | 0 | 84 | 113 | 512 | 541 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0292106) mRNA, complete cds | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14536266 | 14536266 | PRJNA534016_P_NODE_13292_length_253_cov_1.711111_g13202_i0 | PRJNA534016 | 13292 | 253 | 1.711111 | 4.32911083 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 281 | 2.69e-71 | NTclustered | gi|167394534|ref|XM_001740954.1| | 370354 | g13202 | i0 | 87.654 | 97.9604743083004 | 243 | 28 | 96 | 2 | 5 | 246 | 235 | 476 | Entamoeba dispar SAW760 actin, putative (EDI_043510), partial mRNA | blastn | 24784 | 281 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar |
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);;