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

5 rows where analysis = "blastn", bioproject = "PRJNA897077" 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
5976923	5976923	PRJNA897077_P_NODE_16965_length_249_cov_0.886364_g16838_i0	PRJNA897077	16965	249	0.886364	2.20704636	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	87.9	6.18e-13	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g16838	i0	96.226	0.21285140562249	53	2	21	0	194	246	2871506	2871558	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	53	87.9	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8526566	8526566	PRJNA897077_P_NODE_6547_length_380_cov_1.270358_g6420_i0	PRJNA897077	6547	380	1.270358	4.8273604	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	300	1.17e-76	NTclustered	gi\|2621706268\|emb\|OY764162.1\|	2026734	g6420	i0	82.857	126.902631578947	350	45	91	13	36	380	1579006	1578667	MAG: Dehalococcoidia bacterium isolate c2b86379-bd31-4c30-aa6f-eeb60e07e050 genome assembly, chromosome: 1	blastn	48223	300	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9801440	9801440	PRJNA897077_P_NODE_16008_length_251_cov_0.876404_g15881_i0	PRJNA897077	16008	251	0.876404	2.19977404	Tepidiforma flava	3004094	Bacteria	Bacteria	139	1.7000000000000003e-28	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g15881	i0	93.548	36.2868525896414	93	6	37	0	128	220	1586302	1586210	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	9108	139	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
16176483	16176483	PRJNA897077_P_NODE_7413_length_358_cov_2.045614_g7286_i0	PRJNA897077	7413	358	2.045614	7.32329812	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	178	5.36e-40	NTclustered	gi\|2621706248\|emb\|OY764157.1\|	2952883	g7286	i0	81.197	14.2346368715084	234	33	64	10	97	326	142910	142684	MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1	blastn	5096	178	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
22550485	22550485	PRJNA897077_P_NODE_19398_length_243_cov_0.917647_g19271_i0	PRJNA897077	19398	243	0.917647	2.22988221	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	84.2	7.77e-12	NTclustered	gi\|2621704926\|emb\|OY762213.1\|	2026734	g19271	i0	100	1.90534979423868	45	0	19	0	24	68	1547173	1547129	MAG: Dehalococcoidia bacterium isolate 03469a5e-dcd7-4577-8116-c1a2ee551a24 genome assembly, chromosome: 1	blastn	463	84.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;