metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA758770" 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_species
2016647	2016647	PRJNA758770_S_NODE_25242_length_251_cov_0.876404_g25116_i0	PRJNA758770	25242	251	0.876404	2.19977404	Anaerolineales bacterium	2073117	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g25116	i0	85.887	3.65737051792829	248	33	98	2	1	247	1989651	1989897	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	918	263	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
8394030	8394030	PRJNA758770_S_NODE_30687_length_244_cov_0.912281_g30561_i0	PRJNA758770	30687	244	0.912281	2.22596564	Anaerolineales bacterium	2073117	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g30561	i0	84.81	1.95081967213115	237	36	97	0	6	242	2463068	2462832	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	476	239	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
8394074	8394074	PRJNA758770_S_NODE_32607_length_242_cov_0.923077_g32481_i0	PRJNA758770	32607	242	0.923077	2.23384634	Anaerolineales bacterium	2073117	Bacteria	Bacteria	150	7.509999999999998e-32	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g32481	i0	82.386	1.45454545454545	176	27	72	4	1	174	248798	248971	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	352	150	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
12220426	12220426	PRJNA758770_S_NODE_31150_length_244_cov_0.912281_g31024_i0	PRJNA758770	31150	244	0.912281	2.22596564	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	222	1.59e-53	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g31024	i0	84.279	92.2090163934426	229	35	93	1	7	234	935775	935547	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	22499	222	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiformaceae bacterium
14769279	14769279	PRJNA758770_S_NODE_14372_length_309_cov_0.991525_g14246_i0	PRJNA758770	14372	309	0.991525	3.06381225	Anaerolineales bacterium	2073117	Bacteria	Bacteria	84.2	1.02e-11	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g14246	i0	91.667	0.194174757281553	60	5	19	0	2	61	2655441	2655382	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	60	84.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
17318849	17318849	PRJNA758770_S_NODE_24154_length_252_cov_0.871508_g24028_i0	PRJNA758770	24154	252	0.871508	2.19620016	Anaerolineales bacterium	2073117	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|2556913751\|gb\|CP129485.1\|	2073117	g24028	i0	98.413	1.98809523809524	252	4	100	0	1	252	1173711	1173962	MAG: Anaerolineales bacterium isolate cMAG.11 chromosome, complete genome	blastn	501	444	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
21143239	21143239	PRJNA758770_S_NODE_28437_length_247_cov_0.896552_g28311_i0	PRJNA758770	28437	247	0.896552	2.21448344	Anaerolineales bacterium	2073117	Bacteria	Bacteria	134	7.750000000000001e-27	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g28311	i0	90.909	1.31578947368421	99	9	40	0	15	113	1314610	1314512	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	325	134	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);;