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

8 rows where bioproject = "PRJNA680334", 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_species
650671	650671	PRJNA680334_S_NODE_9941_length_315_cov_3.184397_g9455_i0	PRJNA680334	9941	315	3.184397	10.03085055	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	182	3.6e-41	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g9455	i0	80.242	243.368253968254	248	43	77	6	70	313	7865	7620	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	76661	182	1	Bacteria	Bacillati	Chloroflexota			uncultured Chloroflexota bacterium
5753167	5753167	PRJNA680334_S_NODE_31225_length_222_cov_2.989418_g30739_i0	PRJNA680334	31225	222	2.989418	6.63650796	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	67.6	7.03e-7	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g30739	i0	87.931	3	58	5	25	2	136	191	11123909	11123852	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	666	67.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
17228087	17228087	PRJNA680334_S_NODE_59094_length_182_cov_2.281879_g58608_i0	PRJNA680334	59094	182	2.281879	4.15301978	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	124	3.2299999999999997e-24	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g58608	i0	82.166	126.148351648352	157	17	83	10	32	182	380998	381149	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	22959	124	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineales bacterium
27883352	27883352	PRJNA680334_S_NODE_79305_length_165_cov_6.280303_g78819_i0	PRJNA680334	79305	165	6.280303	10.36249995	Kouleothrix	186475	Bacteria	Bacteria	102	2.27e-26	NR	MDQ2998083.1	2026724	g78819	i0	88.9	8.78181818181818	54	6	98.2	0	3	164	15	68	MDQ2998083.1 zinc ribbon domain-containing protein [Chloroflexota bacterium]	diamond	1449	103	0.990291262135922	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
28345217	28345217	PRJNA680334_S_NODE_50246_length_191_cov_8.753165_g49760_i0	PRJNA680334	50246	191	8.753165	16.71854515	Anaerolineae bacterium	2052143	Bacteria	Bacteria	109	9.14e-27	NR	MCC7164374.1	2052143	g49760	i0	85.7	0.989528795811518	63	9	99	0	189	1	252	314	MCC7164374.1 DUF2332 domain-containing protein [Anaerolineae bacterium]	diamond	189	109	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
28724158	28724158	PRJNA680334_S_NODE_46507_length_196_cov_3.662577_g46021_i0	PRJNA680334	46507	196	3.662577	7.17865092	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	105	1.3399999999999999e-24	NR	MDO9333522.1	2026733	g46021	i0	80.3	0.933673469387755	61	12	93.4	0	194	12	349	409	MDO9333522.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	183	105	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidales bacterium
30398398	30398398	PRJNA680334_S_NODE_78393_length_166_cov_2.781955_g77907_i0	PRJNA680334	78393	166	2.781955	4.6180453	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52	6.38e-6	NR	MDP9471245.1	2026724	g77907	i0	47.9	3.2710843373494	48	25	86.7	0	21	164	29	76	MDP9471245.1 YCF48-related protein [Chloroflexota bacterium]	diamond	543	52	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
30840248	30840248	PRJNA680334_S_NODE_19834_length_255_cov_3.000000_g19348_i0	PRJNA680334	19834	255	3	7.65	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62.4	5.22e-9	NR	MBA3871054.1	2052143	g19348	i0	88.2	0.4	34	4	40	0	3	104	316	349	MBA3871054.1 GAF domain-containing protein [Anaerolineae bacterium]	diamond	102	62.4	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);;