metadata: contig_metadata: 15 rows where bioproject = "PRJNA1093380", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA1093380", 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
4025810	4025810	PRJNA1093380_P_NODE_3444_length_330_cov_1.797665_g3338_i0	PRJNA1093380	3444	330	1.797665	5.9322945	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	407	5.76e-109	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g3338	i0	90.159	93.3727272727273	315	28	95	3	18	330	1857803	1857490	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	30813	407	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7851859	7851859	PRJNA1093380_P_NODE_1747_length_426_cov_2.739377_g1641_i0	PRJNA1093380	1747	426	2.739377	11.66974602	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	719	0	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g1641	i0	97.176	407.779342723005	425	12	99	0	2	426	18775	19199	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	173714	719	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9126901	9126901	PRJNA1093380_P_NODE_8908_length_268_cov_1.630769_g8802_i0	PRJNA1093380	8908	268	1.630769	4.37046092	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	435	2.09e-117	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g8802	i0	95.896	302.682835820896	268	11	100	0	1	268	1858747	1858480	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	81119	435	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9947389	9947389	PRJNA1093380_P_NODE_15428_length_244_cov_1.239766_g15322_i0	PRJNA1093380	15428	244	1.239766	3.02502904	Dehalogenimonas	670486	Bacteria	Bacteria	165	2.71e-36	NTclustered	gi\|470486512\|ref\|NR_076762.1\|	552810	g15322	i0	82.143	105.758196721311	196	31	80	4	1	194	1449	1256	Dehalogenimonas lykanthroporepellens strain BL-DC-9 23S ribosomal RNA gene, complete sequence	blastn	25805	165	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas lykanthroporepellens
10402447	10402447	PRJNA1093380_P_NODE_2389_length_375_cov_2.092715_g2283_i0	PRJNA1093380	2389	375	2.092715	7.84768125	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	573	6.159999999999998e-159	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g2283	i0	94.18	167.056	378	18	100	4	1	375	2428872	2429248	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	62646	573	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27035988	27035988	PRJNA1093380_P_NODE_15262_length_245_cov_0.866279_g15156_i0	PRJNA1093380	15262	245	0.866279	2.12238355	Chloroflexota bacterium	2026724	Bacteria	Bacteria	47	0.00112	NR	MBW8010963.1	2026724	g15156	i0	36.6	1.71428571428571	71	42	85.7	2	34	243	112	180	MBW8010963.1 hypothetical protein [Chloroflexota bacterium]	diamond	420	47	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28015312	28015312	PRJNA1093380_P_NODE_565_length_745_cov_1.284226_g469_i0	PRJNA1093380	565	745	1.284226	9.5674837	Anaerolineae bacterium	2052143	Bacteria	Bacteria	238	1.3e-74	NR	MCL6509847.1	2052143	g469	i0	77.9	1.12751677852349	140	31	56.4	0	420	1	48	187	MCL6509847.1 replication initiator protein A [Anaerolineae bacterium]	diamond	840	238	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28488842	28488842	PRJNA1093380_P_NODE_17127_length_241_cov_0.916667_g17021_i0	PRJNA1093380	17127	241	0.916667	2.20916747	Dictyobacter formicarum	2778368	Bacteria	Bacteria	44.7	0.00746	NR	WP_201367415.1	2778368	g17021	i0	40	0.746887966804979	60	34	73.4	2	224	48	257	315	WP_201367415.1 FtsX-like permease family protein [Dictyobacter formicarum]	diamond	180	44.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter formicarum
28615150	28615150	PRJNA1093380_P_NODE_4707_length_297_cov_2.330357_g4601_i0	PRJNA1093380	4707	297	2.330357	6.92116029	Anaerolineae bacterium	2052143	Bacteria	Bacteria	165	1.04e-47	NR	MCL6509811.1	2052143	g4601	i0	81.4	0.97979797979798	97	18	98	0	293	3	222	318	MCL6509811.1 P-type conjugative transfer protein TrbG [Anaerolineae bacterium]	diamond	291	165	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28764201	28764201	PRJNA1093380_P_NODE_2827_length_355_cov_1.092199_g2721_i0	PRJNA1093380	2827	355	1.092199	3.87730645	Bacillati	1783272	Bacteria	Bacteria	144	1.08e-38	NR	MFL5679769.1	2026724	g2721	i0	62.8	2.88169014084507	113	42	95.5	0	349	11	274	386	MFL5679769.1 vanadium-dependent haloperoxidase [Chloroflexota bacterium]	diamond	1023	144	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30090406	30090406	PRJNA1093380_P_NODE_16412_length_242_cov_0.911243_g16306_i0	PRJNA1093380	16412	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	102	3.34e-23	NR	MDP9364922.1	2026724	g16306	i0	55	1.94628099173554	80	36	99.2	0	2	241	387	466	MDP9364922.1 CocE/NonD family hydrolase [Chloroflexota bacterium]	diamond	471	102	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30889125	30889125	PRJNA1093380_P_NODE_8734_length_269_cov_1.571429_g8628_i0	PRJNA1093380	8734	269	1.571429	4.22714401	Chloroflexota bacterium	2026724	Bacteria	Bacteria	104	4.71e-26	NR	MDP9351173.1	2026724	g8628	i0	58.6	1.96282527881041	87	35	95.9	1	4	261	91	177	MDP9351173.1 histidine phosphatase family protein [Chloroflexota bacterium]	diamond	528	104	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31553218	31553218	PRJNA1093380_P_NODE_10136_length_261_cov_1.638298_g10030_i0	PRJNA1093380	10136	261	1.638298	4.27595778	Thermoflexaceae bacterium	2739507	Bacteria	Bacteria	43.1	0.034	NR	MBE7519910.1	2739507	g10030	i0	36.9	0.747126436781609	65	38	74.7	2	14	208	403	464	MBE7519910.1 cation-transporting P-type ATPase [Thermoflexaceae bacterium]	diamond	195	43.1	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae		Thermoflexaceae bacterium
31837440	31837440	PRJNA1093380_P_NODE_4677_length_298_cov_1.368889_g4571_i0	PRJNA1093380	4677	298	1.368889	4.07928922	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	43.5	0.0352	NR	MEO5986898.1	3047546	g4571	i0	42	0.694630872483222	69	37	67.4	2	69	269	136	203	MEO5986898.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Limnocylindria bacterium]	diamond	207	43.5	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32122566	32122566	PRJNA1093380_P_NODE_15238_length_245_cov_0.895349_g15132_i0	PRJNA1093380	15238	245	0.895349	2.19360505	Chloroflexota bacterium	2026724	Bacteria	Bacteria	94	1.44e-22	NR	MEW6225270.1	2026724	g15132	i0	62	0.869387755102041	71	27	86.9	0	244	32	50	120	MEW6225270.1 hypothetical protein [Chloroflexota bacterium]	diamond	213	94	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);;