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

10 rows where bioproject = "PRJNA704949" 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
3253311	3253311	PRJNA704949_P_NODE_929383_length_272_cov_1.860987_g914049_i0	PRJNA704949	929383	272	1.860987	5.06188464	Pseudomonadati	3379134	Bacteria	Bacteria	119	1.56e-29	NR	WP_018128423.1	287535	g914049	i0	61.1	21.6727941176471	90	34	99.3	1	2	271	294	382	WP_018128423.1 beta-ketoacyl-ACP synthase II [Balneola vulgaris]	diamond	5895	120	0.991666666666667	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola vulgaris
9616886	9616886	PRJNA704949_P_NODE_1289448_length_222_cov_1.202312_g1274111_i0	PRJNA704949	1289448	222	1.202312	2.66913264	Balneolaceae bacterium	2053516	Bacteria	Bacteria	109	1.5e-26	NR	MDR9364834.1	2053516	g1274111	i0	79.4	3.43243243243243	63	13	85.1	0	3	191	155	217	MDR9364834.1 IS3 family transposase [Balneolaceae bacterium]	diamond	762	109	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27946865	27946865	PRJNA704949_P_NODE_311125_length_483_cov_1.677419_g296272_i0	PRJNA704949	311125	483	1.677419	8.10193377	Pseudomonadati	3379134	Bacteria	Bacteria	111	2.3199999999999993e-28	NR	WP_103665890.1	1749045	g296272	i0	50.5	4.19875776397516	111	54	68.9	1	483	151	9	118	WP_103665890.1 type II toxin-antitoxin system MqsR family toxin [Gracilimonas amylolytica]	diamond	2028	111	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas amylolytica
28167858	28167858	PRJNA704949_P_NODE_1154605_length_238_cov_1.312169_g1139269_i0	PRJNA704949	1154605	238	1.312169	3.12296222	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	1.79e-20	NR	WP_142453175.1	1302730	g1139269	i0	59.7	8.57142857142857	72	29	90.8	0	216	1	271	342	WP_142453175.1 VPS10 domain-containing protein [Gracilimonas mengyeensis]	diamond	2040	95.1	0.995793901156677	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas mengyeensis
28662617	28662617	PRJNA704949_P_NODE_985567_length_262_cov_5.267606_g970232_i0	PRJNA704949	985567	262	5.267606	13.80112772	Gracilimonas sp. Q87	3384766	Bacteria	Bacteria	99	8.78e-24	NR	WP_411323086.1	3384766	g970232	i0	63.6	0.755725190839695	66	24	75.6	0	225	28	4	69	WP_411323086.1 REP-associated tyrosine transposase [Gracilimonas sp. Q87]	diamond	198	99	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas sp. Q87
29388353	29388353	PRJNA704949_P_NODE_1318629_length_219_cov_0.835294_g1303292_i0	PRJNA704949	1318629	219	0.835294	1.82929386	Balneolaceae bacterium	2053516	Bacteria	Bacteria	42.7	0.0045	NR	MEX2345301.1	2053516	g1303292	i0	54.5	0.602739726027397	44	20	60.3	0	54	185	17	60	MEX2345301.1 helix-turn-helix transcriptional regulator [Balneolaceae bacterium]	diamond	132	42.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
29735180	29735180	PRJNA704949_P_NODE_1198290_length_232_cov_1.989071_g1182953_i0	PRJNA704949	1198290	232	1.989071	4.61464472	Halalkalibaculum sp.	2964618	Bacteria	Bacteria	47.8	5.52e-4	NR	HKL19378.1	2964618	g1182953	i0	38.2	0.879310344827586	68	40	87.9	1	22	225	211	276	HKL19378.1 hypothetical protein [Halalkalibaculum sp.]	diamond	204	47.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum	Halalkalibaculum sp.
29830156	29830156	PRJNA704949_P_NODE_1268151_length_224_cov_1.640000_g1252814_i0	PRJNA704949	1268151	224	1.64	3.6736	Balneola sp.	2024824	Bacteria	Bacteria	40.8	0.0379	NR	MFV1885363.1	2024824	g1252814	i0	29.1	0.736607142857143	55	39	73.7	0	5	169	28	82	MFV1885363.1 DciA family protein [Balneola sp.]	diamond	165	40.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
30556660	30556660	PRJNA704949_P_NODE_1285613_length_222_cov_1.803468_g1270276_i0	PRJNA704949	1285613	222	1.803468	4.00369896	Balneola sp.	2024824	Bacteria	Bacteria	67	3.34e-11	NR	HCT55570.1	2024824	g1270276	i0	55	1.60810810810811	60	27	81.1	0	206	27	43	102	HCT55570.1 hypothetical protein [Balneola sp.]	diamond	357	67	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
32906446	32906446	PRJNA704949_P_NODE_1991860_length_167_cov_1.322034_g1976521_i0	PRJNA704949	1991860	167	1.322034	2.20779678	Pseudomonadati	3379134	Bacteria	Bacteria	45.4	0.0015	NR	WP_069130245.1	1812810	g1976521	i0	70.4	2.38922155688623	27	8	48.5	0	1	81	771	797	WP_069130245.1 alpha-ketoacid dehydrogenase subunit alpha/beta [Rhodohalobacter halophilus]	diamond	399	45.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter halophilus

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);;