metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA752278" 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
2002732	2002732	PRJNA752278_P_NODE_103082_length_241_cov_2.642857_g102879_i0	PRJNA752278	103082	241	2.642857	6.36928537	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|2893358439\|emb\|OZ220731.1\|	2026734	g102879	i0	81.25	120.485477178423	240	43	99	2	3	241	764894	765132	MAG: Dehalococcoidia bacterium isolate 4e89fbe3-e5a8-4f6c-a4f9-b322f53a0d40 genome assembly, chromosome: 1	blastn	29037	193	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4556902	4556902	PRJNA752278_P_NODE_96324_length_244_cov_0.900585_g96121_i0	PRJNA752278	96324	244	0.900585	2.1974274	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2814788336\|emb\|OY760867.2\|	2026734	g96121	i0	96.97	0.135245901639344	33	1	14	0	32	64	3086284	3086252	MAG: Dehalococcoidia bacterium isolate ec36dd00-29ce-491f-9a3f-6816ace52b4b genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9656276	9656276	PRJNA752278_P_NODE_57448_length_270_cov_1.558376_g57245_i0	PRJNA752278	57448	270	1.558376	4.2076152	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	272	1.74e-68	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g57245	i0	85.366	5.04074074074074	287	15	99	13	1	269	1090780	1091057	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	1361	272	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12207046	12207046	PRJNA752278_P_NODE_4830_length_591_cov_2.868726_g4629_i0	PRJNA752278	4830	591	2.868726	16.95417066	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	180	2.57e-40	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g4629	i0	75.176	43.7732656514382	427	83	70	22	21	432	3521413	3520995	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	25870	180	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12207325	12207325	PRJNA752278_P_NODE_62750_length_265_cov_1.604167_g62547_i0	PRJNA752278	62750	265	1.604167	4.25104255	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	361	3.539999999999999e-95	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g62547	i0	91.603	75.3849056603774	262	20	98	2	5	265	1654351	1654611	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	19977	361	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17306287	17306287	PRJNA752278_P_NODE_79034_length_251_cov_0.865169_g78831_i0	PRJNA752278	79034	251	0.865169	2.17157419	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g78831	i0	87.56	4.98406374501992	209	22	82	4	42	248	2697855	2698061	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	1251	239	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22404112	22404112	PRJNA752278_P_NODE_104158_length_241_cov_0.916667_g103955_i0	PRJNA752278	104158	241	0.916667	2.20916747	Tepidiforma flava	3004094	Bacteria	Bacteria	385	1.88e-102	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g103955	i0	95.436	2.10373443983402	241	11	100	0	1	241	364602	364842	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	507	385	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
23680687	23680687	PRJNA752278_P_NODE_5299_length_572_cov_3.569138_g5098_i0	PRJNA752278	5299	572	3.569138	20.41546936	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	350	1.79e-91	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g5098	i0	78.378	64.9895104895105	592	90	99	30	5	572	3521411	3520834	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	37174	350	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24954990	24954990	PRJNA752278_P_NODE_93760_length_245_cov_0.895349_g93557_i0	PRJNA752278	93760	245	0.895349	2.19360505	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	71.3	6.11e-8	NTclustered	gi\|2621705270\|emb\|OY763410.1\|	2026734	g93557	i0	90.741	0.220408163265306	54	3	22	2	155	207	889706	889758	MAG: Dehalococcoidia bacterium isolate 8eeee495-67cd-41f6-86a6-ff8f0dc0d692 genome assembly, chromosome: 1	blastn	54	71.3	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);;