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

8 rows where analysis = "diamond", bioproject = "PRJNA951810" 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
26614041	26614041	PRJNA951810_P_NODE_89701_length_297_cov_7.075893_g89357_i0	PRJNA951810	89701	297	7.075893	21.01540221	Synergistaceae bacterium	2053624	Bacteria	Bacteria	90.5	1.24e-18	NR	MDR1510129.1	2053624	g89357	i0	49.5	1	99	50	100	0	297	1	668	766	MDR1510129.1 response regulator [Synergistaceae bacterium]	diamond	297	90.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27878582	27878582	PRJNA951810_P_NODE_184725_length_226_cov_4.947712_g184380_i0	PRJNA951810	184725	226	4.947712	11.18182912	Fretibacterium sp. OH122	2699746	Bacteria	Bacteria	149	3.86e-41	NR	WP_124889463.1	2491047	g184380	i0	100	0.995575221238938	75	0	99.6	0	226	2	261	335	WP_124889463.1 dihydrolipoyl dehydrogenase [Fretibacterium sp. OH1220_COT-178]	diamond	225	149	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium sp. OH1220_COT-178
28478432	28478432	PRJNA951810_P_NODE_115526_length_283_cov_2.757143_g115182_i0	PRJNA951810	115526	283	2.757143	7.80271469	Fretibacterium sp.	2699746	Bacteria	Bacteria	122	2.19e-31	NR	MBR1671876.1	2699746	g115182	i0	61.7	1.98233215547703	94	36	99.6	0	282	1	145	238	MBR1671876.1 polysaccharide deacetylase family protein [Fretibacterium sp.]	diamond	561	122	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium sp.
29614837	29614837	PRJNA951810_P_NODE_21190_length_435_cov_5.364641_g20852_i0	PRJNA951810	21190	435	5.364641	23.33618835	Synergistetes bacterium ADurb.BinA166	1852916	Bacteria	Bacteria	115	4.880000000000001e-27	NR	OPZ34500.1	1852916	g20852	i0	48.4	1.78620689655172	128	55	87.6	3	412	32	163	280	OPZ34500.1 MAG: hypothetical protein BWY99_02508 [Synergistetes bacterium ADurb.BinA166]	diamond	777	115	1	Bacteria	Thermotogati	Synergistota					Synergistetes bacterium ADurb.BinA166
29899557	29899557	PRJNA951810_P_NODE_72531_length_299_cov_12.088496_g72187_i0	PRJNA951810	72531	299	12.088496	36.14460304	Synergistota bacterium	2268202	Bacteria	Bacteria	63.5	1.75e-10	NR	MEA3507544.1	2268202	g72187	i0	52	0.501672240802676	50	24	50.2	0	152	3	55	104	MEA3507544.1 hypothetical protein [Synergistota bacterium]	diamond	150	63.5	1	Bacteria	Thermotogati	Synergistota					Synergistota bacterium
30815574	30815574	PRJNA951810_P_NODE_196834_length_199_cov_6.873016_g196489_i0	PRJNA951810	196834	199	6.873016	13.67730184	Synergistaceae bacterium	2053624	Bacteria	Bacteria	57.8	1.01e-7	NR	MDR0653637.1	2053624	g196489	i0	46	0.949748743718593	63	34	95	0	191	3	606	668	MDR0653637.1 AAA family ATPase [Synergistaceae bacterium]	diamond	189	57.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31037105	31037105	PRJNA951810_P_NODE_51555_length_310_cov_5.164557_g51212_i0	PRJNA951810	51555	310	5.164557	16.0101267	Synergistaceae bacterium	2053624	Bacteria	Bacteria	57	4.07e-8	NR	MFA7219043.1	2053624	g51212	i0	48.9	0.435483870967742	45	23	43.5	0	162	296	18	62	MFA7219043.1 hypothetical protein [Synergistaceae bacterium]	diamond	135	57	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32080332	32080332	PRJNA951810_P_NODE_156878_length_252_cov_4.910615_g156533_i0	PRJNA951810	156878	252	4.910615	12.3747498	Acetomicrobium flavidum	49896	Bacteria	Bacteria	75.1	1.63e-13	NR	WP_074200064.1	49896	g156533	i0	43.8	0.869047619047619	73	41	86.9	0	7	225	329	401	WP_074200064.1 O-antigen polymerase [Acetomicrobium flavidum]	diamond	219	75.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium flavidum

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