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

8 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Bacillota"

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
27570069	27570069	PRJEB12237_P_NODE_8724_length_184_cov_1.610738_g8528_i0	PRJEB12237	8724	184	1.610738	2.96375792	Peptococcaceae bacterium	2052179	Bacteria	Bacteria	90.1	2.1e-21	NR	NLP44626.1	2052179	g8528	i0	68.9	0.994565217391304	61	19	99.5	0	183	1	59	119	NLP44626.1 RidA family protein [Peptococcaceae bacterium]	diamond	183	90.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae		Peptococcaceae bacterium
28195108	28195108	PRJEB12237_P_NODE_7066_length_213_cov_1.719101_g6870_i0	PRJEB12237	7066	213	1.719101	3.66168513	root	1	Root_unresolved	Root_unresolved	55.8	3.86e-7	NR	WP_016820924.1	44249	g6870	i0	57.4	6.69014084507042	54	22	76.1	1	52	213	1	53	WP_016820924.1 MULTISPECIES: SDR family oxidoreductase [Paenibacillus]	diamond	1425	56.2	0.99288256227758	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
29363660	29363660	PRJEB12237_P_NODE_3229_length_373_cov_3.520710_g3033_i0	PRJEB12237	3229	373	3.52071	13.1322483	root	1	Root_unresolved	Root_unresolved	78.2	2.32e-14	NR	WP_184245080.1	74386	g3033	i0	54.5	2.1313672922252	66	30	53.1	0	2	199	223	288	WP_184245080.1 ROK family protein [Gracilibacillus halotolerans]	diamond	795	78.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus halotolerans
29647304	29647304	PRJEB12237_P_NODE_8830_length_183_cov_1.351351_g8634_i0	PRJEB12237	8830	183	1.351351	2.47297233	Bacteria	2	Bacteria	Bacteria	45.1	0.00258	NR	MCQ2797956.1	1903720	g8634	i0	39.7	1.90163934426229	58	34	95.1	1	7	180	205	261	MCQ2797956.1 isocitrate/isopropylmalate dehydrogenase family protein [Bacilli bacterium]	diamond	348	45.1	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30412463	30412463	PRJEB12237_P_NODE_4653_length_290_cov_1.509804_g4457_i0	PRJEB12237	4653	290	1.509804	4.3784316	Halalkalibacter nanhaiisediminis	688079	Bacteria	Bacteria	115	1.46e-30	NR	WP_144449783.1	688079	g4457	i0	53.8	0.962068965517241	93	43	96.2	0	286	8	20	112	WP_144449783.1 OsmC family protein [Halalkalibacter nanhaiisediminis]	diamond	279	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halalkalibacter	Halalkalibacter nanhaiisediminis
30532142	30532142	PRJEB12237_P_NODE_8613_length_186_cov_1.324503_g8417_i0	PRJEB12237	8613	186	1.324503	2.46357558	Bacillales	1385	Bacteria	Bacteria	52.4	3.94e-6	NR	WP_100401789.1	2014077	g8417	i0	40.4	10.0322580645161	57	32	91.9	1	185	15	80	134	WP_100401789.1 PH domain-containing protein [Bacillus sp. FJAT-42315]	diamond	1866	52.8	0.992424242424242	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FJAT-42315
32309543	32309543	PRJEB12237_P_NODE_9619_length_173_cov_1.159420_g9423_i0	PRJEB12237	9619	173	1.15942	2.0057966	Candidatus Limivicinus sp.	3030905	Bacteria	Bacteria	59.7	7.02e-9	NR	MDY3860553.1	3030905	g9423	i0	70.3	1.63005780346821	37	11	64.2	0	18	128	2	38	MDY3860553.1 tetratricopeptide repeat protein [Candidatus Limivicinus sp.]	diamond	282	59.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Candidatus Limivicinus	Candidatus Limivicinus sp.
32436092	32436092	PRJEB12237_P_NODE_5499_length_255_cov_1.363636_g5303_i0	PRJEB12237	5499	255	1.363636	3.4772718	Listeria farberi	2713500	Bacteria	Bacteria	42.4	0.0433	NR	WP_185619881.1	2713500	g5303	i0	52.5	0.470588235294118	40	19	47.1	0	78	197	37	76	WP_185619881.1 SMI1/KNR4 family protein [Listeria farberi]	diamond	120	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria farberi

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