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

10 rows where bioproject = "PRJNA1120060" and tax_phylum = "Balneolota"

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
13779619	13779619	PRJNA1120060_P_NODE_2727431_length_248_cov_0.885714_g2709348_i0	PRJNA1120060	2727431	248	0.885714	2.19657072	Pseudomonadati	3379134	Bacteria	Bacteria	72	7.88e-13	NR	WP_350213939.1	1974203	g2709348	i0	63.8	1.1491935483871	47	17	56.9	0	245	105	144	190	WP_350213939.1 IS3 family transposase [Gracilimonas sp.]	diamond	285	72	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sp.
14283977	14283977	PRJNA1120060_P_NODE_2724052_length_248_cov_0.891429_g2705969_i0	PRJNA1120060	2724052	248	0.891429	2.21074392	Balneolaceae bacterium	2053516	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2626222457\|emb\|OY829281.1\|	2053516	g2705969	i0	100	0.112903225806452	28	0	11	0	26	53	2252214	2252187	MAG: Balneolaceae bacterium isolate c63fa63d-abcb-44aa-a049-ecdd770e9aed genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
20642955	20642955	PRJNA1120060_P_NODE_1711177_length_284_cov_3.763033_g1693171_i0	PRJNA1120060	1711177	284	3.763033	10.68701372	Balneola sp.	2024824	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2021960826\|gb\|CP051255.1\|	2024824	g1693171	i0	100	0.0985915492957746	28	0	10	0	221	248	3144215	3144242	MAG: Balneola sp. isolate EhC07 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
20668155	20668155	PRJNA1120060_P_NODE_491197_length_368_cov_3.376271_g473587_i0	PRJNA1120060	491197	368	3.376271	12.42467728	Balneola sp.	2024824	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2021960826\|gb\|CP051255.1\|	2024824	g473587	i0	100	0.0760869565217391	28	0	8	0	144	171	3860085	3860058	MAG: Balneola sp. isolate EhC07 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
26752813	26752813	PRJNA1120060_P_NODE_3484541_length_208_cov_5.133333_g3466415_i0	PRJNA1120060	3484541	208	5.133333	10.67733264	Fodinibius roseus	1194090	Bacteria	Bacteria	42	0.0261	NR	SHF02451.1	1194090	g3466415	i0	34.6	1.5	52	29	67.8	1	200	60	69	120	SHF02451.1 hypothetical protein SAMN05443144_1059 [Fodinibius roseus]	diamond	312	42	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
27227184	27227184	PRJNA1120060_P_NODE_2771663_length_247_cov_0.873563_g2753579_i0	PRJNA1120060	2771663	247	0.873563	2.15770061	Rhodohalobacter halophilus	1812810	Bacteria	Bacteria	42.4	0.0379	NR	WP_069132001.1	1812810	g2753579	i0	41.9	0.522267206477733	43	24	52.2	1	157	29	124	165	WP_069132001.1 peroxidase-related enzyme [Rhodohalobacter halophilus]	diamond	129	42.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter halophilus
27953176	27953176	PRJNA1120060_P_NODE_1975485_length_273_cov_12.730000_g1957457_i0	PRJNA1120060	1975485	273	12.73	34.7529	Balneolaceae bacterium	2053516	Bacteria	Bacteria	173	5.519999999999999e-48	NR	MBN2732068.1	2053516	g1957457	i0	91.2	2	91	8	100	0	273	1	562	652	MBN2732068.1 excinuclease ABC subunit UvrA [Balneolaceae bacterium]	diamond	546	173	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
28458452	28458452	PRJNA1120060_P_NODE_1952386_length_274_cov_5.134328_g1934360_i0	PRJNA1120060	1952386	274	5.134328	14.06805872	Fodinibius salicampi	1920655	Bacteria	Bacteria	43.5	0.0301	NR	WP_265787823.1	1920655	g1934360	i0	41	0.667883211678832	61	33	66.8	1	217	35	480	537	WP_265787823.1 exodeoxyribonuclease V subunit beta [Fodinibius salicampi]	diamond	183	43.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi
30194987	30194987	PRJNA1120060_P_NODE_2046252_length_271_cov_1.318182_g2028215_i0	PRJNA1120060	2046252	271	1.318182	3.57227322	Balneolaceae bacterium	2053516	Bacteria	Bacteria	42.4	0.0325	NR	MDZ7693558.1	2053516	g2028215	i0	36.2	0.642066420664207	58	34	64.2	1	46	219	34	88	MDZ7693558.1 RNA-binding protein [Balneolaceae bacterium]	diamond	174	42.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30827083	30827083	PRJNA1120060_P_NODE_2182074_length_265_cov_4.619792_g2164022_i0	PRJNA1120060	2182074	265	4.619792	12.2424488	Balneolaceae bacterium	2053516	Bacteria	Bacteria	43.5	0.00705	NR	MBO6793897.1	2053516	g2164022	i0	35.8	0.6	53	34	60	0	219	61	8	60	MBO6793897.1 hypothetical protein [Balneolaceae bacterium]	diamond	159	43.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae 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);;