metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax_phylum = "Synergistota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
857933	857933	PRJNA879314_P_NODE_8301_length_247_cov_0.896552_g8251_i0	PRJNA879314	8301	247	0.896552	2.21448344	Synergistales	649776	Bacteria	Bacteria	139	1.0299999999999998e-37	NR	WP_133957802.1	1005740	g8251	i0	84.1	9.95951417004049	82	13	99.6	0	246	1	229	310	WP_133957802.1 peptide chain release factor 1 [Aminivibrio pyruvatiphilus]	diamond	2460	140	0.992857142857143	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio pyruvatiphilus
27276681	27276681	PRJNA879314_P_NODE_7123_length_249_cov_0.886364_g7073_i0	PRJNA879314	7123	249	0.886364	2.20704636	Synergistaceae bacterium	2053624	Bacteria	Bacteria	115	3.65e-28	NR	NLB82893.1	2053624	g7073	i0	65.9	3.95180722891566	82	28	98.8	0	247	2	108	189	NLB82893.1 30S ribosomal protein S12 methylthiotransferase RimO [Synergistaceae bacterium]	diamond	984	115	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27687516	27687516	PRJNA879314_P_NODE_8364_length_247_cov_0.896552_g8314_i0	PRJNA879314	8364	247	0.896552	2.21448344	Synergistaceae bacterium	2053624	Bacteria	Bacteria	153	5.76e-44	NR	NLX84373.1	2053624	g8314	i0	96.3	2.98785425101215	82	3	99.6	0	2	247	103	184	NLX84373.1 branched-chain amino acid ABC transporter permease [Synergistaceae bacterium]	diamond	738	153	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28389701	28389701	PRJNA879314_P_NODE_5646_length_251_cov_0.876404_g5596_i0	PRJNA879314	5646	251	0.876404	2.19977404	Aminiphilus	290731	Bacteria	Bacteria	103	8.48e-24	NR	WP_029165579.1	290732	g5596	i0	91.1	1.33864541832669	56	5	66.9	0	168	1	1	56	WP_029165579.1 IS21 family transposase [Aminiphilus circumscriptus]	diamond	336	103	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminiphilaceae	Aminiphilus	Aminiphilus circumscriptus
28918331	28918331	PRJNA879314_P_NODE_8908_length_246_cov_0.901734_g8858_i0	PRJNA879314	8908	246	0.901734	2.21826564	Synergistaceae bacterium	2053624	Bacteria	Bacteria	164	4.87e-45	NR	HAH68764.1	2053624	g8858	i0	96.3	5	82	3	100	0	1	246	400	481	HAH68764.1 alpha-glucan family phosphorylase [Synergistaceae bacterium]	diamond	1230	164	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29171248	29171248	PRJNA879314_P_NODE_8009_length_247_cov_0.896552_g7959_i0	PRJNA879314	8009	247	0.896552	2.21448344	Pyramidobacter sp.	1943581	Bacteria	Bacteria	145	1.6e-39	NR	MBQ4489946.1	1943581	g7959	i0	98.8	2.95141700404858	81	1	98.4	0	246	4	55	135	MBQ4489946.1 TRAP transporter large permease subunit [Pyramidobacter sp.]	diamond	729	145	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter sp.
29612798	29612798	PRJNA879314_P_NODE_4810_length_253_cov_0.866667_g4760_i0	PRJNA879314	4810	253	0.866667	2.19266751	Synergistaceae bacterium	2053624	Bacteria	Bacteria	79.3	7.08e-17	NR	MBO6266644.1	2053624	g4760	i0	95	0.474308300395257	40	2	47.4	0	122	3	1	40	MBO6266644.1 IS66 family insertion sequence element accessory protein TnpB [Synergistaceae bacterium]	diamond	120	79.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29644303	29644303	PRJNA879314_P_NODE_10990_length_242_cov_0.923077_g10940_i0	PRJNA879314	10990	242	0.923077	2.23384634	Synergistaceae bacterium	2053624	Bacteria	Bacteria	118	3.4399999999999995e-31	NR	NLD95884.1	2053624	g10940	i0	84.4	1.58677685950413	64	10	79.3	0	5	196	142	205	NLD95884.1 DUF4276 family protein [Synergistaceae bacterium]	diamond	384	118	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29992190	29992190	PRJNA879314_P_NODE_6251_length_250_cov_0.881356_g6201_i0	PRJNA879314	6251	250	0.881356	2.20339	Synergistaceae bacterium	2053624	Bacteria	Bacteria	163	1.99e-44	NR	HAH69178.1	2053624	g6201	i0	98.8	0.996	83	1	99.6	0	249	1	749	831	HAH69178.1 hypothetical protein [Synergistaceae bacterium]	diamond	249	163	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30181595	30181595	PRJNA879314_P_NODE_4892_length_252_cov_0.871508_g4842_i0	PRJNA879314	4892	252	0.871508	2.19620016	Synergistales bacterium	2268201	Bacteria	Bacteria	111	3.3e-28	NR	MFA0888831.1	2268201	g4842	i0	70.3	1.72619047619048	74	22	88.1	0	2	223	151	224	MFA0888831.1 cyclase family protein [Synergistales bacterium]	diamond	435	111	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
30592324	30592324	PRJNA879314_P_NODE_10693_length_243_cov_0.917647_g10643_i0	PRJNA879314	10693	243	0.917647	2.22988221	Synergistales bacterium	2268201	Bacteria	Bacteria	58.2	2.08e-8	NR	MFA0888859.1	2268201	g10643	i0	100	0.296296296296296	24	0	29.6	0	72	1	95	118	MFA0888859.1 CD1247 N-terminal domain-containing protein [Synergistales bacterium]	diamond	72	58.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
31129176	31129176	PRJNA879314_P_NODE_10395_length_243_cov_0.917647_g10345_i0	PRJNA879314	10395	243	0.917647	2.22988221	Synergistaceae bacterium	2053624	Bacteria	Bacteria	146	4.859999999999998e-42	NR	MCK9438265.1	2053624	g10345	i0	86.3	0.987654320987654	80	11	98.8	0	242	3	150	229	MCK9438265.1 hypothetical protein [Synergistaceae bacterium]	diamond	240	146	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31833165	31833165	PRJNA879314_P_NODE_7657_length_248_cov_0.891429_g7607_i0	PRJNA879314	7657	248	0.891429	2.21074392	Synergistales	649776	Bacteria	Bacteria	65.9	1.32e-10	NR	WP_299075198.1	1678694	g7607	i0	60.4	2.6008064516129	53	21	64.1	0	166	8	7	59	WP_299075198.1 flavin reductase family protein [uncultured Fretibacterium sp.]	diamond	645	65.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
32497974	32497974	PRJNA879314_P_NODE_3479_length_274_cov_2.069652_g3429_i0	PRJNA879314	3479	274	2.069652	5.67084648	Bacteria	2	Bacteria	Bacteria	140	1.7899999999999998e-37	NR	NLI96981.1	2053624	g3429	i0	65.5	2.47445255474453	113	16	98.5	1	3	272	275	387	NLI96981.1 sigma-54-dependent Fis family transcriptional regulator [Synergistaceae bacterium]	diamond	678	140	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32616112	32616112	PRJNA879314_P_NODE_9000_length_246_cov_0.901734_g8950_i0	PRJNA879314	9000	246	0.901734	2.21826564	Synergistales bacterium	2268201	Bacteria	Bacteria	60.1	2.71e-8	NR	MBN1333888.1	2268201	g8950	i0	38.8	0.975609756097561	80	49	97.6	0	242	3	268	347	MBN1333888.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Synergistales bacterium]	diamond	240	60.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium

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