metadata: contig_metadata: 12 rows where bioproject = "PRJNA1005695", tax_kingdom = "Bacillati" and tax

12 rows where bioproject = "PRJNA1005695", 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
2276246	2276246	PRJNA1005695_P_NODE_30102_length_272_cov_1.567839_g29250_i0	PRJNA1005695	30102	272	1.567839	4.26452208	Chloroflexus	1107	Bacteria	Bacteria	209	1.4e-49	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g29250	i0	92.466	72.2058823529412	146	11	54	0	127	272	417	562	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	19640	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
2703794	2703794	PRJNA1005695_P_NODE_34443_length_253_cov_1.894444_g33591_i0	PRJNA1005695	34443	253	1.894444	4.79294332	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	86.1	2.26e-12	NTclustered	gi\|2893356041\|emb\|OZ220464.1\|	2026734	g33591	i0	94.545	3.68379446640316	55	3	22	0	1	55	2380736	2380682	MAG: Dehalococcoidia bacterium isolate 865023ef-8e16-4315-bfec-facb54b4b210 genome assembly, chromosome: 1	blastn	932	86.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7806044	7806044	PRJNA1005695_P_NODE_24487_length_303_cov_2.304348_g23635_i0	PRJNA1005695	24487	303	2.304348	6.98217444	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	189	2.0599999999999996e-43	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g23635	i0	83.105	309.221122112211	219	25	70	10	61	272	240405	240192	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	93694	189	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9929129	9929129	PRJNA1005695_P_NODE_3088_length_912_cov_5.060787_g2476_i0	PRJNA1005695	3088	912	5.060787	46.15437744	Caldilineaceae	475964	Bacteria	Bacteria	985	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g2476	i0	86.304	244.176535087719	920	108	99	10	7	912	1856	941	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	222689	985	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11204422	11204422	PRJNA1005695_P_NODE_29649_length_274_cov_2.149254_g28797_i0	PRJNA1005695	29649	274	2.149254	5.88895596	Caldilinea	233191	Bacteria	Bacteria	285	2.28e-72	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g28797	i0	86.09	129.839416058394	266	35	97	1	9	274	1236	1499	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	35576	285	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11632244	11632244	PRJNA1005695_P_NODE_40730_length_237_cov_2.567073_g39878_i0	PRJNA1005695	40730	237	2.567073	6.08396301	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	246	9.09e-61	NTclustered	gi\|2621704001\|emb\|OY762956.1\|	2026734	g39878	i0	85.654	145.016877637131	237	30	99	4	3	237	1513676	1513442	MAG: Dehalococcoidia bacterium isolate caf6cba7-c187-4a53-abc2-184ab5dfaca7 genome assembly, chromosome: 1	blastn	34369	246	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26749148	26749148	PRJNA1005695_P_NODE_18341_length_353_cov_1.328571_g17489_i0	PRJNA1005695	18341	353	1.328571	4.68985563	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	127	8.59e-33	NR	MBP7212598.1	2024896	g17489	i0	58.8	2.90651558073654	114	47	96.9	0	353	12	133	246	MBP7212598.1 iron-containing alcohol dehydrogenase [Anaerolineaceae bacterium]	diamond	1026	127	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
27887245	27887245	PRJNA1005695_P_NODE_26465_length_291_cov_1.422018_g25613_i0	PRJNA1005695	26465	291	1.422018	4.13807238	Chloroflexia bacterium	2448782	Bacteria	Bacteria	42.4	0.0259	NR	MBA3416150.1	2448782	g25613	i0	40	0.77319587628866	75	40	72.2	2	259	50	7	81	MBA3416150.1 YnfA family protein [Chloroflexia bacterium]	diamond	225	42.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
28076694	28076694	PRJNA1005695_P_NODE_35905_length_250_cov_1.757062_g35053_i0	PRJNA1005695	35905	250	1.757062	4.392655	uncultured Chloroflexi bacterium HF	710736	Bacteria	Bacteria	44.3	0.00171	NR	ADI17967.1	710736	g35053	i0	53.5	0.516	43	20	51.6	0	225	97	1	43	ADI17967.1 hypothetical protein [uncultured Chloroflexi bacterium HF0200_09I09]	diamond	129	44.3	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexi bacterium HF0200_09I09
28202865	28202865	PRJNA1005695_P_NODE_41246_length_232_cov_3.062893_g40394_i0	PRJNA1005695	41246	232	3.062893	7.10591176	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.5	0.00287	NR	NLT42736.1	2052143	g40394	i0	50	0.543103448275862	42	19	51.7	1	146	27	19	60	NLT42736.1 hypothetical protein [Anaerolineae bacterium]	diamond	126	43.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28802726	28802726	PRJNA1005695_P_NODE_13128_length_424_cov_1.760684_g12276_i0	PRJNA1005695	13128	424	1.760684	7.46530016	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0411	NR	HEY8491018.1	2026734	g12276	i0	31.8	0.601415094339623	85	52	56.6	2	19	258	5	88	HEY8491018.1 Hsp20/alpha crystallin family protein [Dehalococcoidia bacterium]	diamond	255	43.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30192391	30192391	PRJNA1005695_P_NODE_40952_length_235_cov_2.635802_g40100_i0	PRJNA1005695	40952	235	2.635802	6.1941347	Anaerolineae bacterium	2052143	Bacteria	Bacteria	40.4	0.0472	NR	NLT42736.1	2052143	g40100	i0	40.4	0.727659574468085	57	25	61.3	2	45	188	4	60	NLT42736.1 hypothetical protein [Anaerolineae bacterium]	diamond	171	40.4	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);;