metadata: contig_metadata: 10 rows where bioproject = "PRJNA615351" and tax

10 rows where bioproject = "PRJNA615351" and tax_phylum = "Fibrobacterota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6973961	6973961	PRJNA615351_P_NODE_133266_length_219_cov_1.728261_g119166_i0	PRJNA615351	133266	219	1.728261	3.78489159	Fibrobacter sp.	35828	Bacteria	Bacteria	97.4	1.29e-23	NR	MDO5576348.1	35828	g119166	i0	58.3	4.93150684931507	72	30	98.6	0	218	3	1	72	MDO5576348.1 pantoate--beta-alanine ligase [Fibrobacter sp.]	diamond	1080	97.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
6974236	6974236	PRJNA615351_P_NODE_47026_length_772_cov_11.075984_g35408_i0	PRJNA615351	47026	772	11.075984	85.50659648	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	162	1.22e-45	NR	HEX7510392.1	2663014	g35408	i0	79.2	2.40155440414508	101	21	39.2	0	7	309	101	201	HEX7510392.1 NAD(P)H:quinone oxidoreductase [Chitinivibrionales bacterium]	diamond	1854	162	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
23548365	23548365	PRJNA615351_P_NODE_52799_length_687_cov_9.044479_g40335_i0	PRJNA615351	52799	687	9.044479	62.13557073	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	162	4.9e-46	NR	HEX7510392.1	2663014	g40335	i0	79.2	2.69868995633188	101	21	44.1	0	681	379	101	201	HEX7510392.1 NAD(P)H:quinone oxidoreductase [Chitinivibrionales bacterium]	diamond	1854	162	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
26605362	26605362	PRJNA615351_P_NODE_159521_length_177_cov_1.704225_g145421_i0	PRJNA615351	159521	177	1.704225	3.01647825	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	45.1	5.29e-4	NR	MBN1601512.1	2813024	g145421	i0	33.3	2.79661016949153	54	35	91.5	1	168	7	4	56	MBN1601512.1 hypothetical protein [Chitinispirillaceae bacterium]	diamond	495	45.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae bacterium
28154471	28154471	PRJNA615351_P_NODE_20645_length_1438_cov_4.206700_g14990_i0	PRJNA615351	20645	1438	4.2067	60.492346	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	201	2.4399999999999998e-54	NR	MBD3343658.1	2663014	g14990	i0	33.2	1.43115438108484	343	213	69.3	4	1233	238	224	561	MBD3343658.1 mucoidy inhibitor MuiA family protein [Chitinivibrionales bacterium]	diamond	2058	201	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
28880415	28880415	PRJNA615351_P_NODE_43368_length_837_cov_4.053616_g32401_i0	PRJNA615351	43368	837	4.053616	33.92876592	Candidatus Fibrimonadaceae bacterium	2872174	Bacteria	Bacteria	50.4	0.00539	NR	MDR2593785.1	2872174	g32401	i0	48.3	0.207885304659498	58	27	19.7	1	154	318	410	467	MDR2593785.1 hypothetical protein [Candidatus Fibrimonadaceae bacterium]	diamond	174	50.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales	Candidatus Fibrimonadaceae		Candidatus Fibrimonadaceae bacterium
29922520	29922520	PRJNA615351_P_NODE_128471_length_229_cov_2.268041_g114371_i0	PRJNA615351	128471	229	2.268041	5.19381389	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	42.4	0.0423	NR	MBL8027336.1	2052160	g114371	i0	44	0.655021834061135	50	27	65.5	1	12	161	289	337	MBL8027336.1 hypothetical protein [Fibrobacterota bacterium]	diamond	150	42.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30175226	30175226	PRJNA615351_P_NODE_78312_length_436_cov_71.478803_g64288_i0	PRJNA615351	78312	436	71.478803	311.64758108	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	45.4	0.0274	NR	MFP4415963.1	2813024	g64288	i0	31.8	0.605504587155963	88	53	55.7	2	72	314	277	364	MFP4415963.1 aminopeptidase [Chitinispirillaceae bacterium]	diamond	264	45.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae bacterium
31945103	31945103	PRJNA615351_P_NODE_101817_length_310_cov_1.978182_g87718_i0	PRJNA615351	101817	310	1.978182	6.1323642	Fibrobacter sp.	35828	Bacteria	Bacteria	48.9	5.73e-4	NR	MCQ2091559.1	35828	g87718	i0	32.6	0.919354838709677	95	52	87.1	3	290	21	1566	1653	MCQ2091559.1 cadherin repeat domain-containing protein [Fibrobacter sp.]	diamond	285	48.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32830055	32830055	PRJNA615351_P_NODE_145820_length_196_cov_1.987578_g131720_i0	PRJNA615351	145820	196	1.987578	3.89565288	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	45.8	0.00163	NR	MBO5422628.1	2652288	g131720	i0	33.8	1.08673469387755	71	40	98	1	192	1	45	115	MBO5422628.1 toxin-antitoxin system YwqK family antitoxin [Fibrobacteraceae bacterium]	diamond	213	45.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae 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);;