metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA951388" 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
27474541	27474541	PRJNA951388_S_NODE_10103_length_260_cov_1.390374_g9976_i0	PRJNA951388	10103	260	1.390374	3.6149724	root	1	Root_unresolved	Root_unresolved	81.6	5.62e-16	NR	ACV20892.1	1396	g9976	i0	74.2	3.04615384615385	66	17	76.2	0	19	216	107	172	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	792	81.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27664190	27664190	PRJNA951388_S_NODE_4144_length_403_cov_3.696970_g4017_i0	PRJNA951388	4144	403	3.69697	14.8987891	Bacteria	2	Bacteria	Bacteria	58.9	4.18e-7	NR	WP_021800335.1	36845	g4017	i0	34.5	4.68982630272953	113	73	84.1	1	3	341	277	388	WP_021800335.1 threonine ammonia-lyase [Clostridium intestinale]	diamond	1890	58.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
27822071	27822071	PRJNA951388_S_NODE_11284_length_243_cov_2.264706_g11157_i0	PRJNA951388	11284	243	2.264706	5.50323558	root	1	Root_unresolved	Root_unresolved	61.2	1.06e-8	NR	ACV20892.1	1396	g11157	i0	54.4	4.76543209876543	79	36	97.5	0	1	237	153	231	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	1158	61.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
28573050	28573050	PRJNA951388_S_NODE_5487_length_360_cov_5.540070_g5360_i0	PRJNA951388	5487	360	5.54007	19.944252	Salinibacillus aidingensis	237684	Bacteria	Bacteria	44.3	0.0379	NR	WP_343844082.1	237684	g5360	i0	28.9	0.75	90	55	71.7	3	3	260	394	478	WP_343844082.1 hypothetical protein [Salinibacillus aidingensis]	diamond	270	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salinibacillus	Salinibacillus aidingensis
30405145	30405145	PRJNA951388_S_NODE_1933_length_519_cov_7.130045_g1810_i0	PRJNA951388	1933	519	7.130045	37.00493355	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	78.2	1.37e-13	NR	MBO5113168.1	1898203	g1810	i0	46.7	3.65895953757225	92	46	51.4	1	518	252	222	313	MBO5113168.1 DnaJ domain-containing protein [Lachnospiraceae bacterium]	diamond	1899	78.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30910416	30910416	PRJNA951388_S_NODE_2434_length_482_cov_8.092910_g2308_i0	PRJNA951388	2434	482	8.09291	39.0078262	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	88.2	2.28e-19	NR	MBQ5561215.1	1898203	g2308	i0	40.7	1.1701244813278	86	51	53.5	0	322	65	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	564	88.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31352843	31352843	PRJNA951388_S_NODE_9456_length_271_cov_1.555556_g9329_i0	PRJNA951388	9456	271	1.555556	4.21555676	Acutalibacteraceae bacterium	3077420	Bacteria	Bacteria	189	4.5399999999999995e-57	NR	MEE1353258.1	3077420	g9329	i0	100	0.996309963099631	90	0	99.6	0	271	2	57	146	MEE1353258.1 nickel insertion protein [Acutalibacteraceae bacterium]	diamond	270	189	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae		Acutalibacteraceae bacterium
31890424	31890424	PRJNA951388_S_NODE_2897_length_456_cov_2.355091_g2770_i0	PRJNA951388	2897	456	2.355091	10.73921496	Allobacillus	1400133	Bacteria	Bacteria	46.6	0.0148	NR	WP_186279493.1	1400133	g2770	i0	37	0.480263157894737	73	42	45.4	1	182	388	4	76	WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus]	diamond	219	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus
32245420	32245420	PRJNA951388_S_NODE_6118_length_343_cov_2.777778_g5991_i0	PRJNA951388	6118	343	2.777778	9.52777854	root	1	Root_unresolved	Root_unresolved	58.5	3.01e-7	NR	WP_013859697.1	1398	g5991	i0	43.3	3.6997084548105	97	27	83.1	2	341	57	35	105	WP_013859697.1 molecular chaperone DnaJ [Heyndrickxia coagulans]	diamond	1269	58.9	0.99320882852292	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia coagulans

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