metadata: contig_metadata: 10 rows where bioproject = "PRJNA1105232", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA1105232", 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_species
19338439	19338439	PRJNA1105232_S_NODE_4416_length_278_cov_3.406114_g4200_i0	PRJNA1105232	4416	278	3.406114	9.46899692	Anaerolineae bacterium	2052143	Bacteria	Bacteria	107	1.06e-24	NR	HOT91088.1	2052143	g4200	i0	59.8	4.99640287769784	92	36	99.3	1	3	278	388	478	HOT91088.1 S8 family serine peptidase [Anaerolineae bacterium]	diamond	1389	107	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
27004310	27004310	PRJNA1105232_S_NODE_1082_length_473_cov_11.516509_g870_i0	PRJNA1105232	1082	473	11.516509	54.47308757	Anaerolineae bacterium	2052143	Bacteria	Bacteria	127	8.989999999999999e-31	NR	HIE38281.1	2052143	g870	i0	50.6	4.02114164904863	162	70	97	5	471	13	342	502	HIE38281.1 DUF11 domain-containing protein [Anaerolineae bacterium]	diamond	1902	127	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
28922050	28922050	PRJNA1105232_S_NODE_11108_length_193_cov_1.444444_g10892_i0	PRJNA1105232	11108	193	1.444444	2.78777692	Bacteria	2	Bacteria	Bacteria	104	1.09e-24	NR	MBI1880258.1	2026724	g10892	i0	75	13.9274611398964	64	16	99.5	0	193	2	66	129	MBI1880258.1 hydroxymethylglutaryl-CoA reductase [Chloroflexota bacterium]	diamond	2688	105	0.990476190476191	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
29499157	29499157	PRJNA1105232_S_NODE_6430_length_240_cov_2.078534_g6214_i0	PRJNA1105232	6430	240	2.078534	4.9884816	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	6.94e-8	NR	MEM7132212.1	2026724	g6214	i0	50	0.775	62	25	72.5	2	37	210	331	390	MEM7132212.1 hypothetical protein [Chloroflexota bacterium]	diamond	186	58.9	1	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
30122039	30122039	PRJNA1105232_S_NODE_6772_length_235_cov_3.322581_g6556_i0	PRJNA1105232	6772	235	3.322581	7.80806535	Bacillati	1783272	Bacteria	Bacteria	87.4	2.18e-19	NR	MEA2640312.1	2026724	g6556	i0	48.1	1.97872340425532	79	40	99.6	1	1	234	78	156	MEA2640312.1 hypothetical protein [Chloroflexota bacterium]	diamond	465	87.8	0.995444191343964	Bacteria	Bacillati	Chloroflexota			Chloroflexota bacterium
30153514	30153514	PRJNA1105232_S_NODE_632_length_580_cov_6.506591_g426_i0	PRJNA1105232	632	580	6.506591	37.7382278	Chloroflexota	200795	Bacteria	Bacteria	176	6.23e-50	NR	MCC6191654.1	2073117	g426	i0	53.1	7.44827586206897	175	81	90.5	1	580	56	81	254	MCC6191654.1 S8 family serine peptidase [Anaerolineales bacterium]	diamond	4320	176	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineales bacterium
30257616	30257616	PRJNA1105232_S_NODE_14352_length_173_cov_1.258065_g14136_i0	PRJNA1105232	14352	173	1.258065	2.17645245	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	67.8	2.09e-11	NR	HLY26698.1	2952883	g14136	i0	55.6	3.60693641618497	54	22	93.6	1	10	171	358	409	HLY26698.1 cytochrome P450 [Aggregatilineales bacterium]	diamond	624	67.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Aggregatilineales bacterium
30352605	30352605	PRJNA1105232_S_NODE_5192_length_261_cov_2.849057_g4976_i0	PRJNA1105232	5192	261	2.849057	7.43603877	Anaerolineae bacterium	2052143	Bacteria	Bacteria	95.5	1.29e-20	NR	HZY43490.1	2052143	g4976	i0	55.2	4	87	36	100	1	1	261	414	497	HZY43490.1 S8 family serine peptidase [Anaerolineae bacterium]	diamond	1044	95.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
30857493	30857493	PRJNA1105232_S_NODE_5054_length_264_cov_2.413953_g4838_i0	PRJNA1105232	5054	264	2.413953	6.37283592	Anaerolineae bacterium	2052143	Bacteria	Bacteria	48.5	4.41e-4	NR	MCB0164944.1	2052143	g4838	i0	38.8	0.965909090909091	85	44	87.5	3	232	2	428	512	MCB0164944.1 tandem-95 repeat protein [Anaerolineae bacterium]	diamond	255	48.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae		Anaerolineae bacterium
31639131	31639131	PRJNA1105232_S_NODE_1076_length_474_cov_7.129412_g864_i0	PRJNA1105232	1076	474	7.129412	33.79341288	Chloroflexota	200795	Bacteria	Bacteria	154	4.45e-41	NR	MEP7200188.1	2026724	g864	i0	57	3.8987341772151902	149	61	92.4	2	37	474	329	477	MEP7200188.1 S8 family serine peptidase [Chloroflexota bacterium]	diamond	1848	154	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);;