metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1136957" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1136957" 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
21961349	21961349	PRJNA1136957_S_NODE_1698_length_498_cov_19.769932_g1602_i0	PRJNA1136957	1698	498	19.769932	98.45426136	root	1	Root_unresolved	Root_unresolved	171	6.64e-51	NR	MDJ8942385.1	1502	g1602	i0	79.4	1.8433734939759	102	21	61.4	0	495	190	94	195	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	918	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
24510525	24510525	PRJNA1136957_S_NODE_1560_length_510_cov_148.902439_g1465_i0	PRJNA1136957	1560	510	148.902439	759.4024389	root	1	Root_unresolved	Root_unresolved	187	3.2800000000000004e-58	NR	MRC56835.1	1428	g1465	i0	80	12.7117647058824	115	22	67.6	1	447	103	10	123	MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis]	diamond	6483	188	0.99468085106383	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
26880710	26880710	PRJNA1136957_S_NODE_3381_length_404_cov_19.742029_g3284_i0	PRJNA1136957	3381	404	19.742029	79.75779716	Bacillus thuringiensis	1428	Bacteria	Bacteria	68.2	2.82e-12	NR	MRA94196.1	1428	g3284	i0	50.9	0.423267326732673	57	28	42.3	0	4	174	12	68	MRA94196.1 hypothetical protein [Bacillus thuringiensis]	diamond	171	68.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
28554863	28554863	PRJNA1136957_S_NODE_13847_length_232_cov_1.763006_g13750_i0	PRJNA1136957	13847	232	1.763006	4.09017392	Streptococcus agalactiae	1311	Bacteria	Bacteria	40.4	0.0445	NR	WP_341775314.1	1311	g13750	i0	57.1	0.362068965517241	28	12	36.2	0	86	169	25	52	WP_341775314.1 reverse transcriptase domain-containing protein, partial [Streptococcus agalactiae]	diamond	84	40.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
29059971	29059971	PRJNA1136957_S_NODE_21228_length_190_cov_2.160305_g21131_i0	PRJNA1136957	21228	190	2.160305	4.1045795	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	52.8	5.15e-6	NR	NLO21705.1	2093811	g21131	i0	57.9	2.4	38	16	60	0	188	75	13	50	NLO21705.1 DEAD/DEAH box helicase [Syntrophomonadaceae bacterium]	diamond	456	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
29407122	29407122	PRJNA1136957_S_NODE_789_length_611_cov_2.594203_g711_i0	PRJNA1136957	789	611	2.594203	15.85058033	Bacillus thuringiensis	1428	Bacteria	Bacteria	82.8	1.24e-16	NR	MRA75726.1	1428	g711	i0	44.3	0.854337152209493	97	54	47.6	0	296	6	4	100	MRA75726.1 hypothetical protein [Bacillus thuringiensis]	diamond	522	82.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
29881013	29881013	PRJNA1136957_S_NODE_18791_length_201_cov_1.119718_g18694_i0	PRJNA1136957	18791	201	1.119718	2.25063318	Hominilimicola	3073565	Bacteria	Bacteria	53.5	5.05e-7	NR	WP_022230028.1	3073565	g18694	i0	43.9	0.850746268656716	57	32	85.1	0	3	173	61	117	WP_022230028.1 MULTISPECIES: hypothetical protein [Hominilimicola]	diamond	171	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Hominilimicola
31397714	31397714	PRJNA1136957_S_NODE_1976_length_475_cov_3.278846_g1879_i0	PRJNA1136957	1976	475	3.278846	15.5745185	Ammoniphilus sp. YIM 78166	1644106	Bacteria	Bacteria	60.8	1.68e-7	NR	WP_134702773.1	1644106	g1879	i0	49.1	0.334736842105263	53	26	32.8	1	437	282	317	369	WP_134702773.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Ammoniphilus sp. YIM 78166]	diamond	159	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Ammoniphilus	Ammoniphilus sp. YIM 78166

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