metadata: contig_metadata: 8 rows where bioproject = "PRJNA1034994", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA1034994", 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
1442961	1442961	PRJNA1034994_P_NODE_1342_length_442_cov_0.967480_g1258_i0	PRJNA1034994	1342	442	0.96748	4.2762616	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	617	3.36e-172	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g1258	i0	91.874	434.273755656109	443	34	100	2	1	442	1858602	1858161	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	191949	617	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
11646838	11646838	PRJNA1034994_P_NODE_7330_length_249_cov_0.875000_g7246_i0	PRJNA1034994	7330	249	0.875	2.17875	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	346	9.229999999999999e-91	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g7246	i0	92.213	148.116465863454	244	19	98	0	6	249	668286	668043	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	36881	346	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
18020073	18020073	PRJNA1034994_P_NODE_1175_length_472_cov_2.102757_g1091_i0	PRJNA1034994	1175	472	2.102757	9.92501304	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	540	8.04e-149	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g1091	i0	87.421	139.173728813559	477	51	99	8	1	471	565333	564860	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	65690	540	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
28961773	28961773	PRJNA1034994_P_NODE_7848_length_248_cov_0.880000_g7764_i0	PRJNA1034994	7848	248	0.88	2.1824	Chloroflexota bacterium	2026724	Bacteria	Bacteria	78.2	2.15e-16	NR	MCP4540129.1	2026724	g7764	i0	49.3	0.907258064516129	75	38	90.7	0	229	5	44	118	MCP4540129.1 VRR-NUC domain-containing protein [Chloroflexota bacterium]	diamond	225	78.2	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29561286	29561286	PRJNA1034994_P_NODE_6370_length_253_cov_2.655556_g6286_i0	PRJNA1034994	6370	253	2.655556	6.71855668	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	139	5.22e-38	NR	HEX6287660.1	2720503	g6286	i0	83.3	0.99604743083004	84	14	99.6	0	253	2	235	318	HEX6287660.1 aldo/keto reductase [Herpetosiphonaceae bacterium]	diamond	252	139	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphonaceae bacterium
30320071	30320071	PRJNA1034994_P_NODE_8292_length_246_cov_1.716763_g8208_i0	PRJNA1034994	8292	246	1.716763	4.22323698	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.0154	NR	MDP8909370.1	2026724	g8208	i0	41.7	0.878048780487805	72	33	76.8	2	221	33	1703	1774	MDP8909370.1 amino acid adenylation domain-containing protein [Chloroflexota bacterium]	diamond	216	43.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31670595	31670595	PRJNA1034994_P_NODE_5417_length_264_cov_1.471204_g5333_i0	PRJNA1034994	5417	264	1.471204	3.88397856	Chloroflexota	200795	Bacteria	Bacteria	45.4	0.00534	NR	MEP6895431.1	2026724	g5333	i0	48	3.5	50	23	53.4	1	33	173	515	564	MEP6895431.1 protein kinase [Chloroflexota bacterium]	diamond	924	45.8	0.991266375545852	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32248426	32248426	PRJNA1034994_P_NODE_6338_length_254_cov_1.419890_g6254_i0	PRJNA1034994	6338	254	1.41989	3.6065206	Anaerolineales bacterium	2073117	Bacteria	Bacteria	50.1	1.09e-4	NR	MDW8226528.1	2073117	g6254	i0	67.7	0.366141732283465	31	10	36.6	0	1	93	407	437	MDW8226528.1 glycosyltransferase family 39 protein [Anaerolineales bacterium]	diamond	93	50.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales 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);;