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

8 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax_kingdom = "Bacillati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18241070	18241070	PRJNA326068_P_NODE_4175_length_541_cov_2.687500_g3415_i0	PRJNA326068	4175	541	2.6875	14.539375	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	290	6.88e-98	NR	MBX9724270.1	2364082	g3415	i0	92.8	0.842883548983364	152	11	84.3	0	539	84	19	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	456	290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28242982	28242982	PRJNA326068_P_NODE_19326_length_160_cov_1.847328_g18363_i0	PRJNA326068	19326	160	1.847328	2.9557248	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	48.5	2.52e-5	NR	GIT46276.1	2201156	g18363	i0	55.3	0.88125	47	21	88.1	0	20	160	17	63	GIT46276.1 MAG: hypothetical protein Ct9H300mP12_08610 [Acidimicrobiales bacterium]	diamond	141	48.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
29158970	29158970	PRJNA326068_P_NODE_19109_length_163_cov_1.477612_g18146_i0	PRJNA326068	19109	163	1.477612	2.40850756	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.9	4.99e-4	NR	MBX9722867.1	2364082	g18146	i0	80.8	0.478527607361963	26	5	47.9	0	149	72	5	30	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	78	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29474262	29474262	PRJNA326068_P_NODE_18970_length_165_cov_2.022059_g18007_i0	PRJNA326068	18970	165	2.022059	3.33639735	Jonesia quinghaiensis	262806	Bacteria	Bacteria	41.2	0.0451	NR	WP_029067714.1	262806	g18007	i0	58.8	0.618181818181818	34	12	58.2	1	125	30	174	207	WP_029067714.1 MFS transporter [Jonesia quinghaiensis]	diamond	102	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Jonesiaceae	Jonesia	Jonesia quinghaiensis
29790116	29790116	PRJNA326068_P_NODE_14951_length_221_cov_1.729167_g13988_i0	PRJNA326068	14951	221	1.729167	3.82145907	Nocardiopsis terrae	372655	Bacteria	Bacteria	40.8	0.0137	NR	GHC98517.1	372655	g13988	i0	50	0.542986425339366	40	20	54.3	0	72	191	8	47	GHC98517.1 hypothetical protein GCM10007079_52930 [Nocardiopsis terrae]	diamond	120	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis terrae
29807493	29807493	PRJNA326068_P_NODE_18891_length_166_cov_2.489051_g17928_i0	PRJNA326068	18891	166	2.489051	4.13182466	Bacteria	2	Bacteria	Bacteria	40.4	0.0315	NR	SBS75384.1	171292	g17928	i0	52.6	1.98795180722892	38	18	68.7	0	114	1	11	48	SBS75384.1 hypothetical protein MHPYR_220060 [uncultured Mycobacterium sp.]	diamond	330	40.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	uncultured Mycobacterium sp.
30422536	30422536	PRJNA326068_P_NODE_19313_length_160_cov_2.152672_g18350_i0	PRJNA326068	19313	160	2.152672	3.4442752	Actinomycetota bacterium	2900548	Bacteria	Bacteria	49.7	4.17e-5	NR	MEY4173123.1	2900548	g18350	i0	75	0.75	40	9	75	1	40	159	173	211	MEY4173123.1 hypothetical protein [Actinomycetota bacterium]	diamond	120	49.7	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
31370427	31370427	PRJNA326068_P_NODE_19936_length_152_cov_2.162602_g18973_i0	PRJNA326068	19936	152	2.162602	3.28715504	uncultured actinobacterium HF4	152507	Bacteria	Bacteria	46.6	4.86e-5	NR	ADI18349.1	711002	g18973	i0	62.2	0.730263157894737	37	14	73	0	40	150	26	62	ADI18349.1 hypothetical protein [uncultured actinobacterium HF4000_04C13]	diamond	111	46.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				uncultured actinobacterium HF4000_04C13

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