metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA512103" 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
26633944	26633944	PRJNA512103_P_NODE_22221_length_201_cov_1.236842_g21809_i0	PRJNA512103	22221	201	1.236842	2.48605242	Actinomycetota bacterium	2900548	Bacteria	Bacteria	41.6	0.0438	NR	MBW3639918.1	2900548	g21809	i0	44.2	0.776119402985075	52	29	77.6	0	159	4	96	147	MBW3639918.1 hypothetical protein [Actinomycetota bacterium]	diamond	156	41.6	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
26824137	26824137	PRJNA512103_P_NODE_27381_length_179_cov_1.346154_g26969_i0	PRJNA512103	27381	179	1.346154	2.40961566	Paenibacillus sp. 1	198340	Bacteria	Bacteria	41.6	0.0378	NR	WP_119801618.1	1675787	g26969	i0	45.5	0.737430167597765	44	21	68.7	1	167	45	118	161	WP_119801618.1 FAD-dependent oxidoreductase [Paenibacillus sp. 1011MAR3C5]	diamond	132	41.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. 1011MAR3C5
26855879	26855879	PRJNA512103_P_NODE_31141_length_168_cov_0.873950_g30729_i0	PRJNA512103	31141	168	0.87395	1.468236	Kocuria varians	1272	Bacteria	Bacteria	102	1.38e-26	NR	CAL8900649.1	1272	g30729	i0	92.2	0.910714285714286	51	4	91.1	0	164	12	41	91	CAL8900649.1 hypothetical protein PGAAJM_12650 [Kocuria varians]	diamond	153	102	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria varians
26965967	26965967	PRJNA512103_P_NODE_19082_length_222_cov_1.057803_g18670_i0	PRJNA512103	19082	222	1.057803	2.34832266	root	1	Root_unresolved	Root_unresolved	150	1.73e-45	NR	WP_279750363.1	1280	g18670	i0	98.6	92.972972972973	73	1	98.6	0	1	219	10	82	WP_279750363.1 50S ribosomal protein L37Ae, partial [Staphylococcus aureus]	diamond	20640	151	0.993377483443709	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28245500	28245500	PRJNA512103_P_NODE_34906_length_156_cov_2.074766_g34494_i0	PRJNA512103	34906	156	2.074766	3.23663496	Clostridium sp. OF13-4	2293040	Bacteria	Bacteria	55.5	2.83e-8	NR	RHV70535.1	2293040	g34494	i0	61.7	0.903846153846154	47	18	90.4	0	14	154	4	50	RHV70535.1 hypothetical protein DXB05_14070, partial [Clostridium sp. OF13-4]	diamond	141	55.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. OF13-4
28908482	28908482	PRJNA512103_P_NODE_34488_length_162_cov_0.920354_g34076_i0	PRJNA512103	34488	162	0.920354	1.49097348	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	94.4	8.42e-21	NR	HKH25519.1	2080302	g34076	i0	95.8	4.44444444444444	48	2	88.9	0	153	10	661	708	HKH25519.1 type I DNA topoisomerase [Acidimicrobiia bacterium]	diamond	720	94.4	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
29193117	29193117	PRJNA512103_P_NODE_10969_length_348_cov_1.280936_g10557_i0	PRJNA512103	10969	348	1.280936	4.45765728	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	66.2	3.77e-10	NR	GIV95657.1	2720503	g10557	i0	45.1	1.39655172413793	82	45	70.7	0	5	250	63	144	GIV95657.1 MAG: hypothetical protein KatS3mg057_0314 [Herpetosiphonaceae bacterium]	diamond	486	66.2	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
29744855	29744855	PRJNA512103_P_NODE_17990_length_231_cov_1.005495_g17578_i0	PRJNA512103	17990	231	1.005495	2.32269345	root	1	Root_unresolved	Root_unresolved	107	1.39e-25	NR	WP_219045841.1	1219	g17578	i0	72.6	5.67532467532468	73	20	94.8	0	229	11	298	370	WP_219045841.1 sulfate adenylyltransferase [Prochlorococcus marinus]	diamond	1311	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
31341141	31341141	PRJNA512103_P_NODE_34076_length_163_cov_0.877193_g33664_i0	PRJNA512103	34076	163	0.877193	1.42982459	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	54.7	7.74e-7	NR	MBS3812162.1	2094029	g33664	i0	61.9	0.773006134969325	42	13	71.8	1	130	14	690	731	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	126	54.7	1	Bacteria		Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32227052	32227052	PRJNA512103_P_NODE_21098_length_208_cov_0.874214_g20686_i0	PRJNA512103	21098	208	0.874214	1.81836512	Negativicutes bacterium	2499140	Bacteria	Bacteria	43.5	0.00633	NR	MDR3563352.1	2499140	g20686	i0	44.6	0.807692307692308	56	28	80.8	2	12	179	78	130	MDR3563352.1 hypothetical protein [Negativicutes bacterium]	diamond	168	43.5	1	Bacteria		Bacillati	Bacillota	Negativicutes				Negativicutes bacterium

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