metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1101048" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1101048" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
15513862	15513862	PRJNA1101048_P_NODE_9713_length_223_cov_4.933333_g9657_i0	PRJNA1101048	9713	223	4.933333	11.00133259	Peptococcaceae bacterium CEB3	999898	Bacteria	Bacteria	70.1	2.99e-13	NR	KLU63339.1	999898	g9657	i0	56.7	3.51121076233184	67	29	90.1	0	201	1	21	87	KLU63339.1 hypothetical protein CEB3_c02620 [Peptococcaceae bacterium CEB3]	diamond	783	70.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae		Peptococcaceae bacterium CEB3
26814602	26814602	PRJNA1101048_P_NODE_9101_length_243_cov_0.917647_g9045_i0	PRJNA1101048	9101	243	0.917647	2.22988221	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0352	NR	WP_399964477.1	3365722	g9045	i0	38.7	0.765432098765432	62	38	76.5	0	11	196	202	263	WP_399964477.1 polyprenyl synthetase family protein [Streptomyces sp. NPDC079020]	diamond	186	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC079020
27510150	27510150	PRJNA1101048_P_NODE_7323_length_251_cov_1.747191_g7267_i0	PRJNA1101048	7323	251	1.747191	4.38544941	Bifidobacteriaceae bacterium	2291324	Bacteria	Bacteria	66.6	4.92e-12	NR	MDO5764056.1	2291324	g7267	i0	90.6	0.382470119521912	32	3	38.2	0	249	154	40	71	MDO5764056.1 hypothetical protein [Bifidobacteriaceae bacterium]	diamond	96	66.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium
28109794	28109794	PRJNA1101048_P_NODE_3685_length_322_cov_1.393574_g3629_i0	PRJNA1101048	3685	322	1.393574	4.48730828	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	43.5	0.0473	NR	HEY4896767.1	2586742	g3629	i0	35.8	0.754658385093168	81	49	75.5	1	282	40	107	184	HEY4896767.1 M48 family metalloprotease [Solirubrobacteraceae bacterium]	diamond	243	43.5	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28520491	28520491	PRJNA1101048_P_NODE_5347_length_281_cov_0.783654_g5291_i0	PRJNA1101048	5347	281	0.783654	2.20206774	Clostridia bacterium	2044939	Bacteria	Bacteria	43.5	0.0288	NR	MBR5922358.1	2044939	g5291	i0	34.7	0.800711743772242	75	45	75.8	1	260	48	36	110	MBR5922358.1 hypothetical protein [Clostridia bacterium]	diamond	225	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28710015	28710015	PRJNA1101048_P_NODE_8607_length_245_cov_1.406977_g8551_i0	PRJNA1101048	8607	245	1.406977	3.44709365	Demequina capsici	3075620	Bacteria	Bacteria	43.5	0.0153	NR	WP_313541647.1	3075620	g8551	i0	31.2	1.88571428571429	77	52	93.1	1	14	241	56	132	WP_313541647.1 biotin transporter BioY [Demequina capsici]	diamond	462	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Demequinaceae	Demequina	Demequina capsici
28772886	28772886	PRJNA1101048_P_NODE_6927_length_253_cov_1.722222_g6871_i0	PRJNA1101048	6927	253	1.722222	4.35722166	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	43.1	0.0197	NR	MEI2785879.1	2518612	g6871	i0	52.5	0.474308300395257	40	15	47.4	1	25	144	136	171	MEI2785879.1 DUF222 domain-containing protein [Candidatus Nanopelagicales bacterium]	diamond	120	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
29688328	29688328	PRJNA1101048_P_NODE_7690_length_250_cov_0.881356_g7634_i0	PRJNA1101048	7690	250	0.881356	2.20339	Streptomyces macrosporus	44032	Bacteria	Bacteria	43.9	0.0159	NR	WP_344320102.1	44032	g7634	i0	43.8	1.164	48	23	55.2	3	73	210	216	261	WP_344320102.1 hypothetical protein [Streptomyces macrosporus]	diamond	291	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces macrosporus
30825892	30825892	PRJNA1101048_P_NODE_8734_length_245_cov_0.906977_g8678_i0	PRJNA1101048	8734	245	0.906977	2.22209365	Blastococcus colisei	1564162	Bacteria	Bacteria	41.2	0.0322	NR	WP_142023984.1	1564162	g8678	i0	41.3	0.771428571428571	63	31	73.5	4	32	211	7	66	WP_142023984.1 DUF2516 family protein [Blastococcus colisei]	diamond	189	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus colisei
31015500	31015500	PRJNA1101048_P_NODE_6995_length_253_cov_0.866667_g6939_i0	PRJNA1101048	6995	253	0.866667	2.19266751	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	44.3	0.0113	NR	MFN8130756.1	2586742	g6939	i0	35.4	1.73122529644269	48	30	56.9	1	156	13	61	107	MFN8130756.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	438	44.3	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
31711184	31711184	PRJNA1101048_P_NODE_7877_length_249_cov_0.886364_g7821_i0	PRJNA1101048	7877	249	0.886364	2.20704636	Saccharopolyspora rosea	524884	Bacteria	Bacteria	43.1	0.0271	NR	WP_263250359.1	524884	g7821	i0	35.1	0.686746987951807	57	32	62.7	2	39	194	202	258	WP_263250359.1 DUF4328 domain-containing protein [Saccharopolyspora rosea]	diamond	171	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora rosea
32344176	32344176	PRJNA1101048_P_NODE_5679_length_274_cov_1.527363_g5623_i0	PRJNA1101048	5679	274	1.527363	4.18497462	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	45.8	0.00432	NR	MBQ9839032.1	2485925	g5623	i0	42.6	0.591240875912409	54	30	59.1	1	48	209	344	396	MBQ9839032.1 DUF2079 domain-containing protein [Oscillospiraceae bacterium]	diamond	162	45.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32407280	32407280	PRJNA1101048_P_NODE_8459_length_246_cov_0.901734_g8403_i0	PRJNA1101048	8459	246	0.901734	2.21826564	Actinomycetes bacterium	1883427	Bacteria	Bacteria	42.7	0.0375	NR	MCL2339710.1	1883427	g8403	i0	36.9	0.792682926829268	65	30	65.9	3	38	199	361	425	MCL2339710.1 PH domain-containing protein [Actinomycetes bacterium]	diamond	195	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
32533961	32533961	PRJNA1101048_P_NODE_4079_length_310_cov_1.050633_g4023_i0	PRJNA1101048	4079	310	1.050633	3.2569623	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	43.1	0.0467	NR	MDR3310048.1	2485925	g4023	i0	41.7	0.464516129032258	48	25	43.5	1	144	10	127	174	MDR3310048.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Oscillospiraceae bacterium]	diamond	144	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium

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