metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB28589" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB28589" 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
26678288	26678288	PRJEB28589_S_NODE_12261_length_217_cov_4.370588_g12153_i0	PRJEB28589	12261	217	4.370588	9.48417596	root	1	Root_unresolved	Root_unresolved	42	0.0489	NR	MCR4399154.1	1879010	g12153	i0	39.6	3.70506912442396	48	28	65	1	72	212	551	598	MCR4399154.1 glycoside hydrolase family 15 protein [Bacillota bacterium]	diamond	804	42	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
27127656	27127656	PRJEB28589_S_NODE_10222_length_245_cov_2.060606_g10114_i0	PRJEB28589	10222	245	2.060606	5.0484847	Weissella minor	1620	Bacteria	Bacteria	87.4	7.18e-18	NR	WP_057788955.1	1620	g10114	i0	89.4	0.575510204081633	47	5	57.6	0	244	104	712	758	WP_057788955.1 ATP-dependent Clp protease ATP-binding subunit [Weissella minor]	diamond	141	87.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella minor
27728622	27728622	PRJEB28589_S_NODE_6044_length_307_cov_4.761538_g5936_i0	PRJEB28589	6044	307	4.761538	14.61792166	Clostridia bacterium	2044939	Bacteria	Bacteria	170	3.63e-47	NR	MBR4287093.1	2044939	g5936	i0	88.4	0.928338762214984	95	11	92.8	0	21	305	584	678	MBR4287093.1 ferrous iron transport protein B [Clostridia bacterium]	diamond	285	170	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28423066	28423066	PRJEB28589_S_NODE_11826_length_223_cov_4.068182_g11718_i0	PRJEB28589	11826	223	4.068182	9.07204586	Tepidibacter thalassicus	214905	Bacteria	Bacteria	43.9	0.011	NR	WP_072723727.1	214905	g11718	i0	42.9	0.847533632286996	63	32	79.4	2	216	40	268	330	WP_072723727.1 elongator complex protein 3 [Tepidibacter thalassicus]	diamond	189	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Tepidibacter	Tepidibacter thalassicus
29023124	29023124	PRJEB28589_S_NODE_10308_length_244_cov_1.360406_g10200_i0	PRJEB28589	10308	244	1.360406	3.31939064	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	161	8.459999999999999e-47	NR	MBO4799234.1	1898203	g10200	i0	93.8	1.9672131147541	80	5	98.4	0	241	2	93	172	MBO4799234.1 PEGA domain-containing protein [Lachnospiraceae bacterium]	diamond	480	161	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29054503	29054503	PRJEB28589_S_NODE_5008_length_325_cov_2.931655_g4900_i0	PRJEB28589	5008	325	2.931655	9.52787875	Clostridia bacterium	2044939	Bacteria	Bacteria	43.5	0.0457	NR	MEI3356097.1	2044939	g4900	i0	27.4	0.775384615384615	84	55	77.5	1	64	315	196	273	MEI3356097.1 radical SAM protein [Clostridia bacterium]	diamond	252	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29306876	29306876	PRJEB28589_S_NODE_4309_length_339_cov_4.229452_g4201_i0	PRJEB28589	4309	339	4.229452	14.33784228	Gemella haemolysans	1379	Bacteria	Bacteria	171	1.56e-50	NR	WP_274459383.1	1379	g4201	i0	81.7	2.02654867256637	115	18	99.1	1	337	2	149	263	WP_274459383.1 membrane protein insertase YidC [Gemella haemolysans]	diamond	687	171	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
30570105	30570105	PRJEB28589_S_NODE_8133_length_275_cov_2.013158_g8025_i0	PRJEB28589	8133	275	2.013158	5.5361845	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	73.9	2.42e-14	NR	MBQ2205275.1	1898203	g8025	i0	68.1	0.512727272727273	47	14	51.3	1	133	273	5	50	MBQ2205275.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	141	73.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30879764	30879764	PRJEB28589_S_NODE_9814_length_250_cov_4.876847_g9706_i0	PRJEB28589	9814	250	4.876847	12.1921175	root	1	Root_unresolved	Root_unresolved	70.9	1.3e-12	NR	QHG80001.1	1280	g9706	i0	68.6	1.224	51	16	61.2	0	200	48	36	86	QHG80001.1 hypothetical protein D7B62_12515 [Staphylococcus aureus]	diamond	306	70.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31201838	31201838	PRJEB28589_S_NODE_855_length_553_cov_8.586957_g757_i0	PRJEB28589	855	553	8.586957	47.48587221	Romboutsia sp. 1	1965302	Bacteria	Bacteria	197	6.039999999999998e-56	NR	WP_147516148.1	2787112	g757	i0	73.4	1.34538878842676	124	33	67.3	0	374	3	561	684	WP_147516148.1 molybdopterin oxidoreductase family protein [Romboutsia sp. 1001713B170207_170306_H8]	diamond	744	197	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. 1001713B170207_170306_H8
31929726	31929726	PRJEB28589_S_NODE_6437_length_302_cov_1.686275_g6329_i0	PRJEB28589	6437	302	1.686275	5.0925505	Clostridium sp.	1506	Bacteria	Bacteria	50.4	1.43e-4	NR	HCW52140.1	1506	g6329	i0	35.4	0.78476821192053	79	45	78.5	2	239	3	360	432	HCW52140.1 cell wall-binding protein [Clostridium sp.]	diamond	237	50.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.

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