metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax

13 rows where analysis = "diamond", bioproject = "PRJEB14664" 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
22973284	22973284	PRJEB14664_P_NODE_9219_length_256_cov_1.447964_g9089_i0	PRJEB14664	9219	256	1.447964	3.70678784	Clostridia	186801	Bacteria	Bacteria	138	9.08e-40	NR	PUU91525.1	1895664	g9089	i0	76.5	37.86328125	85	20	99.6	0	1	255	35	119	PUU91525.1 MAG: formate acetyltransferase 1 [Halanaerobium sp.]	diamond	9693	139	0.992805755395683	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium sp.
26709799	26709799	PRJEB14664_P_NODE_11081_length_225_cov_1.684211_g10951_i0	PRJEB14664	11081	225	1.684211	3.78947475	FCB group	1783270	Bacteria	Bacteria	42.4	0.0428	NR	WP_377522929.1	1340531	g10951	i0	48.9	2	47	23	61.3	1	204	67	1122	1168	WP_377522929.1 cadherin-like beta sandwich domain-containing protein [Paenibacillus abyssi]	diamond	450	42.7	0.992974238875878	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus abyssi
27285901	27285901	PRJEB14664_P_NODE_20423_length_150_cov_1.043478_g20293_i0	PRJEB14664	20423	150	1.043478	1.565217	Pseudobutyrivibrio sp.	2014367	Bacteria	Bacteria	41.2	0.0349	NR	MCR4567690.1	2014367	g20293	i0	51.1	0.94	47	21	90	1	148	14	118	164	MCR4567690.1 lysozyme [Pseudobutyrivibrio sp.]	diamond	141	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Pseudobutyrivibrio	Pseudobutyrivibrio sp.
27633440	27633440	PRJEB14664_P_NODE_15764_length_177_cov_1.126761_g15634_i0	PRJEB14664	15764	177	1.126761	1.99436697	Solibacillus palustris	2908203	Bacteria	Bacteria	71.2	1.33e-12	NR	WP_241368078.1	2908203	g15634	i0	54.4	1.93220338983051	57	26	96.6	0	6	176	476	532	WP_241368078.1 CocE/NonD family hydrolase [Solibacillus palustris]	diamond	342	71.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Solibacillus	Solibacillus palustris
27759958	27759958	PRJEB14664_P_NODE_18644_length_158_cov_1.284553_g18514_i0	PRJEB14664	18644	158	1.284553	2.02959374	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	41.6	0.0305	NR	MBO5337010.1	1898203	g18514	i0	44	0.949367088607595	50	25	93	2	152	6	487	534	MBO5337010.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	150	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28264659	28264659	PRJEB14664_P_NODE_16866_length_169_cov_1.194030_g16736_i0	PRJEB14664	16866	169	1.19403	2.0179107	Veillonellales bacterium	2870862	Bacteria	Bacteria	57	4.56e-8	NR	MEN6565587.1	2870862	g16736	i0	50	3.88757396449704	46	23	81.7	0	22	159	44	89	MEN6565587.1 hypothetical protein [Veillonellales bacterium]	diamond	657	57	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales			Veillonellales bacterium
28574150	28574150	PRJEB14664_P_NODE_13067_length_201_cov_1.180723_g12937_i0	PRJEB14664	13067	201	1.180723	2.37325323	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	57	1.97e-7	NR	MCA9750439.1	1965302	g12937	i0	45.7	4.11940298507463	70	34	98.5	3	2	199	53	122	MCA9750439.1 GTPase RsgA [Romboutsia sp.]	diamond	828	57	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp.
28738472	28738472	PRJEB14664_P_NODE_8527_length_270_cov_1.965957_g8397_i0	PRJEB14664	8527	270	1.965957	5.3080839	Clostridiales bacterium	1898207	Bacteria	Bacteria	41.6	0.0398	NR	MBS6367802.1	1898207	g8397	i0	44.9	0.544444444444444	49	25	52.2	1	34	174	39	87	MBS6367802.1 GNAT family N-acetyltransferase [Clostridiales bacterium]	diamond	147	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28833106	28833106	PRJEB14664_P_NODE_19528_length_154_cov_1.008403_g19398_i0	PRJEB14664	19528	154	1.008403	1.55294062	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42	0.0204	NR	MCL1828923.1	2485925	g19398	i0	46.7	1.75324675324675	45	24	87.7	0	152	18	1144	1188	MCL1828923.1 chromosome segregation protein SMC [Oscillospiraceae bacterium]	diamond	270	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
30064534	30064534	PRJEB14664_P_NODE_15952_length_175_cov_1.714286_g15822_i0	PRJEB14664	15952	175	1.714286	3.0000005	Limnochordales bacterium	2602711	Bacteria	Bacteria	94.7	7.02e-21	NR	MBE3577701.1	2602711	g15822	i0	80.7	4.88571428571429	57	11	97.7	0	173	3	377	433	MBE3577701.1 pyruvate, phosphate dikinase [Limnochordales bacterium]	diamond	855	94.7	1	Bacteria	Bacillati	Bacillota	Limnochordia	Limnochordales			Limnochordales bacterium
30159184	30159184	PRJEB14664_P_NODE_14412_length_188_cov_1.830065_g14282_i0	PRJEB14664	14412	188	1.830065	3.4405222	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	41.6	0.0461	NR	MBE6142392.1	2049044	g14282	i0	59.3	0.797872340425532	27	11	43.1	0	4	84	392	418	MBE6142392.1 hypothetical protein [Erysipelotrichaceae bacterium]	diamond	150	41.6	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
30981140	30981140	PRJEB14664_P_NODE_7794_length_287_cov_0.980159_g7664_i0	PRJEB14664	7794	287	0.980159	2.81305633	Halobacillus amylolyticus	2932259	Bacteria	Bacteria	44.3	0.0172	NR	WP_245033419.1	2932259	g7664	i0	27.5	0.836236933797909	80	52	77.4	1	47	268	21	100	WP_245033419.1 cytochrome P450 family protein [Halobacillus amylolyticus]	diamond	240	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus amylolyticus
31834500	31834500	PRJEB14664_P_NODE_15717_length_177_cov_1.408451_g15587_i0	PRJEB14664	15717	177	1.408451	2.49295827	Cytobacillus oceanisediminis	665099	Bacteria	Bacteria	40	0.0269	NR	MBZ9537010.1	665099	g15587	i0	35	1.01694915254237	60	34	93.2	2	10	174	9	68	MBZ9537010.1 HAD family hydrolase [Cytobacillus oceanisediminis]	diamond	180	40	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus oceanisediminis

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