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

9 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Vogeliibacteriota"

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_phylum	tax_species
3955120	3955120	PRJEB64798_P_NODE_46924_length_286_cov_14.185654_g45159_i0	PRJEB64798	46924	286	14.185654	40.57097044	Bacteria	2	Bacteria	Bacteria	55.5	2.87e-7	NR	HCQ92207.1	2053638	g45159	i0	58.7	1.36363636363636	46	19	48.3	0	33	170	59	104	HCQ92207.1 hypothetical protein [Candidatus Vogelbacteria bacterium]	diamond	390	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium
26938738	26938738	PRJEB64798_P_NODE_244522_length_153_cov_12.038462_g242756_i0	PRJEB64798	244522	153	12.038462000000001	18.41884686	Candidatus Vogelbacteria bacterium	2053638	Bacteria	Bacteria	40	0.0302	NR	MBI2100297.1	2053638	g242756	i0	64.5	0.607843137254902	31	11	60.8	0	1	93	37	67	MBI2100297.1 hypothetical protein [Candidatus Vogelbacteria bacterium]	diamond	93	40	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium
26938778	26938778	PRJEB64798_P_NODE_59082_length_253_cov_11.352941_g57317_i0	PRJEB64798	59082	253	11.352941	28.72294073	Candidatus Vogelbacteria bacterium CG1	2053638	Bacteria	Bacteria	79	3.88e-17	NR	PIR46661.1	1975042	g57317	i0	68.5	0.640316205533597	54	17	64	0	221	60	26	79	PIR46661.1 MAG: hypothetical protein COV07_03270 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14]	diamond	162	79	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14
28013158	28013158	PRJEB64798_P_NODE_234565_length_157_cov_3.351852_g232799_i0	PRJEB64798	234565	157	3.351852	5.26240764	Candidatus Vogelbacteria bacterium CG1	2053638	Bacteria	Bacteria	46.6	6.58e-5	NR	PIR46661.1	1975042	g232799	i0	55.8	0.821656050955414	43	19	82.2	0	150	22	31	73	PIR46661.1 MAG: hypothetical protein COV07_03270 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14]	diamond	129	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14
28518349	28518349	PRJEB64798_P_NODE_93527_length_212_cov_4.871166_g91761_i0	PRJEB64798	93527	212	4.871166	10.32687192	Candidatus Vogelbacteria bacterium	2053638	Bacteria	Bacteria	57	2.32e-7	NR	MCE9628793.1	2053638	g91761	i0	81.3	0.452830188679245	32	6	45.3	0	5	100	373	404	MCE9628793.1 hypothetical protein [Candidatus Vogelbacteria bacterium]	diamond	96	57	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium
29402126	29402126	PRJEB64798_P_NODE_143069_length_192_cov_1.783217_g141303_i0	PRJEB64798	143069	192	1.783217	3.42377664	Candidatus Vogelbacteria bacterium	2053638	Bacteria	Bacteria	91.3	1.31e-20	NR	MCE9628735.1	2053638	g141303	i0	74.2	0.96875	62	16	96.9	0	192	7	37	98	MCE9628735.1 segregation/condensation protein A [Candidatus Vogelbacteria bacterium]	diamond	186	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium
30855086	30855086	PRJEB64798_P_NODE_101274_length_212_cov_2.858896_g99508_i0	PRJEB64798	101274	212	2.858896	6.06085952	Candidatus Vogelbacteria bacterium	2053638	Bacteria	Bacteria	88.2	2.42e-18	NR	MCE9628716.1	2053638	g99508	i0	52.9	1.44339622641509	102	15	97.6	1	2	208	237	338	MCE9628716.1 molecular chaperone DnaK [Candidatus Vogelbacteria bacterium]	diamond	306	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium
30918551	30918551	PRJEB64798_P_NODE_156254_length_185_cov_4.308824_g154488_i0	PRJEB64798	156254	185	4.308824	7.9713244	Candidatus Vogelbacteria bacterium CG22_combo_CG1	2053638	Bacteria	Bacteria	72	8.1e-13	NR	PIP58043.1	1975046	g154488	i0	65.5	0.940540540540541	58	20	94.1	0	7	180	472	529	PIP58043.1 MAG: hypothetical protein COX02_02440 [Candidatus Vogelbacteria bacterium CG22_combo_CG10-13_8_21_14_all_37_9]	diamond	174	72	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium CG22_combo_CG10-13_8_21_14_all_37_9
31424117	31424117	PRJEB64798_P_NODE_169416_length_179_cov_2.400000_g167650_i0	PRJEB64798	169416	179	2.4	4.296	Candidatus Vogelbacteria bacterium CG1	2053638	Bacteria	Bacteria	72	8.16e-15	NR	PIR46661.1	1975042	g167650	i0	73.5	0.82122905027933	49	13	82.1	0	1	147	31	79	PIR46661.1 MAG: hypothetical protein COV07_03270 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14]	diamond	147	72	1	Bacteria	Bacteria candidate phyla	Candidatus Vogeliibacteriota	Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14

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