metadata: contig_metadata: 9 rows where bioproject = "PRJEB7366", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJEB7366", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
12888793	12888793	PRJEB7366_P_NODE_1571_length_788_cov_2.605578_g1258_i0	PRJEB7366	1571	788	2.605578	20.53195464	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	54.7	0.022	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g1258	i0	100	0.0368020304568528	29	0	4	0	662	690	1765189	1765161	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
26876187	26876187	PRJEB7366_P_NODE_1141_length_918_cov_4.064553_g878_i0	PRJEB7366	1141	918	4.064553	37.31259654	Chloroflexota bacterium	2026724	Bacteria	Bacteria	111	1.26e-23	NR	MBV9787437.1	2026724	g878	i0	35.8	0.69281045751634	212	113	68.3	6	6	632	158	349	MBV9787437.1 thioester reductase domain-containing protein [Chloroflexota bacterium]	diamond	636	111	1	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
28771019	28771019	PRJEB7366_P_NODE_15087_length_202_cov_1.089820_g14653_i0	PRJEB7366	15087	202	1.08982	2.2014364	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0223	NR	RIK43074.1	2026724	g14653	i0	42.9	0.727722772277228	49	25	68.3	1	154	17	19	67	RIK43074.1 MAG: hypothetical protein DCC55_06715 [Chloroflexota bacterium]	diamond	147	42.7	1	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
30287327	30287327	PRJEB7366_P_NODE_22252_length_160_cov_1.224000_g21818_i0	PRJEB7366	22252	160	1.224	1.9584	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52.8	7.53e-7	NR	TMD51050.1	2026724	g21818	i0	49.1	0.99375	53	26	99.4	1	1	159	53	104	TMD51050.1 MAG: DUF4214 domain-containing protein [Chloroflexota bacterium]	diamond	159	52.8	1	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
30911758	30911758	PRJEB7366_P_NODE_9154_length_278_cov_3.740741_g8720_i0	PRJEB7366	9154	278	3.740741	10.39925998	Bacteria	2	Bacteria	Bacteria	84	1.87e-16	NR	MYD91120.1	2605258	g8720	i0	50	3.93884892086331	92	45	98.2	1	275	3	901	992	MYD91120.1 SDR family NAD(P)-dependent oxidoreductase [Caldilineaceae bacterium SB0662_bin_9]	diamond	1095	84	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium SB0662_bin_9
31108236	31108236	PRJEB7366_P_NODE_2775_length_574_cov_2.150278_g2374_i0	PRJEB7366	2775	574	2.150278	12.34259572	Anaerolineales bacterium	2073117	Bacteria	Bacteria	181	6.75e-49	NR	WKZ47473.1	2073117	g2374	i0	48.1	0.98780487804878	189	95	98.8	1	6	572	1584	1769	WKZ47473.1 MAG: SDR family NAD(P)-dependent oxidoreductase [Anaerolineales bacterium]	diamond	567	181	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
32088845	32088845	PRJEB7366_P_NODE_15358_length_199_cov_1.878049_g14924_i0	PRJEB7366	15358	199	1.878049	3.73731751	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	55.8	4.96e-7	NR	HRJ42820.1	2614250	g14924	i0	46.3	2.44221105527638	54	29	81.4	0	35	196	352	405	HRJ42820.1 endo alpha-1,4 polygalactosaminidase [Caldilineaceae bacterium]	diamond	486	55.8	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
32176785	32176785	PRJEB7366_P_NODE_7558_length_314_cov_1.641577_g7124_i0	PRJEB7366	7558	314	1.641577	5.15455178	SAR202 cluster	648176	Bacteria	Bacteria	143	9.099999999999999e-41	NR	MBM3939831.1	2030829	g7124	i0	61.5	26.8949044585987	104	40	99.4	0	1	312	82	185	MBM3939831.1 superoxide dismutase [Fe] [SAR202 cluster bacterium]	diamond	8445	144	0.993055555555556	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia			SAR202 cluster bacterium
32468810	32468810	PRJEB7366_P_NODE_17919_length_181_cov_1.828767_g17485_i0	PRJEB7366	17919	181	1.828767	3.31006827	Chloroflexota bacterium	2026724	Bacteria	Bacteria	57.8	6.18e-8	NR	MEW6180420.1	2026724	g17485	i0	77.4	0.513812154696133	31	7	51.4	0	1	93	237	267	MEW6180420.1 arsenite methyltransferase [Chloroflexota bacterium]	diamond	93	57.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);;