metadata: contig_metadata: 8 rows where bioproject = "PRJNA390533", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA390533", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

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
6787232	6787232	PRJNA390533_P_NODE_1386_length_1386_cov_3.080178_g1152_i0	PRJNA390533	1386	1386	3.080178	42.69126708	Fimbriimonas sp.	1936159	Bacteria	Bacteria	788	3.1e-283	NR	MEZ0325521.1	1936159	g1152	i0	82.3	0.989177489177489	457	80	98.9	1	1383	13	29	484	MEZ0325521.1 L-fucose isomerase [Fimbriimonas sp.]	diamond	1371	788	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
6787536	6787536	PRJNA390533_P_NODE_40526_length_178_cov_1.791367_g39499_i0	PRJNA390533	40526	178	1.791367	3.18863326	Capsulimonas corticalis	2219043	Bacteria	Bacteria	152	1.4399999999999999e-32	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g39499	i0	84.663	2.74719101123596	163	14	92	8	1	163	594342	594191	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	489	152	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
20811308	20811308	PRJNA390533_P_NODE_25897_length_309_cov_22.362963_g24870_i0	PRJNA390533	25897	309	22.362963	69.10155567	Armatimonadota bacterium	2033014	Bacteria	Bacteria	244	4.44e-60	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g24870	i0	82.877	254.113268608414	292	31	92	15	24	308	2410982	2411261	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	78521	244	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27580732	27580732	PRJNA390533_P_NODE_50584_length_150_cov_1.531532_g49557_i0	PRJNA390533	50584	150	1.531532	2.297298	Armatimonadota bacterium	2033014	Bacteria	Bacteria	53.5	1.48e-6	NR	MBI3998936.1	2033014	g49557	i0	61.5	2.42	39	15	78	0	136	20	151	189	MBI3998936.1 quinate 5-dehydrogenase [Armatimonadota bacterium]	diamond	363	53.5	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27944985	27944985	PRJNA390533_P_NODE_25105_length_316_cov_1.173285_g24078_i0	PRJNA390533	25105	316	1.173285	3.7075806	FCB group	1783270	Bacteria	Bacteria	48.5	7.7e-4	NR	WP_075165511.1	454171	g24078	i0	96	2.39240506329114	25	1	23.7	0	315	241	302	326	WP_075165511.1 glycosyltransferase family 4 protein [Chthonomonas calidirosea]	diamond	756	48.9	0.991820040899796	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
28654320	28654320	PRJNA390533_P_NODE_1007_length_1544_cov_8.732226_g828_i0	PRJNA390533	1007	1544	8.732226	134.82556944	Armatimonadota bacterium	2033014	Bacteria	Bacteria	475	4.3e-164	NR	MES2463217.1	2033014	g828	i0	94.7	0.516839378238342	266	14	51.7	0	998	201	1	266	MES2463217.1 ferritin-like domain-containing protein [Armatimonadota bacterium]	diamond	798	475	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31655333	31655333	PRJNA390533_P_NODE_34097_length_215_cov_1.039773_g33070_i0	PRJNA390533	34097	215	1.039773	2.23551195	Armatimonadota bacterium	2033014	Bacteria	Bacteria	88.2	1.41e-18	NR	MFM7322355.1	2033014	g33070	i0	59.2	1.98139534883721	71	27	99.1	2	214	2	278	346	MFM7322355.1 galactonate dehydratase [Armatimonadota bacterium]	diamond	426	88.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32667348	32667348	PRJNA390533_P_NODE_28160_length_275_cov_1.881356_g27133_i0	PRJNA390533	28160	275	1.881356	5.173729	Armatimonadota bacterium	2033014	Bacteria	Bacteria	107	9.99e-26	NR	MES1227441.1	2033014	g27133	i0	60	0.927272727272727	85	34	92.7	0	19	273	71	155	MES1227441.1 diacylglycerol kinase family protein [Armatimonadota bacterium]	diamond	255	107	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota 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);;