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

10 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_phylum = "Acidobacteriota"

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
26654731	26654731	PRJNA1016321_P_NODE_18081_length_454_cov_2.283465_g17851_i0	PRJNA1016321	18081	454	2.283465	10.3669311	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	122	2.7799999999999996e-32	NR	HXI43905.1	2212468	g17851	i0	89.2	1.3215859030837	65	7	43	0	23	217	92	156	HXI43905.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	600	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27571983	27571983	PRJNA1016321_P_NODE_28144_length_345_cov_2.371324_g27913_i0	PRJNA1016321	28144	345	2.371324	8.1810678	Pyrinomonas sp.	2080306	Bacteria	Bacteria	159	3.1499999999999996e-47	NR	MER3426641.1	2080306	g27913	i0	95.5	0.773913043478261	89	4	77.4	0	269	3	39	127	MER3426641.1 hypothetical protein [Pyrinomonas sp.]	diamond	267	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonas	Pyrinomonas sp.
27824756	27824756	PRJNA1016321_P_NODE_14884_length_508_cov_3.526437_g14655_i0	PRJNA1016321	14884	508	3.526437	17.91429996	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	142	2.41e-38	NR	MEO5923374.1	2212468	g14655	i0	83.9	1.00984251968504	87	14	51.4	0	281	21	8	94	MEO5923374.1 HDOD domain-containing protein [Bryobacteraceae bacterium]	diamond	513	142	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28456219	28456219	PRJNA1016321_P_NODE_47006_length_253_cov_1.711111_g46775_i0	PRJNA1016321	47006	253	1.711111	4.32911083	Terriglobales bacterium	2282142	Bacteria	Bacteria	119	1.21e-29	NR	HUI51008.1	2282142	g46775	i0	73.8	0.99604743083004	84	22	99.6	0	2	253	1	84	HUI51008.1 PP2C family protein-serine/threonine phosphatase [Terriglobales bacterium]	diamond	252	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
29048347	29048347	PRJNA1016321_P_NODE_49048_length_249_cov_4.005682_g48817_i0	PRJNA1016321	49048	249	4.005682	9.97414818	Bryobacterales	332160	Bacteria	Bacteria	42.7	0.0347	NR	HMC62976.1	2068625	g48817	i0	30.8	1.86746987951807	78	50	94	2	245	12	125	198	HMC62976.1 F0F1 ATP synthase subunit A [Candidatus Solibacter sp.]	diamond	465	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
30729934	30729934	PRJNA1016321_P_NODE_2414_length_1266_cov_3.780386_g2290_i0	PRJNA1016321	2414	1266	3.780386	47.85968676	Pyrinomonas methylaliphatogenes	454194	Bacteria	Bacteria	359	3.409999999999999e-107	NR	WP_041975381.1	454194	g2290	i0	79.4	0.528436018957346	223	36	50.7	2	1233	592	2334	2555	WP_041975381.1 PKD domain-containing protein [Pyrinomonas methylaliphatogenes]	diamond	669	359	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonas	Pyrinomonas methylaliphatogenes
31615081	31615081	PRJNA1016321_P_NODE_43776_length_265_cov_1.588542_g43545_i0	PRJNA1016321	43776	265	1.588542	4.2096363	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	101	2.1e-24	NR	HXI27818.1	2910147	g43545	i0	59.7	3.57735849056604	77	31	87.2	0	30	260	16	92	HXI27818.1 Crp/Fnr family transcriptional regulator [Vicinamibacterales bacterium]	diamond	948	101	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31804794	31804794	PRJNA1016321_P_NODE_56857_length_236_cov_2.834356_g56626_i0	PRJNA1016321	56857	236	2.834356	6.68908016	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	115	8.68e-28	NR	MEO5926996.1	2212468	g56626	i0	78.9	0.902542372881356	71	15	90.3	0	214	2	342	412	MEO5926996.1 carboxypeptidase-like regulatory domain-containing protein [Bryobacteraceae bacterium]	diamond	213	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32469533	32469533	PRJNA1016321_P_NODE_46739_length_254_cov_1.657459_g46508_i0	PRJNA1016321	46739	254	1.657459	4.20994586	Bryobacterales bacterium	2026791	Bacteria	Bacteria	52	2.22e-5	NR	MBL8239945.1	2026791	g46508	i0	63.4	0.484251968503937	41	15	48.4	0	14	136	35	75	MBL8239945.1 methyl-accepting chemotaxis protein [Bryobacterales bacterium]	diamond	123	52	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
32753188	32753188	PRJNA1016321_P_NODE_55720_length_241_cov_2.297619_g55489_i0	PRJNA1016321	55720	241	2.297619	5.53726179	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	42.4	0.0444	NR	HVP46685.1	2212468	g55489	i0	40.7	0.734439834024896	59	34	72.2	1	18	191	207	265	HVP46685.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	177	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;