metadata: contig_metadata: 6 rows where bioproject = "PRJNA812715", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA812715", 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_species
27117328	27117328	PRJNA812715_P_NODE_65342_length_320_cov_1.246964_g63542_i0	PRJNA812715	65342	320	1.246964	3.9902848	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	78.2	1.55e-14	NR	CAA9262488.1	157466	g63542	i0	45.1	1.93125	102	35	95.6	2	2	307	95	175	CAA9262488.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase [uncultured Armatimonadetes bacterium]	diamond	618	78.2	1	Bacteria	Bacillati	Armatimonadota	uncultured Armatimonadetes bacterium
29517347	29517347	PRJNA812715_P_NODE_79550_length_285_cov_1.452830_g77750_i0	PRJNA812715	79550	285	1.45283	4.1405655	Armatimonadota bacterium	2033014	Bacteria	Bacteria	84	1.56e-16	NR	MBI5706969.1	2033014	g77750	i0	48.9	0.926315789473684	88	40	92.6	1	266	3	219	301	MBI5706969.1 hypothetical protein [Armatimonadota bacterium]	diamond	264	84	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
29643372	29643372	PRJNA812715_P_NODE_108950_length_247_cov_1.770115_g107149_i0	PRJNA812715	108950	247	1.770115	4.37218405	Armatimonadota bacterium	2033014	Bacteria	Bacteria	142	5.09e-39	NR	MES2461992.1	2033014	g107149	i0	84.1	0.995951417004049	82	13	99.6	0	247	2	45	126	MES2461992.1 hypothetical protein [Armatimonadota bacterium]	diamond	246	142	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
29801532	29801532	PRJNA812715_P_NODE_97391_length_257_cov_1.673913_g95590_i0	PRJNA812715	97391	257	1.673913	4.30195641	Armatimonadota bacterium	2033014	Bacteria	Bacteria	157	2.6799999999999993e-42	NR	HET6455902.1	2033014	g95590	i0	81.2	4.93774319066148	85	16	99.2	0	255	1	434	518	HET6455902.1 bifunctional YncE family protein/alkaline phosphatase family protein [Armatimonadota bacterium]	diamond	1269	157	1	Bacteria	Bacillati	Armatimonadota	Armatimonadota bacterium
30379412	30379412	PRJNA812715_P_NODE_123272_length_233_cov_2.493750_g121471_i0	PRJNA812715	123272	233	2.49375	5.8104375	Bacteria	2	Bacteria	Bacteria	107	5.6899999999999995e-25	NR	OJU63383.1	1895717	g121471	i0	68	3.92703862660944	75	24	96.6	0	3	227	1	75	OJU63383.1 MAG: hypothetical protein BGO01_04375 [Armatimonadetes bacterium 55-13]	diamond	915	107	1	Bacteria	Bacillati	Armatimonadota	Armatimonadetes bacterium 55-13
31421910	31421910	PRJNA812715_P_NODE_119256_length_242_cov_0.911243_g117455_i0	PRJNA812715	119256	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	97.4	2.38e-22	NR	MDQ2687175.1	2033014	g117455	i0	90.2	3	51	5	63.2	0	89	241	8	58	MDQ2687175.1 aldo/keto reductase [Armatimonadota bacterium]	diamond	726	97.4	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);;