metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
9693571	9693571	PRJNA784298_P_NODE_10808_length_381_cov_1.714286_g10607_i0	PRJNA784298	10808	381	1.714286	6.53142966	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	133	1.11e-34	NR	HEX4168328.1	2212468	g10607	i0	67.7	2.16535433070866	93	29	73.2	1	279	1	6	97	HEX4168328.1 ATP-binding protein [Bryobacteraceae bacterium]	diamond	825	133	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
12245036	12245036	PRJNA784298_P_NODE_4970_length_568_cov_11.367677_g4771_i0	PRJNA784298	4970	568	11.367677	64.56840536	Thermotomaculum hydrothermale	981385	Bacteria	Bacteria	102	8.41e-25	NR	WP_269089408.1	981385	g4771	i0	53.8	3.30633802816901	93	43	49.1	0	482	204	2	94	WP_269089408.1 HU family DNA-binding protein [Thermotomaculum hydrothermale]	diamond	1878	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Thermotomaculales	Thermotomaculaceae	Thermotomaculum	Thermotomaculum hydrothermale
26619719	26619719	PRJNA784298_P_NODE_6601_length_493_cov_3.623810_g6401_i0	PRJNA784298	6601	493	3.62381	17.8653833	Bacteria	2	Bacteria	Bacteria	94	3.54e-19	NR	MEA2490291.1	1978231	g6401	i0	42.7	1.3448275862069	110	59	65.7	2	417	94	111	218	MEA2490291.1 hypothetical protein [Acidobacteriota bacterium]	diamond	663	94.7	0.992608236536431	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27874855	27874855	PRJNA784298_P_NODE_27505_length_233_cov_2.887500_g27304_i0	PRJNA784298	27505	233	2.8875	6.727875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	100	6.06e-25	NR	MBI3131636.1	1978231	g27304	i0	61.4	0.901287553648069	70	27	90.1	0	20	229	6	75	MBI3131636.1 SUF system NifU family Fe-S cluster assembly protein [Acidobacteriota bacterium]	diamond	210	100	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30031399	30031399	PRJNA784298_P_NODE_5671_length_532_cov_1.856209_g5472_i0	PRJNA784298	5671	532	1.856209	9.87503188	root	1	Root_unresolved	Root_unresolved	62.4	1.03e-7	NR	MBZ5537623.1	2081523	g5472	i0	32.2	2.53759398496241	146	89	76.7	4	33	440	909	1054	MBZ5537623.1 IPT/TIG domain-containing protein [Terriglobia bacterium]	diamond	1350	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
30622210	30622210	PRJNA784298_P_NODE_20273_length_274_cov_1.532338_g20072_i0	PRJNA784298	20273	274	1.532338	4.19860612	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	77	4.07e-14	NR	HJZ96235.1	2068625	g20072	i0	41.1	1.97080291970803	90	51	96.4	2	266	3	23	112	HJZ96235.1 hypothetical protein [Candidatus Solibacter sp.]	diamond	540	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
31001591	31001591	PRJNA784298_P_NODE_26134_length_243_cov_0.905882_g25933_i0	PRJNA784298	26134	243	0.905882	2.20129326	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	150	8.279999999999999e-43	NR	HEY3044869.1	2910147	g25933	i0	86.3	5.92592592592593	80	11	98.8	0	3	242	10	89	HEY3044869.1 Gfo/Idh/MocA family oxidoreductase [Vicinamibacterales bacterium]	diamond	1440	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31665402	31665402	PRJNA784298_P_NODE_18657_length_286_cov_2.408451_g18456_i0	PRJNA784298	18657	286	2.408451	6.88816986	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	41.2	0.0354	NR	HMJ88716.1	3069120	g18456	i0	38.6	0.870629370629371	83	35	76.6	2	2	220	1	77	HMJ88716.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	249	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.

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