metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_phylum = "Chloroflexota"

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_species
2045116	2045116	PRJNA788929_P_NODE_19782_length_368_cov_5.966102_g19122_i0	PRJNA788929	19782	368	5.966102	21.95525536	Chloroflexota bacterium	2026724	Bacteria	Bacteria	197	8.56e-56	NR	MDP9316679.1	2026724	g19122	i0	82.5	0.929347826086957	114	20	92.9	0	344	3	394	507	MDP9316679.1 molybdopterin-dependent oxidoreductase [Chloroflexota bacterium]	diamond	342	197	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
17347918	17347918	PRJNA788929_P_NODE_48914_length_205_cov_7.772727_g48253_i0	PRJNA788929	48914	205	7.772727	15.93409035	Anaerolineae bacterium	2052143	Bacteria	Bacteria	68.6	8.48e-13	NR	MDX1520193.1	2052143	g48253	i0	64.7	1.24390243902439	51	17	73.2	1	36	185	3	53	MDX1520193.1 thioredoxin [Anaerolineae bacterium]	diamond	255	68.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
23722258	23722258	PRJNA788929_P_NODE_35699_length_260_cov_1.336898_g35038_i0	PRJNA788929	35699	260	1.336898	3.4759348	Anaerolineae bacterium	2052143	Bacteria	Bacteria	112	3.11e-28	NR	MCX7681007.1	2052143	g35038	i0	66.7	3.76153846153846	84	23	91.2	1	260	24	43	126	MCX7681007.1 hypothetical protein [Anaerolineae bacterium]	diamond	978	112	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
26736767	26736767	PRJNA788929_P_NODE_48321_length_209_cov_5.551471_g47660_i0	PRJNA788929	48321	209	5.551471	11.60257439	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	65.1	4.76e-11	NR	HEX9369688.1	2762507	g47660	i0	59.2	1.36363636363636	49	20	70.3	0	3	149	119	167	HEX9369688.1 protease inhibitor I42 family protein [Roseiflexaceae bacterium]	diamond	285	65.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
26958575	26958575	PRJNA788929_P_NODE_45962_length_224_cov_6.668874_g45301_i0	PRJNA788929	45962	224	6.668874	14.93827776	Chloroflexota bacterium	2026724	Bacteria	Bacteria	80.5	1.46e-15	NR	TME72274.1	2026724	g45301	i0	63	2.87946428571429	54	20	72.3	0	185	24	154	207	TME72274.1 MAG: alpha/beta fold hydrolase [Chloroflexota bacterium]	diamond	645	80.5	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27053777	27053777	PRJNA788929_P_NODE_25142_length_319_cov_14.764228_g24481_i0	PRJNA788929	25142	319	14.764228	47.09788732	Chloroflexota bacterium	2026724	Bacteria	Bacteria	127	1.4e-35	NR	PLS82506.1	2026724	g24481	i0	68.1	1.57993730407524	91	27	85.6	1	39	311	1	89	PLS82506.1 MAG: FmdB family transcriptional regulator [Chloroflexota bacterium]	diamond	504	127	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28001463	28001463	PRJNA788929_P_NODE_21905_length_347_cov_18.540146_g21244_i0	PRJNA788929	21905	347	18.540146	64.33430662	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	43.1	0.04	NR	MCB0075671.1	2614250	g21244	i0	29.6	1.8328530259366	108	65	89	4	2	310	52	153	MCB0075671.1 sugar ABC transporter permease [Caldilineaceae bacterium]	diamond	636	43.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
28948726	28948726	PRJNA788929_P_NODE_31508_length_280_cov_1.280193_g30847_i0	PRJNA788929	31508	280	1.280193	3.5845404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	151	1.59e-41	NR	MEP7081584.1	2026724	g30847	i0	82.8	2.98928571428571	93	16	99.6	0	1	279	40	132	MEP7081584.1 MFS transporter [Chloroflexota bacterium]	diamond	837	151	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29864143	29864143	PRJNA788929_P_NODE_20151_length_364_cov_12.604811_g19491_i0	PRJNA788929	20151	364	12.604811	45.88151204	Anaerolineae bacterium	2052143	Bacteria	Bacteria	154	1.84e-43	NR	MCA9913853.1	2052143	g19491	i0	69.4	3.64285714285714	108	33	89	0	347	24	164	271	MCA9913853.1 hydantoinase/oxoprolinase family protein [Anaerolineae bacterium]	diamond	1326	154	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
30275144	30275144	PRJNA788929_P_NODE_28972_length_294_cov_2.420814_g28311_i0	PRJNA788929	28972	294	2.420814	7.11719316	Anaerolineae bacterium	2052143	Bacteria	Bacteria	55.8	1.06e-7	NR	HKZ82086.1	2052143	g28311	i0	51.9	0.551020408163265	54	25	55.1	1	246	85	4	56	HKZ82086.1 hypothetical protein [Anaerolineae bacterium]	diamond	162	55.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31381089	31381089	PRJNA788929_P_NODE_39456_length_247_cov_11.344828_g38795_i0	PRJNA788929	39456	247	11.344828	28.02172516	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	120	1.15e-29	NR	MCU0490747.1	2562117	g38795	i0	72.2	0.874493927125506	72	20	87.4	0	225	10	76	147	MCU0490747.1 glucose-6-phosphate dehydrogenase [Chloroflexaceae bacterium]	diamond	216	120	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexaceae bacterium
31453541	31453541	PRJNA788929_P_NODE_25116_length_319_cov_21.743902_g24455_i0	PRJNA788929	25116	319	21.743902	69.36304738	Bacillati	1783272	Bacteria	Bacteria	75.9	2.87e-15	NR	HKV59494.1	2740538	g24455	i0	60.8	1.52351097178683	51	20	48	0	282	130	44	94	HKV59494.1 endo-1,4-beta-xylanase [Ktedonobacteraceae bacterium]	diamond	486	76.6	0.990861618798956	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacteraceae 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);;