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

8 rows where analysis = "diamond", bioproject = "PRJNA235310" 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
26852737	26852737	PRJNA235310_P_NODE_3521_length_201_cov_1.230263_g3495_i0	PRJNA235310	3521	201	1.230263	2.47282863	Ruminococcus sp.	41978	Bacteria	Bacteria	67	2.78e-11	NR	MBQ6180627.1	41978	g3495	i0	55.2	12.5970149253731	58	25	86.6	1	178	5	4	60	MBQ6180627.1 methyltransferase domain-containing protein [Ruminococcus sp.]	diamond	2532	67	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
26852740	26852740	PRJNA235310_P_NODE_4401_length_178_cov_0.829457_g4375_i0	PRJNA235310	4401	178	0.829457	1.47643346	Paenibacillus xerothermodurans	1977292	Bacteria	Bacteria	74.7	1.97e-15	NR	WP_089201178.1	1977292	g4375	i0	72.3	0.792134831460674	47	13	79.2	0	141	1	4	50	WP_089201178.1 group I truncated hemoglobin [Paenibacillus xerothermodurans]	diamond	141	74.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus xerothermodurans
27958407	27958407	PRJNA235310_P_NODE_1225_length_364_cov_1.787302_g1199_i0	PRJNA235310	1225	364	1.787302	6.50577928	Priestia megaterium	1404	Bacteria	Bacteria	99.8	5.31e-23	NR	WP_114896361.1	1404	g1199	i0	44.7	0.93956043956044	114	59	94	2	19	360	2	111	WP_114896361.1 SDR family oxidoreductase [Priestia megaterium]	diamond	342	99.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
27976087	27976087	PRJNA235310_P_NODE_5665_length_165_cov_1.344828_g5639_i0	PRJNA235310	5665	165	1.344828	2.2189662	Bacillota	1239	Bacteria	Bacteria	65.9	2.91e-12	NR	HJF54257.1	181675	g5639	i0	54	2.70909090909091	50	23	90.9	0	160	11	22	71	HJF54257.1 aldo/keto reductase [Limosilactobacillus coleohominis]	diamond	447	65.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus coleohominis
28495312	28495312	PRJNA235310_P_NODE_5247_length_167_cov_1.322034_g5221_i0	PRJNA235310	5247	167	1.322034	2.20779678	Clostridia bacterium	2044939	Bacteria	Bacteria	54.7	4.78e-7	NR	MEI3390343.1	2044939	g5221	i0	46.4	2.04790419161677	56	29	98.8	1	167	3	131	186	MEI3390343.1 HD domain-containing protein [Clostridia bacterium]	diamond	342	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28779200	28779200	PRJNA235310_P_NODE_307_length_633_cov_2.782534_g285_i0	PRJNA235310	307	633	2.782534	17.61344022	Pontibacillus sp. HMF3514	2692425	Bacteria	Bacteria	147	2.35e-41	NR	WP_160098424.1	2692425	g285	i0	47.9	1.96208530805687	140	73	66.4	0	132	551	5	144	WP_160098424.1 OsmC family protein [Pontibacillus sp. HMF3514]	diamond	1242	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Pontibacillus	Pontibacillus sp. HMF3514
29775737	29775737	PRJNA235310_P_NODE_4631_length_173_cov_1.250000_g4605_i0	PRJNA235310	4631	173	1.25	2.1625	root	1	Root_unresolved	Root_unresolved	88.2	1.4e-18	NR	WP_251677830.1	562959	g4605	i0	74.5	56.2543352601156	55	14	95.4	0	173	9	41	95	WP_251677830.1 S-layer homology domain-containing protein [Paenibacillus cellulositrophicus]	diamond	9732	89	0.991011235955056	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cellulositrophicus
31749003	31749003	PRJNA235310_P_NODE_1957_length_282_cov_1.605150_g1931_i0	PRJNA235310	1957	282	1.60515	4.526523	Priestia megaterium	1404	Bacteria	Bacteria	69.7	5.9e-12	NR	WP_114896361.1	1404	g1931	i0	47.4	0.829787234042553	78	37	83	2	48	281	5	78	WP_114896361.1 SDR family oxidoreductase [Priestia megaterium]	diamond	234	69.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium

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