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

15 rows where analysis = "diamond", bioproject = "PRJNA549880" 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
2395126	2395126	PRJNA549880_P_NODE_982_length_706_cov_3.009479_g899_i0	PRJNA549880	982	706	3.009479	21.24692174	Bacilli bacterium	1903720	Bacteria	Bacteria	296	3.09e-98	NR	HEY8445192.1	1903720	g899	i0	65.7	1.98016997167139	233	74	96.9	2	704	21	5	236	HEY8445192.1 purine-nucleoside phosphorylase [Bacilli bacterium]	diamond	1398	296	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
8164733	8164733	PRJNA549880_P_NODE_2127_length_493_cov_1.159524_g2034_i0	PRJNA549880	2127	493	1.159524	5.71645332	Bacillus cereus group	86661	Bacteria	Bacteria	295	7.45e-95	NR	WP_229136787.1	86661	g2034	i0	100	0.870182555780933	143	0	87	0	64	492	1	143	WP_229136787.1 MULTISPECIES: site-specific DNA-methyltransferase [Bacillus cereus group]	diamond	429	295	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
14540781	14540781	PRJNA549880_P_NODE_4892_length_346_cov_1.150183_g4799_i0	PRJNA549880	4892	346	1.150183	3.97963318	Lactobacillus helveticus	1587	Bacteria	Bacteria	149	1.38e-44	NR	WP_320493255.1	1587	g4799	i0	98.6	0.632947976878613	73	1	63.3	0	54	272	1	73	WP_320493255.1 hypothetical protein [Lactobacillus helveticus]	diamond	219	149	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus helveticus
17089331	17089331	PRJNA549880_P_NODE_14214_length_244_cov_0.900585_g14121_i0	PRJNA549880	14214	244	0.900585	2.1974274	Virgibacillus sp. YIM 98842	2663533	Bacteria	Bacteria	131	3.1499999999999993e-34	NR	WP_164219077.1	2663533	g14121	i0	79	1.99180327868852	81	17	99.6	0	1	243	328	408	WP_164219077.1 adenylosuccinate lyase [Virgibacillus sp. YIM 98842]	diamond	486	131	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus sp. YIM 98842
26888326	26888326	PRJNA549880_P_NODE_15801_length_241_cov_0.886905_g15708_i0	PRJNA549880	15801	241	0.886905	2.13744105	Anaerovorax sp. IOR16	2773458	Bacteria	Bacteria	42.4	0.0492	NR	WP_206458181.1	2773458	g15708	i0	38.6	0.70954356846473	57	29	64.7	2	159	4	210	265	WP_206458181.1 MATE family efflux transporter [Anaerovorax sp. IOR16]	diamond	171	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Anaerovorax	Anaerovorax sp. IOR16
27155574	27155574	PRJNA549880_P_NODE_8182_length_282_cov_1.421053_g8089_i0	PRJNA549880	8182	282	1.421053	4.00736946	Bacillus	1386	Bacteria	Bacteria	90.5	3.46e-21	NR	WP_377826924.1	1396	g8089	i0	100	0.914893617021277	43	0	45.7	0	131	3	1	43	WP_377826924.1 hypothetical protein [Bacillus cereus]	diamond	258	90.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27172540	27172540	PRJNA549880_P_NODE_9082_length_269_cov_1.571429_g8989_i0	PRJNA549880	9082	269	1.571429	4.22714401	Bacillus cereus group	86661	Bacteria	Bacteria	180	1.14e-51	NR	WP_229136787.1	86661	g8989	i0	100	0.992565055762082	89	0	99.3	0	269	3	463	551	WP_229136787.1 MULTISPECIES: site-specific DNA-methyltransferase [Bacillus cereus group]	diamond	267	180	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
28088514	28088514	PRJNA549880_P_NODE_3645_length_389_cov_1.674051_g3552_i0	PRJNA549880	3645	389	1.674051	6.51205839	Clostridium sp.	1506	Bacteria	Bacteria	47.4	0.00424	NR	MDO5518793.1	1506	g3552	i0	46.2	0.794344473007712	52	28	40.1	0	9	164	131	182	MDO5518793.1 discoidin domain-containing protein [Clostridium sp.]	diamond	309	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
28861140	28861140	PRJNA549880_P_NODE_13868_length_244_cov_1.350877_g13775_i0	PRJNA549880	13868	244	1.350877	3.29613988	PVC group	1783257	Bacteria	Bacteria	48.9	1.56e-4	NR	WP_107391568.1	29379	g13775	i0	45.2	2.12704918032787	62	32	75	2	242	60	121	181	WP_107391568.1 NUDIX domain-containing protein [Staphylococcus auricularis]	diamond	519	48.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
29288327	29288327	PRJNA549880_P_NODE_6449_length_311_cov_17.134454_g6356_i0	PRJNA549880	6449	311	17.134454	53.28815194	Veillonella sp.	1926307	Bacteria	Bacteria	160	1.28e-48	NR	WP_366512514.1	1926307	g6356	i0	73.5	1.96784565916399	102	27	98.4	0	1	306	4	105	WP_366512514.1 hypothetical protein [Veillonella sp.]	diamond	612	160	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
29666973	29666973	PRJNA549880_P_NODE_11290_length_249_cov_2.136364_g11197_i0	PRJNA549880	11290	249	2.136364	5.31954636	Paenibacillus tepidiphilus	2608683	Bacteria	Bacteria	43.1	0.0293	NR	WP_150274906.1	2608683	g11197	i0	44.4	0.542168674698795	45	25	54.2	0	3	137	85	129	WP_150274906.1 metallophosphoesterase [Paenibacillus tepidiphilus]	diamond	135	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus tepidiphilus
30140715	30140715	PRJNA549880_P_NODE_7492_length_291_cov_2.472477_g7399_i0	PRJNA549880	7492	291	2.472477	7.19490807	Cytobacillus firmus	1399	Bacteria	Bacteria	152	1.9199999999999998e-40	NR	WP_222501891.1	1399	g7399	i0	85.2	2.50515463917526	81	12	83.5	0	244	2	1	81	WP_222501891.1 TnsA endonuclease N-terminal domain-containing protein [Cytobacillus firmus]	diamond	729	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus firmus
32227828	32227828	PRJNA549880_P_NODE_8418_length_279_cov_1.354369_g8325_i0	PRJNA549880	8418	279	1.354369	3.77868951	Bacillota bacterium	1879010	Bacteria	Bacteria	112	1.72e-27	NR	MFO7248391.1	1879010	g8325	i0	64.5	1	93	33	100	0	1	279	159	251	MFO7248391.1 aspartate carbamoyltransferase catalytic subunit [Bacillota bacterium]	diamond	279	112	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
32322903	32322903	PRJNA549880_P_NODE_8599_length_277_cov_1.161765_g8506_i0	PRJNA549880	8599	277	1.161765	3.21808905	Bacillus cereus	1396	Bacteria	Bacteria	114	2.35e-28	NR	WP_003306206.1	1396	g8506	i0	71.7	0.996389891696751	92	26	99.6	0	1	276	160	251	WP_003306206.1 hypothetical protein [Bacillus cereus]	diamond	276	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
32733257	32733257	PRJNA549880_P_NODE_12400_length_247_cov_0.885057_g12307_i0	PRJNA549880	12400	247	0.885057	2.18609079	Virgibacillus profundi	2024555	Bacteria	Bacteria	102	3.669999999999999e-24	NR	WP_206207806.1	2024555	g12307	i0	73.9	9.20647773279352	69	18	83.8	0	3	209	213	281	WP_206207806.1 SPFH domain-containing protein [Virgibacillus profundi]	diamond	2274	102	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus profundi

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