metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB2925" 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
28006146	28006146	PRJEB2925_P_NODE_9185_length_394_cov_2.509749_g7918_i0	PRJEB2925	9185	394	2.509749	9.88841106	Acytosteliales	2058181	Evosea	other_Eukaryota	99.8	1.2e-23	NR	XP_004360719.1	261658	g7918	i0	49.5	1.59137055837563	105	51	79.9	1	324	10	18	120	XP_004360719.1 essential myosin light chain [Cavenderia fasciculata]	diamond	627	99.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
29432934	29432934	PRJEB2925_P_NODE_3510_length_765_cov_5.249315_g2695_i0	PRJEB2925	3510	765	5.249315	40.15725975	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	226	2.54e-70	NR	AAD53482.1	44689	g2695	i0	50.2	2.39607843137255	209	102	81.6	2	101	724	16	223	AAD53482.1 countin [Dictyostelium discoideum]	diamond	1833	226	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
30184665	30184665	PRJEB2925_P_NODE_8872_length_405_cov_2.227027_g7612_i0	PRJEB2925	8872	405	2.227027	9.01945935	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	4.16e-31	NR	KAF2070448.1	133409	g7612	i0	59	46.5111111111111	105	43	77.8	0	3	317	240	344	KAF2070448.1 hypothetical protein CYY_008228 [Polysphondylium violaceum]	diamond	18837	125	0.992	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
32278058	32278058	PRJEB2925_P_NODE_6499_length_510_cov_5.730526_g5365_i0	PRJEB2925	6499	510	5.730526	29.2256826	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	155	5.24e-45	NR	KYR02504.1	361077	g5365	i0	51.7	2.55882352941176	145	70	85.3	0	21	455	1	145	KYR02504.1 actin binding protein [Tieghemostelium lacteum]	diamond	1305	155	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32594248	32594248	PRJEB2925_P_NODE_8360_length_426_cov_2.675192_g7123_i0	PRJEB2925	8360	426	2.675192	11.39631792	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	127	4.4599999999999996e-32	NR	KYQ91790.1	361077	g7123	i0	52.6	2.8943661971831	137	61	95.1	3	424	20	228	362	KYQ91790.1 severin [Tieghemostelium lacteum]	diamond	1233	127	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum

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