metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA613025" 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
28185473	28185473	PRJNA613025_S_NODE_31586_length_165_cov_0.862069_g31432_i0	PRJNA613025	31586	165	0.862069	1.42241385	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	67	3.41e-11	NR	XP_020431823.1	670386	g31432	i0	50.9	1.92727272727273	53	26	96.4	0	3	161	88	140	XP_020431823.1 glutathione S-transferase domain-containing protein [Heterostelium album PN500]	diamond	318	67	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
28943792	28943792	PRJNA613025_S_NODE_16108_length_262_cov_1.375587_g15954_i0	PRJNA613025	16108	262	1.375587	3.60403794	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	92.8	9.07e-20	NR	XP_647081.2	352472	g15954	i0	51.9	2.81679389312977	81	39	92.7	0	245	3	73	153	XP_647081.2 p21-activated protein kinase [Dictyostelium discoideum AX4]	diamond	738	92.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
29587671	29587671	PRJNA613025_S_NODE_8230_length_465_cov_3.689904_g8078_i0	PRJNA613025	8230	465	3.689904	17.1580536	Eumycetozoa	142796	Evosea	other_Eukaryota	141	8.77e-40	NR	KYR02504.1	361077	g8078	i0	50.7	2.6	134	66	86.5	0	463	62	7	140	KYR02504.1 actin binding protein [Tieghemostelium lacteum]	diamond	1209	141	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29606154	29606154	PRJNA613025_S_NODE_27050_length_179_cov_1.000000_g26896_i0	PRJNA613025	27050	179	1	1.79	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	47	1.86e-4	NR	XP_012758105.1	1410327	g26896	i0	35.7	0.93854748603352	56	36	93.9	0	172	5	22	77	XP_012758105.1 hypothetical protein SAMD00019534_020600, partial [Acytostelium subglobosum LB1]	diamond	168	47	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
31072844	31072844	PRJNA613025_S_NODE_19775_length_222_cov_1.161850_g19621_i0	PRJNA613025	19775	222	1.16185	2.579307	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67	7.79e-11	NR	XP_004182963.1	370355	g19621	i0	44.6	2.01351351351351	74	38	97.3	2	218	3	772	844	XP_004182963.1 Gelation factor, putative [Entamoeba invadens IP1]	diamond	447	67.4	0.99406528189911	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
31280924	31280924	PRJNA613025_S_NODE_25375_length_186_cov_2.379562_g25221_i0	PRJNA613025	25375	186	2.379562	4.42598532	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	54.7	9.99e-7	NR	KAF2073311.1	133409	g25221	i0	49.2	1.96774193548387	61	31	98.4	0	3	185	198	258	KAF2073311.1 hypothetical protein CYY_005364 [Polysphondylium violaceum]	diamond	366	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
31660348	31660348	PRJNA613025_S_NODE_18777_length_231_cov_1.390110_g18623_i0	PRJNA613025	18777	231	1.39011	3.2111541	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	90.1	6.4e-20	NR	XP_020433716.1	670386	g18623	i0	54.8	0.948051948051948	73	30	94.8	1	3	221	56	125	XP_020433716.1 component of the counting factor complex [Heterostelium album PN500]	diamond	219	90.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
31818600	31818600	PRJNA613025_S_NODE_19117_length_228_cov_0.849162_g18963_i0	PRJNA613025	19117	228	0.849162	1.93608936	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	92	1.11e-21	NR	XP_012752219.1	1410327	g18963	i0	56.9	0.947368421052632	72	31	94.7	0	5	220	48	119	XP_012752219.1 hypothetical protein SAMD00019534_077250 [Acytostelium subglobosum LB1]	diamond	216	92	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32261959	32261959	PRJNA613025_S_NODE_29678_length_168_cov_1.705882_g29524_i0	PRJNA613025	29678	168	1.705882	2.86588176	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	62.8	1.19e-9	NR	KYR00721.1	361077	g29524	i0	55.8	0.928571428571429	52	23	92.9	0	1	156	1189	1240	KYR00721.1 alpha actinin [Tieghemostelium lacteum]	diamond	156	62.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32325272	32325272	PRJNA613025_S_NODE_32779_length_163_cov_0.885965_g32625_i0	PRJNA613025	32779	163	0.885965	1.44412295	Entamoeba invadens IP1	370355	Evosea	other_Eukaryota	46.6	5.63e-4	NR	XP_004254922.1	370355	g32625	i0	48.8	0.754601226993865	41	20	75.5	1	133	11	1193	1232	XP_004254922.1 serine-threonine protein kinase, putative [Entamoeba invadens IP1]	diamond	123	46.6	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens

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