metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1050291" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1050291" 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
175981	175981	PRJNA1050291_P_NODE_19401_length_248_cov_0.891429_g18510_i0	PRJNA1050291	19401	248	0.891429	2.21074392	Clostridium	1485	Bacteria	Bacteria	65.5	3.77e-10	NR	MBS6517058.1	1506	g18510	i0	100	1.30645161290323	27	0	32.7	0	247	167	43	69	MBS6517058.1 nickel pincer cofactor biosynthesis protein LarC [Clostridium sp.]	diamond	324	65.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
20577051	20577051	PRJNA1050291_P_NODE_19837_length_246_cov_1.745665_g18946_i0	PRJNA1050291	19837	246	1.745665	4.2943359	root	1	Root_unresolved	Root_unresolved	119	1.61e-32	NR	WP_340574601.1	1280	g18946	i0	72.8	16.7926829268293	81	22	98.8	0	245	3	43	123	WP_340574601.1 complex I subunit 1 family protein, partial [Staphylococcus aureus]	diamond	4131	120	0.991666666666667	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27375232	27375232	PRJNA1050291_P_NODE_18803_length_250_cov_1.762712_g17912_i0	PRJNA1050291	18803	250	1.762712	4.40678	Bacteria	2	Bacteria	Bacteria	162	2.53e-45	NR	MBS6249543.1	1898207	g17912	i0	100	1.968	82	0	98.4	0	250	5	478	559	MBS6249543.1 alpha-galactosidase [Clostridiales bacterium]	diamond	492	162	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27375234	27375234	PRJNA1050291_P_NODE_22243_length_227_cov_2.006494_g21352_i0	PRJNA1050291	22243	227	2.006494	4.55474138	Anaerococcus	165779	Bacteria	Bacteria	118	7.379999999999999e-32	NR	WP_101539724.1	165779	g21352	i0	100	1.74449339207048	66	0	87.2	0	28	225	1	66	WP_101539724.1 MULTISPECIES: DUF4446 family protein [Anaerococcus]	diamond	396	118	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus
27951405	27951405	PRJNA1050291_P_NODE_20585_length_244_cov_0.912281_g19694_i0	PRJNA1050291	20585	244	0.912281	2.22596564	Anaerococcus hydrogenalis	33029	Bacteria	Bacteria	150	2.04e-42	NR	MDU3153072.1	33029	g19694	i0	100	1.9672131147541	80	0	98.4	0	3	242	199	278	MDU3153072.1 uracil permease [Anaerococcus hydrogenalis]	diamond	480	150	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus hydrogenalis
28235244	28235244	PRJNA1050291_P_NODE_14986_length_285_cov_1.471698_g14095_i0	PRJNA1050291	14986	285	1.471698	4.1943393	Clostridiales bacterium	1898207	Bacteria	Bacteria	53.5	8.94e-6	NR	HHT97140.1	1898207	g14095	i0	34.1	0.957894736842105	91	57	95.8	1	2	274	127	214	HHT97140.1 hypothetical protein [Clostridiales bacterium]	diamond	273	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28646082	28646082	PRJNA1050291_P_NODE_20827_length_243_cov_0.917647_g19936_i0	PRJNA1050291	20827	243	0.917647	2.22988221	Aedoeadaptatus acetigenes	2981723	Bacteria	Bacteria	116	2.07e-29	NR	WP_148474359.1	2981723	g19936	i0	96.8	0.765432098765432	62	2	76.5	0	242	57	268	329	WP_148474359.1 tryptophan--tRNA ligase [Aedoeadaptatus acetigenes]	diamond	186	116	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus acetigenes
29592781	29592781	PRJNA1050291_P_NODE_21170_length_242_cov_0.923077_g20279_i0	PRJNA1050291	21170	242	0.923077	2.23384634	Alterileibacterium massiliense	1870997	Bacteria	Bacteria	64.3	8.98e-10	NR	WP_071132764.1	1870997	g20279	i0	78.4	0.45867768595041303	37	8	45.9	0	130	240	1	37	WP_071132764.1 threonine synthase [Alterileibacterium massiliense]	diamond	111	64.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Alterileibacterium	Alterileibacterium massiliense
29932640	29932640	PRJNA1050291_P_NODE_3371_length_1057_cov_7.970528_g2514_i0	PRJNA1050291	3371	1057	7.970528	84.24848096	Mobilitalea	1649471	Bacteria	Bacteria	230	1.09e-63	NR	MBQ8315863.1	1898203	g2514	i0	40.8	5.96026490066225	346	197	97.6	7	11	1042	472	811	MBQ8315863.1 Ig-like domain-containing protein [Lachnospiraceae bacterium]	diamond	6300	230	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30320264	30320264	PRJNA1050291_P_NODE_15972_length_274_cov_1.552239_g15081_i0	PRJNA1050291	15972	274	1.552239	4.25313486	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	171	1.25e-51	NR	MBS5131373.1	1898203	g15081	i0	94.5	0.996350364963504	91	5	99.6	0	273	1	101	191	MBS5131373.1 TrmB family transcriptional regulator [Lachnospiraceae bacterium]	diamond	273	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30477766	30477766	PRJNA1050291_P_NODE_20833_length_243_cov_0.917647_g19942_i0	PRJNA1050291	20833	243	0.917647	2.22988221	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	140	2.0199999999999997e-37	NR	MFR0790592.1	1898203	g19942	i0	100	0.987654320987654	80	0	98.8	0	241	2	290	369	MFR0790592.1 restriction endonuclease subunit S [Lachnospiraceae bacterium]	diamond	240	140	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30920205	30920205	PRJNA1050291_P_NODE_6214_length_575_cov_5.205179_g5323_i0	PRJNA1050291	6214	575	5.205179	29.92977925	Brevibacillus	55080	Bacteria	Bacteria	173	6.62e-51	NR	WP_026557609.1	55080	g5323	i0	48.7	7.5495652173913	189	86	98.6	3	569	3	3	180	WP_026557609.1 MULTISPECIES: class I SAM-dependent methyltransferase [Brevibacillus]	diamond	4341	173	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus
31038563	31038563	PRJNA1050291_P_NODE_18135_length_253_cov_0.866667_g17244_i0	PRJNA1050291	18135	253	0.866667	2.19266751	Bacilli	91061	Bacteria	Bacteria	143	2.15e-37	NR	MDU4503089.1	1292	g17244	i0	77.1	8.82213438735178	83	19	98.4	0	5	253	1200	1282	MDU4503089.1 hypothetical protein [Staphylococcus warneri]	diamond	2232	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
31140753	31140753	PRJNA1050291_P_NODE_20515_length_244_cov_0.912281_g19624_i0	PRJNA1050291	20515	244	0.912281	2.22596564	Peptoniphilus senegalensis	1465757	Bacteria	Bacteria	85.1	1.75e-19	NR	WP_412627688.1	1465757	g19624	i0	100	1.43852459016393	39	0	48	0	242	126	55	93	WP_412627688.1 23S rRNA (pseudouridine(1915)-N(3))-methyltransferase RlmH, partial [Peptoniphilus senegalensis]	diamond	351	85.1	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus senegalensis
31678670	31678670	PRJNA1050291_P_NODE_13677_length_304_cov_1.350649_g12786_i0	PRJNA1050291	13677	304	1.350649	4.10597296	Chengkuizengella axinellae	3064388	Bacteria	Bacteria	62	1.39e-8	NR	WP_305990983.1	3064388	g12786	i0	49.2	0.601973684210526	61	27	60.2	2	186	4	2601	2657	WP_305990983.1 PA14 domain-containing protein [Chengkuizengella axinellae]	diamond	183	62	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Chengkuizengella	Chengkuizengella axinellae

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