metadata: contig_metadata: 11 rows where bioproject = "PRJEB11523", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJEB11523", 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_species
15315990	15315990	PRJEB11523_P_NODE_633_length_756_cov_6.149929_g570_i0	PRJEB11523	633	756	6.149929	46.49346324	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	276	5.05e-85	NR	HYV33658.1	3047546	g570	i0	76.8	1.43650793650794	181	41	71.4	1	569	30	1	181	HYV33658.1 NAD-dependent DNA ligase LigA [Candidatus Limnocylindria bacterium]	diamond	1086	276	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
26684428	26684428	PRJEB11523_P_NODE_8681_length_161_cov_0.910714_g8603_i0	PRJEB11523	8681	161	0.910714	1.46624954	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	48.1	1.51e-4	NR	HEX6293425.1	2720503	g8603	i0	44.9	1.82608695652174	49	27	91.3	0	11	157	338	386	HEX6293425.1 hypothetical protein [Herpetosiphonaceae bacterium]	diamond	294	48.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphonaceae bacterium
27406121	27406121	PRJEB11523_P_NODE_5863_length_191_cov_1.704225_g5785_i0	PRJEB11523	5863	191	1.704225	3.25506975	Bacillati	1783272	Bacteria	Bacteria	52.4	9.91e-7	NR	OGO11449.1	1797639	g5785	i0	50	1.46073298429319	48	24	75.4	0	10	153	27	74	OGO11449.1 MAG: hypothetical protein A2Y53_00080 [Chloroflexi bacterium RBG_16_47_49]	diamond	279	52.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexi bacterium RBG_16_47_49
27696494	27696494	PRJEB11523_P_NODE_6564_length_180_cov_1.076336_g6486_i0	PRJEB11523	6564	180	1.076336	1.9374048	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.1	0.00242	NR	MBU6290100.1	2026724	g6486	i0	49	1.68333333333333	49	23	81.7	1	2	148	102	148	MBU6290100.1 hypothetical protein [Chloroflexota bacterium]	diamond	303	45.1	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29742131	29742131	PRJEB11523_P_NODE_1590_length_450_cov_9.695761_g1512_i0	PRJEB11523	1590	450	9.695761	43.6309245	Candidatus Amarobacillus	3140603	Bacteria	Bacteria	50.4	3.83e-5	NR	HQW52154.1	3022862	g1512	i0	40.3	0.953333333333333	62	35	41.3	1	373	188	17	76	HQW52154.1 hypothetical protein [Tepidiformaceae bacterium]	diamond	429	50.4	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiformaceae bacterium
30538245	30538245	PRJEB11523_P_NODE_4753_length_216_cov_1.832335_g4675_i0	PRJEB11523	4753	216	1.832335	3.9578436	Anaerolineales bacterium	2073117	Bacteria	Bacteria	134	7.89e-35	NR	MBL8091337.1	2073117	g4675	i0	100	1.80555555555556	65	0	90.3	0	210	16	1	65	MBL8091337.1 ribonuclease J [Anaerolineales bacterium]	diamond	390	134	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
30822630	30822630	PRJEB11523_P_NODE_3334_length_271_cov_1.837838_g3256_i0	PRJEB11523	3334	271	1.837838	4.98054098	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0131	NR	GIL09294.1	2026724	g3256	i0	51.5	0.365313653136531	33	16	36.5	0	19	117	69	101	GIL09294.1 MAG: hypothetical protein BroJett033_8050 [Chloroflexota bacterium]	diamond	99	42.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31581496	31581496	PRJEB11523_P_NODE_1776_length_417_cov_3.709239_g1698_i0	PRJEB11523	1776	417	3.709239	15.46752663	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	71.6	6.77e-13	NR	MDD4924285.1	2026733	g1698	i0	43.2	0.58273381294964	81	46	58.3	0	325	83	49	129	MDD4924285.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	243	71.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
31739305	31739305	PRJEB11523_P_NODE_3457_length_264_cov_5.730233_g3379_i0	PRJEB11523	3457	264	5.730233	15.12781512	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42	0.0171	NR	HBG75139.1	2052143	g3379	i0	55.2	0.329545454545455	29	13	33	0	123	209	7	35	HBG75139.1 hypothetical protein [Anaerolineae bacterium]	diamond	87	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
32745051	32745051	PRJEB11523_P_NODE_3720_length_251_cov_4.826733_g3642_i0	PRJEB11523	3720	251	4.826733	12.11509983	PVC group	1783257	Bacteria	Bacteria	63.2	9.04e-10	NR	MBC8507439.1	2026724	g3642	i0	50	3.44223107569721	56	28	66.9	0	71	238	100	155	MBC8507439.1 DNA adenine methylase [Chloroflexota bacterium]	diamond	864	63.2	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32813968	32813968	PRJEB11523_P_NODE_3840_length_246_cov_3.365482_g3762_i0	PRJEB11523	3840	246	3.365482	8.27908572	Anaerolineae bacterium	2052143	Bacteria	Bacteria	101	5.359999999999999e-24	NR	MCK6579927.1	2052143	g3762	i0	53.1	1.95121951219512	81	38	98.8	0	4	246	20	100	MCK6579927.1 DnaD domain protein [Anaerolineae bacterium]	diamond	480	101	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae 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);;