metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA385073" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA385073" 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
6783796	6783796	PRJNA385073_P_NODE_41506_length_251_cov_0.865169_g41344_i0	PRJNA385073	41506	251	0.865169	2.17157419	Synergistales	649776	Bacteria	Bacteria	165	1.87e-47	NR	WP_367337325.1	1872489	g41344	i0	92.8	1.9840637450199201	83	6	99.2	0	249	1	90	172	WP_367337325.1 M20 metallopeptidase family protein [Aminivibrio sp.]	diamond	498	165	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.
27991310	27991310	PRJNA385073_P_NODE_58265_length_241_cov_0.916667_g58103_i0	PRJNA385073	58265	241	0.916667	2.20916747	Synergistaceae bacterium	2053624	Bacteria	Bacteria	161	3.6599999999999997e-47	NR	MCK9437852.1	2053624	g58103	i0	91.1	1.96680497925311	79	7	98.3	0	3	239	73	151	MCK9437852.1 hypothetical protein [Synergistaceae bacterium]	diamond	474	161	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28243584	28243584	PRJNA385073_P_NODE_50846_length_246_cov_0.861272_g50684_i0	PRJNA385073	50846	246	0.861272	2.11872912	Cloacibacillus evryensis	508460	Bacteria	Bacteria	152	1.5499999999999996e-40	NR	WP_323398719.1	508460	g50684	i0	91.5	1.98780487804878	82	7	100	0	246	1	928	1009	WP_323398719.1 AAA family ATPase [Cloacibacillus evryensis]	diamond	489	152	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus evryensis
28591184	28591184	PRJNA385073_P_NODE_48127_length_247_cov_0.885057_g47965_i0	PRJNA385073	48127	247	0.885057	2.18609079	Synergistaceae bacterium	2053624	Bacteria	Bacteria	82.4	4.17e-16	NR	MFA5457936.1	2053624	g47965	i0	97.8	0.558704453441296	46	1	55.9	0	109	246	339	384	MFA5457936.1 hypothetical protein [Synergistaceae bacterium]	diamond	138	82.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29460142	29460142	PRJNA385073_P_NODE_48830_length_247_cov_0.885057_g48668_i0	PRJNA385073	48830	247	0.885057	2.18609079	Synergistales	649776	Bacteria	Bacteria	105	1.39e-24	NR	WP_198470004.1	2529858	g48668	i0	61	1.9919028340081	82	31	99.6	1	2	247	146	226	WP_198470004.1 dihydroorotase [Acetomicrobium sp. S15 = DSM 107314]	diamond	492	105	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium sp. S15 = DSM 107314
29980438	29980438	PRJNA385073_P_NODE_42131_length_251_cov_0.865169_g41969_i0	PRJNA385073	42131	251	0.865169	2.17157419	Synergistaceae bacterium	2053624	Bacteria	Bacteria	167	2.7399999999999997e-47	NR	MDY0283456.1	2053624	g41969	i0	100	1.9601593625498	83	0	99.2	0	251	3	65	147	MDY0283456.1 AAA family ATPase [Synergistaceae bacterium]	diamond	492	167	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32667290	32667290	PRJNA385073_P_NODE_51380_length_245_cov_0.895349_g51218_i0	PRJNA385073	51380	245	0.895349	2.19360505	Aminobacterium mobile	81467	Bacteria	Bacteria	147	1.07e-40	NR	WP_024822954.1	81467	g51218	i0	100	0.991836734693878	81	0	99.2	0	244	2	253	333	WP_024822954.1 PASTA domain-containing protein [Aminobacterium mobile]	diamond	243	147	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminobacterium	Aminobacterium mobile
32698762	32698762	PRJNA385073_P_NODE_40540_length_252_cov_2.581006_g40378_i0	PRJNA385073	40540	252	2.581006	6.50413512	Synergistaceae bacterium	2053624	Bacteria	Bacteria	160	3.24e-49	NR	MDD3690074.1	2053624	g40378	i0	98.8	0.988095238095238	83	1	98.8	0	2	250	4	86	MDD3690074.1 hypothetical protein [Synergistaceae bacterium]	diamond	249	160	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32730443	32730443	PRJNA385073_P_NODE_43800_length_250_cov_0.870056_g43638_i0	PRJNA385073	43800	250	0.870056	2.17514	Aminivibrio sp.	1872489	Bacteria	Bacteria	170	3.07e-49	NR	WP_367337626.1	1872489	g43638	i0	100	0.996	83	0	99.6	0	2	250	220	302	WP_367337626.1 glycine/sarcosine/betaine reductase component B subunit [Aminivibrio sp.]	diamond	249	170	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.

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