metadata: contig_metadata: 10 rows where bioproject = "PRJNA760976", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA760976", tax_kingdom = "Bacillati" 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_genus	tax_species
742452	742452	PRJNA760976_P_NODE_56961_length_241_cov_0.857143_g56640_i0	PRJNA760976	56961	241	0.857143	2.06571463	Bacillati	1783272	Bacteria	Bacteria	136	2.02e-36	NR	MEX2247199.1	2026734	g56640	i0	76.3	8.96265560165975	80	19	99.6	0	2	241	229	308	MEX2247199.1 tryptophan synthase subunit beta [Dehalococcoidia bacterium]	diamond	2160	137	0.992700729927007	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27978768	27978768	PRJNA760976_P_NODE_27905_length_310_cov_1.860759_g27584_i0	PRJNA760976	27905	310	1.860759	5.7683529	PVC group	1783257	Bacteria	Bacteria	80.9	3.44e-15	NR	MCO5185444.1	2052143	g27584	i0	46.9	4.78064516129032	96	50	91.9	1	299	15	5296	5391	MCO5185444.1 right-handed parallel beta-helix repeat-containing protein [Anaerolineae bacterium]	diamond	1482	80.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28568948	28568948	PRJNA760976_P_NODE_38107_length_277_cov_1.102941_g37786_i0	PRJNA760976	38107	277	1.102941	3.05514657	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	60.8	2.34e-8	NR	HLQ28677.1	2740538	g37786	i0	45.2	1.67870036101083	73	35	78	2	25	240	198	266	HLQ28677.1 NAD(P)/FAD-dependent oxidoreductase [Ktedonobacteraceae bacterium]	diamond	465	60.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
28789925	28789925	PRJNA760976_P_NODE_33747_length_290_cov_1.032258_g33426_i0	PRJNA760976	33747	290	1.032258	2.9935482	Anaerolineales bacterium	2073117	Bacteria	Bacteria	44.3	0.0179	NR	NUM46897.1	2073117	g33426	i0	34.2	0.817241379310345	79	42	81.7	3	47	283	170	238	NUM46897.1 PD40 domain-containing protein [Anaerolineales bacterium]	diamond	237	44.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29683470	29683470	PRJNA760976_P_NODE_17150_length_368_cov_1.305085_g16829_i0	PRJNA760976	17150	368	1.305085	4.8027128	Chloroflexota	200795	Bacteria	Bacteria	122	1.53e-29	NR	MCI0554736.1	2052143	g16829	i0	59.5	4.91576086956522	121	45	98.6	3	4	366	317	433	MCI0554736.1 hypothetical protein [Anaerolineae bacterium]	diamond	1809	122	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29737022	29737022	PRJNA760976_P_NODE_12150_length_417_cov_2.183140_g11830_i0	PRJNA760976	12150	417	2.18314	9.1036938	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	67	7.13e-10	NR	HEY5006031.1	2740538	g11830	i0	34.2	5.06474820143885	146	69	97.8	5	409	2	131	259	HEY5006031.1 vanadium-dependent haloperoxidase [Ktedonobacteraceae bacterium]	diamond	2112	67	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
29737029	29737029	PRJNA760976_P_NODE_50450_length_247_cov_0.885057_g50129_i0	PRJNA760976	50450	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	54.7	1.5e-6	NR	HLH71787.1	2026724	g50129	i0	41.7	1.74898785425101	72	40	87.4	1	217	2	9	78	HLH71787.1 aquaporin [Chloroflexota bacterium]	diamond	432	54.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30242815	30242815	PRJNA760976_P_NODE_2912_length_758_cov_1.454015_g2618_i0	PRJNA760976	2912	758	1.454015	11.0214337	Chloroflexus sp. MS-CIW-1	3055768	Bacteria	Bacteria	181	1.92e-50	NR	MDN5271124.1	3055768	g2618	i0	51.8	1.52770448548813	193	92	76.4	1	754	176	76	267	MDN5271124.1 hypothetical protein [Chloroflexus sp. MS-CIW-1]	diamond	1158	181	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus sp. MS-CIW-1
31507072	31507072	PRJNA760976_P_NODE_38316_length_276_cov_1.477833_g37995_i0	PRJNA760976	38316	276	1.477833	4.07881908	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	64.7	1.05e-9	NR	MEZ4866391.1	2614250	g37995	i0	39.6	1.97826086956522	91	54	98.9	1	3	275	135	224	MEZ4866391.1 hypothetical protein [Caldilineaceae bacterium]	diamond	546	64.7	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
31822987	31822987	PRJNA760976_P_NODE_27697_length_311_cov_1.558824_g27376_i0	PRJNA760976	27697	311	1.558824	4.84794264	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.8	0.00622	NR	MEZ4592717.1	2026724	g27376	i0	39.3	0.810289389067524	84	34	81	3	253	2	23	89	MEZ4592717.1 alpha/beta hydrolase [Chloroflexota bacterium]	diamond	252	45.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;