metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
544672	544672	PRJNA560932_P_NODE_40501_length_286_cov_1.446009_g40145_i0	PRJNA560932	40501	286	1.446009	4.13558574	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	440	4.829999999999998e-119	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g40145	i0	94.406	155.255244755245	286	16	100	0	1	286	597771	598056	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	44403	440	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6234153	6234153	PRJNA560932_P_NODE_48705_length_261_cov_1.228723_g48349_i0	PRJNA560932	48705	261	1.228723	3.20696703	Caldilinea	233191	Bacteria	Bacteria	311	3.56e-80	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g48349	i0	92.237	357.961685823755	219	17	84	0	1	219	51	269	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	93428	311	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
12023933	12023933	PRJNA560932_P_NODE_60910_length_245_cov_0.895349_g60554_i0	PRJNA560932	60910	245	0.895349	2.19360505	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	313	9.19e-81	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g60554	i0	89.754	556.044897959184	244	25	99	0	1	244	597725	597482	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	136231	313	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
18396586	18396586	PRJNA560932_P_NODE_40335_length_287_cov_1.074766_g39979_i0	PRJNA560932	40335	287	1.074766	3.08457842	Anaerolineales bacterium	2073117	Bacteria	Bacteria	436	6.2699999999999985e-118	NTclustered	gi\|2814788355\|emb\|OY776212.2\|	2073117	g39979	i0	94.681	120.686411149826	282	14	98	1	1	282	1140249	1139969	MAG: Anaerolineales bacterium isolate db28be52-e32f-4f71-9c49-3cbd2ddbe7d1 genome assembly, chromosome: 1	blastn	34637	436	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
19671283	19671283	PRJNA560932_P_NODE_53876_length_250_cov_0.870056_g53520_i0	PRJNA560932	53876	250	0.870056	2.17514	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	143	1.31e-29	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g53520	i0	78.601	845.032	243	32	95	15	6	243	2203535	2203762	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	211258	143	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
25356874	25356874	PRJNA560932_P_NODE_3460_length_907_cov_2.636691_g3183_i0	PRJNA560932	3460	907	2.636691	23.91478737	Chloroflexota	200795	Bacteria	Bacteria	710	0	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g3183	i0	81.223	819.856670341786	916	141	99	28	1	901	2063520	2064419	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	743610	710	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;