metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Xenacoelomorpha"

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_kingdom	tax_phylum	tax_order	tax_family	tax_genus	tax_species
26812236	26812236	PRJEB64798_P_NODE_164301_length_181_cov_5.545455_g162535_i0	PRJEB64798	164301	181	5.545455	10.03727355	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	64.7	2.83e-10	NR	XP_063728272.1	84072	g162535	i0	50.8	2.86740331491713	59	29	97.8	0	179	3	812	870	XP_063728272.1 WD repeat-containing protein 35-like [Symsagittifera roscoffensis]	diamond	519	64.7	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
27539434	27539434	PRJEB64798_P_NODE_236504_length_156_cov_6.065421_g234738_i0	PRJEB64798	236504	156	6.065421	9.46205676	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	69.7	2.07e-12	NR	XP_063712035.1	84072	g234738	i0	61.2	0.942307692307692	49	19	94.2	0	150	4	10	58	XP_063712035.1 mitochondrial carnitine/acylcarnitine carrier protein-like [Symsagittifera roscoffensis]	diamond	147	69.7	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
27974445	27974445	PRJEB64798_P_NODE_201225_length_167_cov_2.033898_g199459_i0	PRJEB64798	201225	167	2.033898	3.39660966	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	6e-23	NR	XP_063719940.1	84072	g199459	i0	88.9	3.88023952095808	54	6	97	0	163	2	21	74	XP_063719940.1 polyadenylate-binding protein 4-like [Symsagittifera roscoffensis]	diamond	648	100	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
29079602	29079602	PRJEB64798_P_NODE_105408_length_211_cov_12.561728_g103642_i0	PRJEB64798	105408	211	12.561728	26.50524608	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	67	7.33e-12	NR	XP_063722177.1	84072	g103642	i0	87.5	17.6445497630332	32	4	45.5	0	101	6	21	52	XP_063722177.1 eukaryotic translation initiation factor 5A-1-like [Symsagittifera roscoffensis]	diamond	3723	67	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
29995421	29995421	PRJEB64798_P_NODE_237351_length_156_cov_3.439252_g235585_i0	PRJEB64798	237351	156	3.439252	5.36523312	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	60.5	6.49e-9	NR	XP_063724192.1	84072	g235585	i0	57.1	3.71153846153846	49	21	94.2	0	147	1	286	334	XP_063724192.1 ubiquitin-like modifier-activating enzyme 1 [Symsagittifera roscoffensis]	diamond	579	60.5	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
31259154	31259154	PRJEB64798_P_NODE_197695_length_168_cov_1.663866_g195929_i0	PRJEB64798	197695	168	1.663866	2.79529488	Metazoa	33208	Xenacoelomorpha	other_Eukaryota	102	1.2699999999999999e-23	NR	XP_063718296.1	84072	g195929	i0	88.9	17.9285714285714	54	6	96.4	0	163	2	440	493	XP_063718296.1 transitional endoplasmic reticulum ATPase [Symsagittifera roscoffensis]	diamond	3012	102	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
31645508	31645508	PRJEB64798_P_NODE_246097_length_153_cov_3.788462_g244331_i0	PRJEB64798	246097	153	3.788462	5.79634686	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	48.1	1.34e-4	NR	XP_063712938.1	84072	g244331	i0	62.9	1.50980392156863	35	12	68.6	1	119	15	334	367	XP_063712938.1 MYND-type zinc finger-containing chromatin reader ZMYND8-like [Symsagittifera roscoffensis]	diamond	231	48.1	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis
32151797	32151797	PRJEB64798_P_NODE_17678_length_474_cov_10.040000_g15967_i0	PRJEB64798	17678	474	10.04	47.5896	Symsagittifera roscoffensis	84072	Xenacoelomorpha	other_Eukaryota	102	1.32e-22	NR	XP_063718357.1	84072	g15967	i0	42.3	2.68354430379747	130	65	76.6	5	105	467	117	245	XP_063718357.1 four and a half LIM domains protein 2-like [Symsagittifera roscoffensis]	diamond	1272	102	1	Eukaryota	Opisthokonta	Metazoa	Xenacoelomorpha	Acoela	Sagittiferidae	Symsagittifera	Symsagittifera roscoffensis

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