metadata: contig_metadata: 10 rows where bioproject = "PRJNA1122875" and tax

10 rows where bioproject = "PRJNA1122875" 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
18129486	18129486	PRJNA1122875_P_NODE_40875_length_259_cov_1.241935_g40651_i0	PRJNA1122875	40875	259	1.241935	3.21661165	Fimbriimonas	1005038	Bacteria	Bacteria	122	1.84e-30	NR	MDR3692382.1	1936159	g40651	i0	73.3	5.58301158301158	75	20	86.9	0	3	227	402	476	MDR3692382.1 MmgE/PrpD family protein [Fimbriimonas sp.]	diamond	1446	123	0.991869918699187	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
22705703	22705703	PRJNA1122875_P_NODE_40018_length_262_cov_1.280423_g39794_i0	PRJNA1122875	40018	262	1.280423	3.35470826	Fimbriimonadia bacterium	2575566	Bacteria	Bacteria	95.1	4.850000000000001e-21	NR	MEP0767515.1	2575566	g39794	i0	73.8	2.75954198473282	61	16	69.8	0	189	7	2	62	MEP0767515.1 low-specificity L-threonine aldolase [Fimbriimonadia bacterium]	diamond	723	95.1	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia				Fimbriimonadia bacterium
26595089	26595089	PRJNA1122875_P_NODE_42781_length_251_cov_2.162921_g42557_i0	PRJNA1122875	42781	251	2.162921	5.42893171	Armatimonadota bacterium	2033014	Bacteria	Bacteria	42.7	0.025	NR	MBM3500060.1	2033014	g42557	i0	43.5	0.549800796812749	46	25	55	1	63	200	14	58	MBM3500060.1 MogA/MoaB family molybdenum cofactor biosynthesis protein [Armatimonadota bacterium]	diamond	138	42.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29501584	29501584	PRJNA1122875_P_NODE_43050_length_251_cov_1.134831_g42826_i0	PRJNA1122875	43050	251	1.134831	2.84842581	Chthonomonadales bacterium	2282151	Bacteria	Bacteria	122	1.4899999999999998e-30	NR	HXG23220.1	2282151	g42826	i0	68.3	5.8804780876494	82	26	98	0	4	249	132	213	HXG23220.1 hypothetical protein [Chthonomonadales bacterium]	diamond	1476	122	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales			Chthonomonadales bacterium
29754124	29754124	PRJNA1122875_P_NODE_3711_length_786_cov_1.887798_g3520_i0	PRJNA1122875	3711	786	1.887798	14.83809228	Armatimonadota bacterium	2033014	Bacteria	Bacteria	176	7.17e-51	NR	GDX40226.1	2033014	g3520	i0	45	0.83969465648855	220	103	82.4	7	779	132	30	235	GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium]	diamond	660	176	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30955052	30955052	PRJNA1122875_P_NODE_43194_length_251_cov_0.865169_g42970_i0	PRJNA1122875	43194	251	0.865169	2.17157419	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	68.2	8.79e-13	NR	MBX3097920.1	2682144	g42970	i0	75	0.525896414342629	44	9	50.2	1	3	128	43	86	MBX3097920.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	132	68.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
31460848	31460848	PRJNA1122875_P_NODE_3156_length_834_cov_2.935611_g2975_i0	PRJNA1122875	3156	834	2.935611	24.48299574	Armatimonadota bacterium	2033014	Bacteria	Bacteria	167	6.7599999999999985e-47	NR	GDX40226.1	2033014	g2975	i0	45.7	0.70863309352518	197	101	69.4	5	676	98	40	234	GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium]	diamond	591	167	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31776898	31776898	PRJNA1122875_P_NODE_7157_length_602_cov_1.156900_g6940_i0	PRJNA1122875	7157	602	1.1569	6.964538	Armatimonadota bacterium	2033014	Bacteria	Bacteria	60.5	2.17e-7	NR	MCS7192581.1	2033014	g6940	i0	32.5	0.568106312292359	114	74	56.8	1	224	565	61	171	MCS7192581.1 YbjN domain-containing protein [Armatimonadota bacterium]	diamond	342	60.5	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32473189	32473189	PRJNA1122875_P_NODE_47839_length_247_cov_0.885057_g47615_i0	PRJNA1122875	47839	247	0.885057	2.18609079	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	85.1	1.72e-17	NR	MCX7801050.1	2682145	g47615	i0	61.3	1.50607287449393	62	24	75.3	0	3	188	54	115	MCX7801050.1 glycoside hydrolase family 5 protein [Fimbriimonadales bacterium]	diamond	372	85.1	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
32851248	32851248	PRJNA1122875_P_NODE_980_length_1216_cov_3.730534_g886_i1	PRJNA1122875	980	1216	3.730534	45.36329344	Armatimonadota bacterium	2033014	Bacteria	Bacteria	341	4.869999999999998e-106	NR	HET6386082.1	2033014	g886	i1	48.2	1.78371710526316	361	177	87.3	3	1	1062	86	443	HET6386082.1 pectinesterase family protein [Armatimonadota bacterium]	diamond	2169	341	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);;