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

8 rows where bioproject = "PRJNA637328", 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
8262199	8262199	PRJNA637328_P_NODE_15927_length_254_cov_2.746341_g15450_i0	PRJNA637328	15927	254	2.746341	6.97570614	Bacteria	2	Bacteria	Bacteria	156	7.299999999999999e-46	NR	MBA2469725.1	2448782	g15450	i0	85.7	5.95275590551181	84	12	99.2	0	2	253	116	199	MBA2469725.1 fumarylacetoacetate hydrolase family protein [Chloroflexia bacterium]	diamond	1512	157	0.993630573248408	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
12088451	12088451	PRJNA637328_P_NODE_18730_length_242_cov_4.994819_g18253_i0	PRJNA637328	18730	242	4.994819	12.08746198	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	134	7.57e-27	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g18253	i0	80.663	75.5578512396694	181	28	73	6	67	242	2202322	2202500	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	18285	134	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
26764462	26764462	PRJNA637328_P_NODE_5521_length_374_cov_1.993846_g5046_i0	PRJNA637328	5521	374	1.993846	7.45698404	Anaerolineae bacterium	2052143	Bacteria	Bacteria	87	1.63e-18	NR	MCL6509838.1	2052143	g5046	i0	69.1	0.545454545454545	68	18	52.1	1	373	179	116	183	MCL6509838.1 lytic transglycosylase domain-containing protein [Anaerolineae bacterium]	diamond	204	87	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28470714	28470714	PRJNA637328_P_NODE_20386_length_231_cov_2.620879_g19909_i0	PRJNA637328	20386	231	2.620879	6.05423049	Anaerolineae bacterium	2052143	Bacteria	Bacteria	57.4	2.12e-7	NR	MCL6509813.1	2052143	g19909	i0	66	0.61038961038961	47	15	59.7	1	93	230	11	57	MCL6509813.1 P-type conjugative transfer protein TrbL [Anaerolineae bacterium]	diamond	141	57.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29209401	29209401	PRJNA637328_P_NODE_16009_length_254_cov_1.453659_g15532_i0	PRJNA637328	16009	254	1.453659	3.69229386	Bacteria	2	Bacteria	Bacteria	43.9	0.0151	NR	MBM4421095.1	2026724	g15532	i0	30.1	1.60629921259843	73	43	76.8	1	58	252	44	116	MBM4421095.1 cyclase family protein [Chloroflexota bacterium]	diamond	408	43.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30839288	30839288	PRJNA637328_P_NODE_7434_length_332_cov_3.346290_g6959_i0	PRJNA637328	7434	332	3.34629	11.1096828	Chloroflexota bacterium	2026724	Bacteria	Bacteria	81.3	3.31e-15	NR	MDQ3928124.1	2026724	g6959	i0	39.8	3.21686746987952	118	54	91.3	1	1	303	217	334	MDQ3928124.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	1068	81.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31154906	31154906	PRJNA637328_P_NODE_11435_length_281_cov_2.564655_g10959_i0	PRJNA637328	11435	281	2.564655	7.20668055	Bellilinea sp.	2838785	Bacteria	Bacteria	188	2.41e-54	NR	HML40793.1	2838785	g10959	i0	97.8	0.99288256227758	93	2	99.3	0	1	279	187	279	HML40793.1 DNA helicase RecQ [Bellilinea sp.]	diamond	279	188	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
31250004	31250004	PRJNA637328_P_NODE_13195_length_268_cov_2.082192_g12719_i0	PRJNA637328	13195	268	2.082192	5.58027456	Anaerolineae bacterium	2052143	Bacteria	Bacteria	92.4	1.63e-19	NR	MCL6509831.1	2052143	g12719	i0	68.9	0.682835820895522	61	19	68.3	0	84	266	1	61	MCL6509831.1 ssDNA-binding domain-containing protein [Anaerolineae bacterium]	diamond	183	92.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);;