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

9 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
1885856	1885856	PRJNA640143_S_NODE_12882_length_241_cov_261.441176_g12672_i0	PRJNA640143	12882	241	261.441176	630.07323416	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	289	1.52e-73	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g12672	i0	92.574	103.50622406639	202	14	83	1	1	201	598734	598935	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	24945	289	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
4983585	4983585	PRJNA640143_S_NODE_10664_length_264_cov_9.101322_g10454_i0	PRJNA640143	10664	264	9.101322	24.02749008	Caldilinea	233191	Bacteria	Bacteria	348	2.7500000000000004e-91	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g10454	i0	94.643	276.746212121212	224	12	85	0	40	263	3	226	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	73061	348	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8262994	8262994	PRJNA640143_S_NODE_16247_length_216_cov_14.882682_g16037_i0	PRJNA640143	16247	216	14.882682	32.14659312	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	102	1.87e-17	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g16037	i0	96.721	12.5416666666667	61	2	28	0	123	183	9447	9387	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	2709	102	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
10814134	10814134	PRJNA640143_S_NODE_23429_length_182_cov_1.931034_g23219_i0	PRJNA640143	23429	182	1.931034	3.51448188	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	196	6.76e-46	NTclustered	gi\|2893358453\|emb\|OZ220745.1\|	2026734	g23219	i0	87.283	17.6923076923077	173	20	95	2	2	173	2300011	2299840	MAG: Dehalococcoidia bacterium isolate d99f35f8-e104-4752-81ca-da635d51ba71 genome assembly, chromosome: 1	blastn	3220	196	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
10814437	10814437	PRJNA640143_S_NODE_6929_length_319_cov_6.673759_g6719_i0	PRJNA640143	6929	319	6.673759	21.28929121	Anaerolineae bacterium	2052143	Bacteria	Bacteria	171	7.91e-38	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g6719	i0	81.951	73.166144200627	205	31	63	5	34	235	3692700	3692499	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	23340	171	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
13363777	13363777	PRJNA640143_S_NODE_10751_length_263_cov_5.442478_g10541_i0	PRJNA640143	10751	263	5.442478	14.31371714	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	403	5.75e-108	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g10541	i0	99.107	114.152091254753	224	2	85	0	8	231	596285	596508	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	30022	403	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
13909387	13909387	PRJNA640143_S_NODE_26251_length_172_cov_1.511111_g26041_i0	PRJNA640143	26251	172	1.511111	2.59911092	Bacteria	2	Bacteria	Bacteria	80.5	6.62e-11	NTclustered	gi\|2107717100\|gb\|CP070842.1\|	2026733	g26041	i0	92.727	5.80232558139535	55	4	32	0	1	55	456037	455983	MAG: Dehalococcoidales bacterium isolate bin10 chromosome	blastn	998	80.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
22286891	22286891	PRJNA640143_S_NODE_18058_length_206_cov_2.355030_g17848_i0	PRJNA640143	18058	206	2.35503	4.8513618	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	250	5.9499999999999995e-62	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g17848	i0	91.257	17.8203883495146	183	16	89	0	1	183	6889468	6889650	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	3671	250	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
23562328	23562328	PRJNA640143_S_NODE_14679_length_227_cov_3.994737_g14469_i0	PRJNA640143	14679	227	3.994737	9.06805299	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	261	3.09e-65	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g14469	i0	87.665	586.145374449339	227	25	99	3	3	227	8453	8678	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	133055	261	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota 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);;