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

11 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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
26819711	26819711	PRJNA1215774_P_NODE_69381_length_251_cov_0.865169_g69061_i0	PRJNA1215774	69381	251	0.865169	2.17157419	Clostridia bacterium	2044939	Bacteria	Bacteria	156	3.4e-42	NR	MDD7672200.1	2044939	g69061	i0	83.1	5.90438247011952	83	14	99.2	0	3	251	262	344	MDD7672200.1 LuxR C-terminal-related transcriptional regulator [Clostridia bacterium]	diamond	1482	156	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27104126	27104126	PRJNA1215774_P_NODE_67842_length_252_cov_1.312849_g67522_i0	PRJNA1215774	67842	252	1.312849	3.30837948	Oscillibacter sp. ER4	1519439	Bacteria	Bacteria	164	5e-48	NR	WP_033121361.1	1519439	g67522	i0	100	0.976190476190476	82	0	97.6	0	6	251	44	125	WP_033121361.1 diacylglycerol/lipid kinase family protein [Oscillibacter sp. ER4]	diamond	246	164	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Oscillibacter	Oscillibacter sp. ER4
27515068	27515068	PRJNA1215774_P_NODE_82503_length_242_cov_0.911243_g82183_i0	PRJNA1215774	82503	242	0.911243	2.20520806	Clostridioides difficile	1496	Bacteria	Bacteria	59.3	1.34e-9	NR	WP_330614520.1	1496	g82183	i0	100	0.384297520661157	31	0	38.4	0	154	62	1	31	WP_330614520.1 hypothetical protein, partial [Clostridioides difficile]	diamond	93	59.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
27673093	27673093	PRJNA1215774_P_NODE_70564_length_250_cov_0.870056_g70244_i0	PRJNA1215774	70564	250	0.870056	2.17514	Peptoniphilus	162289	Bacteria	Bacteria	132	1.81e-36	NR	WP_023055239.1	162289	g70244	i0	100	0.756	63	0	75.6	0	189	1	1	63	WP_023055239.1 MULTISPECIES: DUF2249 domain-containing protein [Peptoniphilus]	diamond	189	132	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus
27957132	27957132	PRJNA1215774_P_NODE_75865_length_246_cov_1.520231_g75545_i0	PRJNA1215774	75865	246	1.520231	3.73976826	Staphylococcus sp. HMSC	29387	Bacteria	Bacteria	157	6.9099999999999986e-43	NR	WP_070812542.1	1715065	g75545	i0	100	0.98780487804878	81	0	98.8	0	244	2	287	367	WP_070812542.1 DNA topoisomerase III [Staphylococcus sp. HMSC034G07]	diamond	243	157	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus sp. HMSC034G07
28083300	28083300	PRJNA1215774_P_NODE_74625_length_247_cov_0.885057_g74305_i0	PRJNA1215774	74625	247	0.885057	2.18609079	unclassified Paenibacillus	185978	Bacteria	Bacteria	43.5	0.0207	NR	WP_216537734.1	185978	g74305	i0	31.9	1.74898785425101	72	45	82.6	1	223	20	249	320	WP_216537734.1 MULTISPECIES: ammonium transporter [unclassified Paenibacillus]	diamond	432	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
28449675	28449675	PRJNA1215774_P_NODE_32806_length_369_cov_1.037162_g32486_i0	PRJNA1215774	32806	369	1.037162	3.82712778	FCB group	1783270	Bacteria	Bacteria	107	2.02e-27	NR	MBR2505770.1	1903720	g32486	i0	50.5	6.0650406504065	103	51	83.7	0	368	60	11	113	MBR2505770.1 GPW/gp25 family protein [Bacilli bacterium]	diamond	2238	108	0.990740740740741	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30577965	30577965	PRJNA1215774_P_NODE_42873_length_322_cov_1.040161_g42553_i0	PRJNA1215774	42873	322	1.040161	3.34931842	Gracilibacteraceae bacterium	2699748	Bacteria	Bacteria	44.7	0.0208	NR	NLK34148.1	2699748	g42553	i0	38.3	0.437888198757764	47	29	43.8	0	121	261	574	620	NLK34148.1 glycosyl transferase [Gracilibacteraceae bacterium]	diamond	141	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Gracilibacteraceae		Gracilibacteraceae bacterium
30641249	30641249	PRJNA1215774_P_NODE_70073_length_250_cov_0.870056_g69753_i0	PRJNA1215774	70073	250	0.870056	2.17514	Clostridium sp. CAG:492	1262813	Bacteria	Bacteria	175	2.71e-51	NR	CDA30803.1	1262813	g69753	i0	100	0.984	82	0	98.4	0	248	3	83	164	CDA30803.1 putative uncharacterized protein [Clostridium sp. CAG:492]	diamond	246	175	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. CAG:492
31052425	31052425	PRJNA1215774_P_NODE_80035_length_244_cov_0.900585_g79715_i0	PRJNA1215774	80035	244	0.900585	2.1974274	Lachnospira eligens	39485	Bacteria	Bacteria	110	5.850000000000001e-26	NR	WP_349156672.1	39485	g79715	i0	100	1.73360655737705	47	0	57.8	0	243	103	507	553	WP_349156672.1 GH25 family lysozyme [Lachnospira eligens]	diamond	423	110	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnospira	Lachnospira eligens
32095788	32095788	PRJNA1215774_P_NODE_84078_length_241_cov_0.916667_g83758_i0	PRJNA1215774	84078	241	0.916667	2.20916747	Bacillus mycoides	1405	Bacteria	Bacteria	58.2	9.71e-9	NR	WP_256492806.1	1405	g83758	i0	50	0.622406639004149	50	25	62.2	0	150	1	7	56	WP_256492806.1 P27 family phage terminase small subunit [Bacillus mycoides]	diamond	150	58.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides

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