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

10 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_clade = "Amoebozoa"

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
26653096	26653096	PRJEB2925_P_NODE_11081_length_335_cov_2.066667_g9807_i0	PRJEB2925	11081	335	2.066667	6.92333445	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	106	5.6999999999999986e-24	NR	XP_004356787.1	1257118	g9807	i0	56.2	0.940298507462687	105	45	93.1	1	321	10	603	707	XP_004356787.1 IQGAPrelated protein [Acanthamoeba castellanii str. Neff]	diamond	315	106	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
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
28517676	28517676	PRJEB2925_P_NODE_6587_length_505_cov_3.008511_g5448_i0	PRJEB2925	6587	505	3.008511	15.19298055	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	170	2.22e-50	NR	XP_004356664.1	1257118	g5448	i0	54.4	0.95049504950495	160	67	91.5	3	42	503	3	162	XP_004356664.1 rho guanine dissociation factor isoform 2, putative [Acanthamoeba castellanii str. Neff]	diamond	480	170	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28953391	28953391	PRJEB2925_P_NODE_14708_length_265_cov_1.673913_g13430_i0	PRJEB2925	14708	265	1.673913	4.43586945	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.8	8.24e-4	NR	BAN33737.1	931554	g13430	i0	78.6	1.26792452830189	28	6	31.7	0	1	84	348	375	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	336	47.8	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
29149472	29149472	PRJEB2925_P_NODE_14109_length_273_cov_3.327731_g12831_i0	PRJEB2925	14109	273	3.327731	9.08470563	Acanthamoeba polyphaga	5757	Discosea	other_Eukaryota	102	1.28e-25	NR	1CNU_A	5757	g12831	i0	54.7	5.47252747252747	86	38	94.5	1	2	259	47	131	1CNU_A Chain A, ACTOPHORIN [Acanthamoeba polyphaga]	diamond	1494	102	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba polyphaga
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
31423664	31423664	PRJEB2925_P_NODE_15616_length_253_cov_1.545872_g14338_i0	PRJEB2925	15616	253	1.545872	3.91105616	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	68.2	4.58e-11	NR	XP_004341324.1	1257118	g14338	i0	45.2	0.865612648221344	73	33	85.4	2	224	9	64	130	XP_004341324.1 calponin (CH) domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	219	68.2	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
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);;