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

7 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
5534567	5534567	PRJNA436017_P_NODE_24625_length_164_cov_1.858268_g24327_i0	PRJNA436017	24625	164	1.858268	3.04755952	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	241	2.72e-59	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g24327	i0	93.252	115.036585365854	163	11	99	0	1	163	596964	596802	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	18866	241	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6808423	6808423	PRJNA436017_P_NODE_18746_length_189_cov_1.506579_g18448_i0	PRJNA436017	18746	189	1.506579	2.84743431	Pelolinea submarina	913107	Bacteria	Bacteria	119	1.58e-22	NTclustered	gi\|1446038753\|dbj\|AP018437.1\|	913107	g18448	i0	87.5	1.12169312169312	104	12	54	1	87	189	3507447	3507550	Pelolinea submarina MO-CFX1 DNA, complete genome	blastn	212	119	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Pelolinea	Pelolinea submarina
9359026	9359026	PRJNA436017_P_NODE_3248_length_519_cov_7.927386_g2972_i0	PRJNA436017	3248	519	7.927386	41.14313334	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	514	5.399999999999999e-141	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g2972	i0	84.704	98.383429672447	523	70	100	10	1	519	598446	598962	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	51061	514	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
11909432	11909432	PRJNA436017_P_NODE_1430_length_789_cov_2.894947_g1232_i0	PRJNA436017	1430	789	2.894947	22.84113183	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	385	6.87e-102	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g1232	i0	76.161	35.3333333333333	797	152	99	31	1	782	777953	778726	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	27878	385	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
14459597	14459597	PRJNA436017_P_NODE_2132_length_648_cov_6.050736_g104_i4	PRJNA436017	2132	648	6.050736	39.20876928	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	941	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i4	92.901	449.487654320988	648	44	100	2	1	648	597828	598473	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	291268	941	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
14459744	14459744	PRJNA436017_P_NODE_392_length_1342_cov_8.143295_g104_i1	PRJNA436017	392	1342	8.143295	109.2830189	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1637	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i1	88.79	709.435171385991	1347	135	99	13	2	1342	598427	597091	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	952062	1637	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20832700	20832700	PRJNA436017_P_NODE_8817_length_294_cov_3.459144_g8519_i0	PRJNA436017	8817	294	3.459144	10.16988336	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	433	8.34e-117	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g8519	i0	93.197	312.517006802721	294	20	100	0	1	294	596684	596391	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	91880	433	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve

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);;