metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA807347" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA807347" 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
13559898	13559898	PRJNA807347_P_NODE_14911_length_246_cov_0.895954_g14808_i0	PRJNA807347	14911	246	0.895954	2.20404684	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	204	5.799999999999998e-48	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g14808	i0	94.03	1.3130081300813	134	8	54	0	113	246	1344825	1344692	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	323	204	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia		uncultured Chloroflexia bacterium
21208609	21208609	PRJNA807347_P_NODE_4337_length_398_cov_1.793846_g4234_i0	PRJNA807347	4337	398	1.793846	7.13950708	Anaerolineales bacterium	2073117	Bacteria	Bacteria	309	2.0500000000000003e-79	NTclustered	gi\|2814788355\|emb\|OY776212.2\|	2073117	g4234	i0	81.606	111.718592964824	386	60	95	11	4	383	1138661	1139041	MAG: Anaerolineales bacterium isolate db28be52-e32f-4f71-9c49-3cbd2ddbe7d1 genome assembly, chromosome: 1	blastn	44464	309	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineales bacterium
22483192	22483192	PRJNA807347_P_NODE_2358_length_546_cov_2.710359_g2255_i0	PRJNA807347	2358	546	2.710359	14.79856014	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	196	2.34e-45	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g2255	i0	81.377	128.478021978022	247	41	45	5	302	546	1354	1111	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	70149	196	1	Bacteria	Bacillati	Chloroflexota			uncultured Chloroflexota bacterium
23758940	23758940	PRJNA807347_P_NODE_3939_length_419_cov_1.017341_g3836_i0	PRJNA807347	3939	419	1.017341	4.26265879	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	429	1.59e-115	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g3836	i0	85.511	190.923627684964	421	50	99	11	1	415	10940	10525	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	79997	429	1	Bacteria	Bacillati	Chloroflexota			uncultured Chloroflexota bacterium
25032803	25032803	PRJNA807347_P_NODE_9460_length_273_cov_1.995000_g9357_i0	PRJNA807347	9460	273	1.995	5.44635	Anaerolineae bacterium	2052143	Bacteria	Bacteria	239	1.79e-58	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g9357	i0	82.437	92.9194139194139	279	43	100	5	1	273	3690126	3689848	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	25367	239	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);;