metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
24937651	24937651	PRJNA724039_S_NODE_17760_length_151_cov_4.008772_g17553_i0	PRJNA724039	17760	151	4.008772	6.05324572	Chloroflexota bacterium	2026724	Bacteria	Bacteria	70.9	7.2e-13	NR	HEY8286704.1	2026724	g17553	i0	67.3	2.9205298013245	49	14	93.4	1	149	9	71	119	HEY8286704.1 methyltransferase domain-containing protein [Chloroflexota bacterium]	diamond	441	70.9	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
26873030	26873030	PRJNA724039_S_NODE_10821_length_196_cov_2.924528_g10614_i0	PRJNA724039	10821	196	2.924528	5.73207488	Bacteria	2	Bacteria	Bacteria	65.1	2.23e-10	NR	WP_259617642.1	1229154	g10614	i0	46.2	4.83673469387755	65	35	99.5	0	1	195	70	134	WP_259617642.1 biotin-dependent carboxyltransferase family protein [Paenibacillus doosanensis]	diamond	948	65.5	0.993893129770992	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus doosanensis
27473400	27473400	PRJNA724039_S_NODE_4823_length_320_cov_2.353357_g4616_i0	PRJNA724039	4823	320	2.353357	7.5307424	Bacteria	2	Bacteria	Bacteria	79	2.02e-15	NR	WP_115856743.1	46127	g4616	i0	45.9	2.11875	74	40	69.4	0	319	98	138	211	WP_115856743.1 pyroglutamyl-peptidase I [Staphylococcus felis]	diamond	678	79	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus felis
27684428	27684428	PRJNA724039_S_NODE_13844_length_172_cov_1.429630_g13637_i0	PRJNA724039	13844	172	1.42963	2.4589636	Nostoc linckia z16	1628751	Bacteria	Bacteria	115	1.8499999999999999e-28	NR	PHK27803.1	1628751	g13637	i0	100	0.976744186046512	56	0	97.7	0	3	170	123	178	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	168	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
27883810	27883810	PRJNA724039_S_NODE_8985_length_218_cov_4.408840_g8778_i0	PRJNA724039	8985	218	4.40884	9.6112712	Bacteria	2	Bacteria	Bacteria	99	4.21e-25	NR	MFK5281896.1	1597	g8778	i0	63.5	2.82110091743119	63	23	86.7	0	30	218	3	65	MFK5281896.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	615	100	0.99	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
28000021	28000021	PRJNA724039_S_NODE_8345_length_229_cov_2.416667_g8138_i0	PRJNA724039	8345	229	2.416667	5.53416743	Clostridia bacterium	2044939	Bacteria	Bacteria	55.5	5.54e-7	NR	HYF82516.1	2044939	g8138	i0	57.5	1.02183406113537	40	17	52.4	0	108	227	15	54	HYF82516.1 HutD family protein [Clostridia bacterium]	diamond	234	55.5	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
28010373	28010373	PRJNA724039_S_NODE_9565_length_211_cov_1.327586_g9358_i0	PRJNA724039	9565	211	1.327586	2.80120646	Actinomycetes	1760	Bacteria	Bacteria	73.6	3.33e-13	NR	WP_091076155.1	546874	g9358	i0	51.4	5.74407582938389	70	34	99.5	0	1	210	187	256	WP_091076155.1 NAD-dependent succinate-semialdehyde dehydrogenase [Microlunatus sagamiharensis]	diamond	1212	74.3	0.990578734858681	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
28347094	28347094	PRJNA724039_S_NODE_7046_length_254_cov_2.096774_g6839_i0	PRJNA724039	7046	254	2.096774	5.32580596	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	129	3.61e-37	NR	MFA6208533.1	2364082	g6839	i0	95.7	0.826771653543307	70	3	82.7	0	43	252	1	70	MFA6208533.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	210	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28978740	28978740	PRJNA724039_S_NODE_9008_length_218_cov_1.917127_g8801_i0	PRJNA724039	9008	218	1.917127	4.17933686	Nostoc linckia z16	1628751	Bacteria	Bacteria	142	3.87e-38	NR	PHK27803.1	1628751	g8801	i0	98.6	0.990825688073395	72	1	99.1	0	1	216	172	243	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	216	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
29136723	29136723	PRJNA724039_S_NODE_15849_length_160_cov_2.186992_g15642_i0	PRJNA724039	15849	160	2.186992	3.4991872	Nostoc linckia z16	1628751	Bacteria	Bacteria	102	6.3e-24	NR	PHK27803.1	1628751	g15642	i0	100	0.975	52	0	97.5	0	3	158	302	353	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	156	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
29294330	29294330	PRJNA724039_S_NODE_14849_length_165_cov_4.453125_g14642_i0	PRJNA724039	14849	165	4.453125	7.34765625	Corynebacterium ammoniagenes	1697	Bacteria	Bacteria	41.2	0.0106	NR	GJN44007.1	1697	g14642	i0	63.3	0.545454545454545	30	10	54.5	1	5	94	37	65	GJN44007.1 hypothetical protein CAT723_24860 [Corynebacterium ammoniagenes]	diamond	90	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium ammoniagenes
29451872	29451872	PRJNA724039_S_NODE_11510_length_190_cov_1.470588_g11303_i0	PRJNA724039	11510	190	1.470588	2.7941172	Candidatus Chloroploca asiatica	1506545	Bacteria	Bacteria	44.3	0.00538	NR	WP_172451194.1	1506545	g11303	i0	46.8	0.742105263157895	47	25	74.2	0	141	1	596	642	WP_172451194.1 diguanylate cyclase [Candidatus Chloroploca asiatica]	diamond	141	44.3	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Oscillochloridaceae	Candidatus Chloroploca	Candidatus Chloroploca asiatica
29641312	29641312	PRJNA724039_S_NODE_16910_length_155_cov_1.915254_g16703_i0	PRJNA724039	16910	155	1.915254	2.9686437	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	57.8	5.52e-8	NR	HEX8997723.1	2306968	g16703	i0	55.1	0.948387096774194	49	21	94.8	1	8	154	364	411	HEX8997723.1 NADH-quinone oxidoreductase subunit N [Ktedonobacterales bacterium]	diamond	147	57.8	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
30305458	30305458	PRJNA724039_S_NODE_12452_length_182_cov_1.586207_g12245_i0	PRJNA724039	12452	182	1.586207	2.88689674	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.4	0.0233	NR	MCB9436685.1	2073117	g12245	i0	41.9	1.02197802197802	62	31	95.6	2	177	4	154	214	MCB9436685.1 DUF11 domain-containing protein [Anaerolineales bacterium]	diamond	186	42.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30557529	30557529	PRJNA724039_S_NODE_15553_length_162_cov_1.224000_g15346_i0	PRJNA724039	15553	162	1.224	1.98288	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	1.18e-4	NR	MCW5848612.1	2052143	g15346	i0	47.2	0.981481481481482	53	28	98.1	0	159	1	66	118	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	159	47	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31853773	31853773	PRJNA724039_S_NODE_17317_length_153_cov_2.982759_g17110_i0	PRJNA724039	17317	153	2.982759	4.56362127	uncultured Anaerotignum sp.	2039243	Bacteria	Bacteria	50.8	1.55e-5	NR	WP_294680500.1	2039243	g17110	i0	56.1	0.803921568627451	41	18	80.4	0	135	13	419	459	WP_294680500.1 tetratricopeptide repeat protein [uncultured Anaerotignum sp.]	diamond	123	50.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Anaerotignaceae	Anaerotignum	uncultured Anaerotignum sp.

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