contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA438111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15736703 | 15736703 | PRJNA438111_P_NODE_3533_length_521_cov_6.589431_g3023_i0 | PRJNA438111 | 3533 | 521 | 6.589431 | 34.33093551 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 279 | 2.15e-70 | NTclustered | gi|66818077|ref|XM_637640.1| | 352472 | g3023 | i0 | 81.285 | 18.2053742802303 | 358 | 55 | 68 | 10 | 28 | 379 | 600 | 249 | Dictyostelium discoideum AX4 NADH-ubiquinone oxidoreductase 23 kDa subunit (ndufs8) mRNA, complete cds | blastn | 9485 | 279 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22110419 | 22110419 | PRJNA438111_P_NODE_13798_length_280_cov_6.250996_g13173_i0 | PRJNA438111 | 13798 | 280 | 6.250996 | 17.5027888 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 228 | 3.9899999999999986e-55 | NTclustered | gi|511085018|dbj|AK419745.1| | 5759 | g13173 | i0 | 81.429 | 2 | 280 | 50 | 99 | 2 | 1 | 279 | 450 | 728 | Entamoeba histolytica cDNA clone: Xeh-005L18, 26S protease regulatory subunit, putative, complete cds, strain: HM-1:IMSS | blastn | 560 | 228 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 24661028 | 24661028 | PRJNA438111_P_NODE_85660_length_153_cov_5.717742_g85035_i0 | PRJNA438111 | 85660 | 153 | 5.717742 | 8.74814526 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 95.3 | 2.05e-15 | NTclustered | gi|330840413|ref|XM_003292163.1| | 5786 | g85035 | i0 | 88.462 | 0.509803921568627 | 78 | 9 | 51 | 0 | 53 | 130 | 701 | 624 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_57790), partial mRNA | blastn | 78 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;