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

9 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_species
5068428	5068428	PRJNA879314_P_NODE_9724_length_244_cov_0.912281_g9674_i0	PRJNA879314	9724	244	0.912281	2.22596564	Myxococcota	2818505	Bacteria	Bacteria	92	8.18e-20	NR	OGR10127.1	1797899	g9674	i0	64.6	2.37295081967213	65	23	79.9	0	49	243	3	67	OGR10127.1 MAG: hypothetical protein A2341_05960 [Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9]	diamond	579	92	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9
26778594	26778594	PRJNA879314_P_NODE_10001_length_244_cov_0.912281_g9951_i0	PRJNA879314	10001	244	0.912281	2.22596564	Bacteria	2	Bacteria	Bacteria	116	1.77e-30	NR	OQB08369.1	1852869	g9951	i0	60.5	3.97131147540984	81	32	99.6	0	1	243	16	96	OQB08369.1 MAG: 2-deoxyglucose-6-phosphate phosphatase [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	969	117	0.991452991452991	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium ADurb.Bin207
27023643	27023643	PRJNA879314_P_NODE_7702_length_248_cov_0.891429_g7652_i0	PRJNA879314	7702	248	0.891429	2.21074392	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	77.8	1.13e-15	NR	OGQ89047.1	1797895	g7652	i0	51.2	2.9758064516129	82	38	96.8	2	2	241	9	90	OGQ89047.1 MAG: hypothetical protein A2289_18715 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	738	77.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
27758607	27758607	PRJNA879314_P_NODE_7404_length_248_cov_0.891429_g7354_i0	PRJNA879314	7404	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	162	2.06e-44	NR	OQB16389.1	1852869	g7354	i0	100	2.9758064516129	82	0	99.2	0	248	3	191	272	OQB16389.1 MAG: ATP-dependent RNA helicase HrpB [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	738	162	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium ADurb.Bin207
29992185	29992185	PRJNA879314_P_NODE_4711_length_253_cov_0.866667_g4661_i0	PRJNA879314	4711	253	0.866667	2.19266751	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	82.4	1.21e-17	NR	PKN32349.1	2013748	g4661	i0	72.5	0.604743083003953	51	14	60.5	0	1	153	106	156	PKN32349.1 MAG: hypothetical protein CVU63_19240 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	153	82.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
30781991	30781991	PRJNA879314_P_NODE_9594_length_245_cov_0.906977_g9544_i0	PRJNA879314	9594	245	0.906977	2.22209365	Deltaproteobacteria bacterium RIFOXYD12_FULL_5	2026735	Bacteria	Bacteria	120	1.2599999999999998e-29	NR	OGR08093.1	1797902	g9544	i0	64.2	0.991836734693878	81	28	99.2	1	243	1	345	424	OGR08093.1 MAG: DNA methylase [Deltaproteobacteria bacterium RIFOXYD12_FULL_50_9]	diamond	243	120	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYD12_FULL_50_9
31572469	31572469	PRJNA879314_P_NODE_7496_length_248_cov_0.891429_g7446_i0	PRJNA879314	7496	248	0.891429	2.21074392	Deltaproteobacteria bacterium ADurb.Bin	2026735	Bacteria	Bacteria	157	1.66e-44	NR	OQC73552.1	1852862	g7446	i0	92.7	0.991935483870968	82	6	99.2	0	246	1	7	88	OQC73552.1 MAG: Transposase IS116/IS110/IS902 family protein [Deltaproteobacteria bacterium ADurb.Bin002]	diamond	246	157	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium ADurb.Bin002
31833166	31833166	PRJNA879314_P_NODE_9477_length_245_cov_0.906977_g9427_i0	PRJNA879314	9477	245	0.906977	2.22209365	Myxococcota	2818505	Bacteria	Bacteria	103	1.5899999999999995e-23	NR	OGQ09157.1	1797848	g9427	i0	61.7	4.95918367346939	81	31	99.2	0	2	244	221	301	OGQ09157.1 MAG: hypothetical protein A2138_13550 [Deltaproteobacteria bacterium RBG_16_71_12]	diamond	1215	103	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RBG_16_71_12
31896522	31896522	PRJNA879314_P_NODE_4997_length_252_cov_0.871508_g4947_i0	PRJNA879314	4997	252	0.871508	2.19620016	Bacteria	2	Bacteria	Bacteria	120	1.16e-32	NR	OGQ90984.1	1797895	g4947	i0	70.4	2.89285714285714	81	24	96.4	0	2	244	59	139	OGQ90984.1 MAG: hypothetical protein A2289_00725 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	729	120	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15

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