metadata: contig_metadata: 8 rows where bioproject = "PRJNA509429", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA509429", 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
4939022	4939022	PRJNA509429_P_NODE_38184_length_187_cov_2.236842_g37356_i0	PRJNA509429	38184	187	2.236842	4.18289454	Caldilinea	233191	Bacteria	Bacteria	329	6.6e-86	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g37356	i0	98.396	528.791443850267	187	3	100	0	1	187	2375	2561	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	98884	329	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
6214270	6214270	PRJNA509429_P_NODE_45825_length_164_cov_1.240310_g44997_i0	PRJNA509429	45825	164	1.24031	2.0341084	Roseiflexus	120961	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g44997	i0	87.879	142.134146341463	165	17	100	3	1	164	1845	1683	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	23310	191	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
10689087	10689087	PRJNA509429_P_NODE_51849_length_150_cov_1.104348_g51021_i0	PRJNA509429	51849	150	1.104348	1.656522	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	89.8	9.31e-14	NTclustered	gi\|2621702852\|emb\|OY761846.1\|	2026734	g51021	i0	81.197	6.43333333333333	117	16	75	5	30	142	1918365	1918251	MAG: Dehalococcoidia bacterium isolate 25673f87-720a-4069-84ac-b50b95d4b761 genome assembly, chromosome: 1	blastn	965	89.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
17062604	17062604	PRJNA509429_P_NODE_51334_length_151_cov_1.379310_g50506_i0	PRJNA509429	51334	151	1.37931	2.0827581	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	154	3.28e-33	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g50506	i0	85.235	8.6887417218543	149	22	99	0	1	149	2064510	2064362	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	1312	154	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22162081	22162081	PRJNA509429_P_NODE_50518_length_153_cov_0.915254_g49690_i0	PRJNA509429	50518	153	0.915254	1.40033862	Anaerolineales bacterium	2073117	Bacteria	Bacteria	239	8.96e-59	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g49690	i0	94.771	22.6601307189542	153	8	100	0	1	153	1232950	1233102	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	3467	239	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29761152	29761152	PRJNA509429_P_NODE_31671_length_215_cov_5.150000_g30843_i0	PRJNA509429	31671	215	5.15	11.0725	Anaerolineae bacterium	2052143	Bacteria	Bacteria	40.8	0.047	NR	MEZ4667052.1	2052143	g30843	i0	38.3	0.837209302325581	60	36	83.7	1	26	205	34	92	MEZ4667052.1 hypothetical protein [Anaerolineae bacterium]	diamond	180	40.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30866980	30866980	PRJNA509429_P_NODE_31154_length_218_cov_2.000000_g30326_i0	PRJNA509429	31154	218	2	4.36	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.045	NR	TMD25539.1	2026724	g30326	i0	42.9	0.674311926605505	49	28	67.4	0	185	39	184	232	TMD25539.1 MAG: DUF2029 domain-containing protein [Chloroflexota bacterium]	diamond	147	42	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31910472	31910472	PRJNA509429_P_NODE_38897_length_185_cov_1.066667_g38069_i0	PRJNA509429	38897	185	1.066667	1.97333395	Anaerolineae bacterium	2052143	Bacteria	Bacteria	60.1	1.16e-8	NR	MCL6509819.1	2052143	g38069	i0	71.4	0.681081081081081	42	12	68.1	0	185	60	280	321	MCL6509819.1 P-type conjugative transfer ATPase TrbB [Anaerolineae bacterium]	diamond	126	60.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;