metadata: contig_metadata: 14 rows where bioproject = "PRJNA807347", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA807347", tax_kingdom = "Bacillati" 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
13559898	13559898	PRJNA807347_P_NODE_14911_length_246_cov_0.895954_g14808_i0	PRJNA807347	14911	246	0.895954	2.20404684	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	204	5.799999999999998e-48	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g14808	i0	94.03	1.3130081300813	134	8	54	0	113	246	1344825	1344692	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	323	204	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21208609	21208609	PRJNA807347_P_NODE_4337_length_398_cov_1.793846_g4234_i0	PRJNA807347	4337	398	1.793846	7.13950708	Anaerolineales bacterium	2073117	Bacteria	Bacteria	309	2.0500000000000003e-79	NTclustered	gi\|2814788355\|emb\|OY776212.2\|	2073117	g4234	i0	81.606	111.718592964824	386	60	95	11	4	383	1138661	1139041	MAG: Anaerolineales bacterium isolate db28be52-e32f-4f71-9c49-3cbd2ddbe7d1 genome assembly, chromosome: 1	blastn	44464	309	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
22483192	22483192	PRJNA807347_P_NODE_2358_length_546_cov_2.710359_g2255_i0	PRJNA807347	2358	546	2.710359	14.79856014	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	196	2.34e-45	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g2255	i0	81.377	128.478021978022	247	41	45	5	302	546	1354	1111	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	70149	196	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23758940	23758940	PRJNA807347_P_NODE_3939_length_419_cov_1.017341_g3836_i0	PRJNA807347	3939	419	1.017341	4.26265879	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	429	1.59e-115	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g3836	i0	85.511	190.923627684964	421	50	99	11	1	415	10940	10525	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	79997	429	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
25032803	25032803	PRJNA807347_P_NODE_9460_length_273_cov_1.995000_g9357_i0	PRJNA807347	9460	273	1.995	5.44635	Anaerolineae bacterium	2052143	Bacteria	Bacteria	239	1.79e-58	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g9357	i0	82.437	92.9194139194139	279	43	100	5	1	273	3690126	3689848	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	25367	239	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27054233	27054233	PRJNA807347_P_NODE_15262_length_245_cov_0.906977_g15159_i0	PRJNA807347	15262	245	0.906977	2.22209365	Anaerolineales bacterium	2073117	Bacteria	Bacteria	136	1.6e-35	NR	MCA9942187.1	2073117	g15159	i0	77.8	0.991836734693878	81	18	99.2	0	1	243	414	494	MCA9942187.1 hypothetical protein [Anaerolineales bacterium]	diamond	243	136	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27812509	27812509	PRJNA807347_P_NODE_16984_length_242_cov_0.923077_g16881_i0	PRJNA807347	16984	242	0.923077	2.23384634	Anaerolineae bacterium	2052143	Bacteria	Bacteria	128	2.43e-32	NR	MDX1520212.1	2052143	g16881	i0	78.1	0.90495867768595	73	16	90.5	0	24	242	164	236	MDX1520212.1 CRISPR-associated helicase Cas3' [Anaerolineae bacterium]	diamond	219	128	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28190962	28190962	PRJNA807347_P_NODE_11206_length_256_cov_2.557377_g11103_i0	PRJNA807347	11206	256	2.557377	6.54688512	Anaerolineae bacterium	2052143	Bacteria	Bacteria	72.4	5.17e-14	NR	KAB2861023.1	2052143	g11103	i0	47.1	0.99609375	85	43	97.3	1	256	8	25	109	KAB2861023.1 MAG: hypothetical protein F9K46_09030 [Anaerolineae bacterium]	diamond	255	72.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28980731	28980731	PRJNA807347_P_NODE_17348_length_239_cov_4.506024_g17245_i0	PRJNA807347	17348	239	4.506024	10.76939736	Anaerolineales bacterium	2073117	Bacteria	Bacteria	77.8	1.6e-14	NR	NIS83537.1	2073117	g17245	i0	51.3	16.9958158995816	78	38	97.9	0	1	234	118	195	NIS83537.1 bifunctional transaldolase/phosoglucose isomerase [Anaerolineales bacterium]	diamond	4062	77.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29264511	29264511	PRJNA807347_P_NODE_14389_length_247_cov_0.890805_g14286_i0	PRJNA807347	14389	247	0.890805	2.20028835	Chloroflexota bacterium	2026724	Bacteria	Bacteria	164	6.699999999999999e-46	NR	MBI3913362.1	2026724	g14286	i0	97.6	0.995951417004049	82	2	99.6	0	247	2	80	161	MBI3913362.1 cyclic nucleotide-binding domain-containing protein [Chloroflexota bacterium]	diamond	246	164	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31191260	31191260	PRJNA807347_P_NODE_12535_length_251_cov_0.870787_g12432_i0	PRJNA807347	12535	251	0.870787	2.18567537	Anaerolineae bacterium	2052143	Bacteria	Bacteria	98.6	9.33e-22	NR	MCL6509816.1	2052143	g12432	i0	67.7	1.55378486055777	65	21	77.7	0	1	195	104	168	MCL6509816.1 conjugal transfer protein TrbE [Anaerolineae bacterium]	diamond	390	98.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32022928	32022928	PRJNA807347_P_NODE_9158_length_276_cov_2.305419_g9055_i0	PRJNA807347	9158	276	2.305419	6.36295644	Bacteria	2	Bacteria	Bacteria	76.3	5.97e-14	NR	HRA67479.1	2293560	g9055	i0	79.5	0.956521739130435	44	9	47.8	0	3	134	295	338	HRA67479.1 host specificity factor TipJ family phage tail protein [Caldilinea sp.]	diamond	264	76.3	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp.
32172431	32172431	PRJNA807347_P_NODE_17398_length_238_cov_2.496970_g17295_i0	PRJNA807347	17398	238	2.49697	5.9427886	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	95.9	1.26e-23	NR	MBP8294041.1	2614250	g17295	i0	60.3	1.96638655462185	78	31	98.3	0	2	235	25	102	MBP8294041.1 hypothetical protein [Caldilineaceae bacterium]	diamond	468	95.9	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32520541	32520541	PRJNA807347_P_NODE_4119_length_408_cov_1.346269_g4016_i0	PRJNA807347	4119	408	1.346269	5.49277752	Chloroflexota bacterium	2026724	Bacteria	Bacteria	168	1.7e-50	NR	MCX6008903.1	2026724	g4016	i0	70.7	0.904411764705882	123	36	90.4	0	1	369	37	159	MCX6008903.1 hypothetical protein [Chloroflexota bacterium]	diamond	369	168	1	Bacteria	Bacillati	Chloroflexota					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);;