metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax_phylum = "Evosea"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
867849	867849	PRJNA893346_P_NODE_12301_length_446_cov_2.664879_g11816_i0	PRJNA893346	12301	446	2.664879	11.88536034	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	217	1.45e-51	NTclustered	gi\|66818310\|ref\|XM_637723.1\|	352472	g11816	i0	83.55	61.5269058295964	231	38	52	0	13	243	1	231	Dictyostelium discoideum AX4 ubiquitin/ribosomal protein S27a fusion protein (ubqC) mRNA, complete cds	blastn	27441	217	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
7246091	7246091	PRJNA893346_P_NODE_1806_length_1207_cov_2.091711_g1538_i0	PRJNA893346	1806	1207	2.091711	25.24695177	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	933	0	NTclustered	gi\|66821574\|ref\|XM_639154.1\|	352472	g1538	i0	81.875	93.0124275062138	1120	191	92	11	33	1146	1131	18	Dictyostelium discoideum AX4 hypothetical protein (act2) mRNA, complete cds	blastn	112266	933	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
13621864	13621864	PRJNA893346_P_NODE_25071_length_304_cov_1.000000_g24581_i0	PRJNA893346	25071	304	1	3.04	Entamoeba histolytica	5759	Evosea	other_Eukaryota	250	9.36e-62	NTclustered	gi\|183234457\|ref\|XM_645739.2\|	294381	g24581	i0	85.417	71.1940789473684	240	35	79	0	6	245	2	241	Entamoeba histolytica HM-1:IMSS Rho family GTPase (EHI_197840), mRNA	blastn	21643	250	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
14896475	14896475	PRJNA893346_P_NODE_39392_length_241_cov_3.642857_g38902_i0	PRJNA893346	39392	241	3.642857	8.77928537	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	156	1.6100000000000002e-33	NTclustered	gi\|831768583\|ref\|XM_012896994.1\|	1410327	g38902	i0	83.929	38.7136929460581	168	21	68	5	61	225	69	233	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	9330	156	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
17446441	17446441	PRJNA893346_P_NODE_28214_length_283_cov_1.100000_g27724_i0	PRJNA893346	28214	283	1.1	3.113	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	154	6.96e-33	NTclustered	gi\|66817211\|ref\|XM_637392.1\|	352472	g27724	i0	88.889	11.4452296819788	126	13	44	1	1	125	309	184	Dictyostelium discoideum AX4 60S ribosomal protein L4 (rpl4) mRNA, complete cds	blastn	3239	154	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17820811	17820811	PRJNA893346_P_NODE_34214_length_250_cov_0.870056_g33724_i0	PRJNA893346	34214	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.1	3.76e-5	NTclustered	gi\|330844455\|ref\|XM_003294093.1\|	5786	g33724	i0	100	4.852	33	0	13	0	86	118	160	192	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_42973), partial mRNA	blastn	1213	62.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
18719915	18719915	PRJNA893346_P_NODE_36915_length_245_cov_1.430233_g36425_i0	PRJNA893346	36915	245	1.430233	3.50407085	Entamoeba dispar	46681	Evosea	other_Eukaryota	185	2.09e-42	NTclustered	gi\|167389651\|ref\|XM_001738981.1\|	370354	g36425	i0	80.738	73.8285714285714	244	41	98	6	3	243	610	370	Entamoeba dispar SAW760 heat shock 70 kDa protein, putative (EDI_175820), partial mRNA	blastn	18088	185	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
19994700	19994700	PRJNA893346_P_NODE_20716_length_339_cov_0.954887_g20227_i0	PRJNA893346	20716	339	0.954887	3.23706693	Heterostelium album	2086695	Evosea	other_Eukaryota	392	1.66e-104	NTclustered	gi\|1160555578\|ref\|XM_020573614.1\|	670386	g20227	i0	88.58	94.2212389380531	324	35	95	2	5	327	772	1094	Polysphondylium pallidum PN500 actin partial mRNA	blastn	31941	392	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
25093842	25093842	PRJNA893346_P_NODE_12780_length_437_cov_1.480769_g12294_i0	PRJNA893346	12780	437	1.480769	6.47096053	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	58.4	0.001	NTclustered	gi\|66821416\|ref\|XM_639098.1\|	352472	g12294	i0	92.683	0.189931350114416	41	2	9	1	392	431	819	859	Dictyostelium discoideum AX4 PA14 domain-containing protein (psiL) mRNA, complete cds	blastn	83	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum

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);;