metadata: contig_metadata: 6 rows where bioproject = "PRJNA674048", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA674048", 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
4471015	4471015	PRJNA674048_P_NODE_18564_length_205_cov_2.692308_g18361_i0	PRJNA674048	18564	205	2.692308	5.5192314	Anaerolineales bacterium	2073117	Bacteria	Bacteria	302	1.61e-77	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g18361	i0	93.204	114.351219512195	206	12	100	2	1	205	2028790	2028586	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	23442	302	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineales bacterium
5746659	5746659	PRJNA674048_P_NODE_33385_length_158_cov_3.082569_g33182_i0	PRJNA674048	33385	158	3.082569	4.87045902	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	196	5.699999999999999e-46	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g33182	i0	89.809	639.411392405063	157	11	97	5	1	154	566721	566875	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	101027	196	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
7021791	7021791	PRJNA674048_P_NODE_31446_length_163_cov_1.824561_g31243_i0	PRJNA674048	31446	163	1.824561	2.97403443	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	1.68e-31	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g31243	i0	87.5	7.67484662576687	128	16	79	0	32	159	948618	948745	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	1251	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
12122363	12122363	PRJNA674048_P_NODE_18830_length_204_cov_1.109677_g18627_i0	PRJNA674048	18830	204	1.109677	2.26374108	Anaerolineales bacterium	2073117	Bacteria	Bacteria	300	5.76e-77	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g18627	i0	93.532	53.2107843137255	201	13	99	0	1	201	2029723	2029523	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	10855	300	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineales bacterium
15945716	15945716	PRJNA674048_P_NODE_14473_length_236_cov_2.090909_g14270_i0	PRJNA674048	14473	236	2.090909	4.93454524	Anaerolineales bacterium	2073117	Bacteria	Bacteria	398	2.36e-106	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g14270	i0	97.034	30.4025423728814	236	7	100	0	1	236	1576449	1576214	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	7175	398	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineales bacterium
31092824	31092824	PRJNA674048_P_NODE_16875_length_216_cov_3.401198_g16672_i0	PRJNA674048	16875	216	3.401198	7.34658768	Anaerolineales bacterium	2073117	Bacteria	Bacteria	137	7.79e-38	NR	MDP6583856.1	2073117	g16672	i0	88.9	2	72	8	100	0	1	216	18	89	MDP6583856.1 hypothetical protein [Anaerolineales bacterium]	diamond	432	137	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);;