metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax_phylum = "Rhodothermota"

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
2190489	2190489	PRJNA939415_P_NODE_20842_length_341_cov_4.414179_g20422_i0	PRJNA939415	20842	341	4.414179	15.05235039	Pseudomonadati	3379134	Bacteria	Bacteria	180	4.079999999999999e-54	NR	WP_094551050.1	716817	g20422	i0	75.9	9.71260997067449	112	27	98.5	0	340	5	150	261	WP_094551050.1 serine O-acetyltransferase EpsC [Rubricoccus marinus]	diamond	3312	181	0.994475138121547	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
27436139	27436139	PRJNA939415_P_NODE_43523_length_290_cov_1.834101_g43101_i0	PRJNA939415	43523	290	1.834101	5.3188929	Rubricoccus marinus	716817	Bacteria	Bacteria	95.1	1.91e-21	NR	WP_094545671.1	716817	g43101	i0	54.8	0.962068965517241	93	42	96.2	0	282	4	28	120	WP_094545671.1 LytR/AlgR family response regulator transcription factor [Rubricoccus marinus]	diamond	279	95.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
28256672	28256672	PRJNA939415_P_NODE_39746_length_295_cov_2.941441_g39324_i0	PRJNA939415	39746	295	2.941441	8.67725095	Rhodothermales bacterium	2306054	Bacteria	Bacteria	134	1.2699999999999998e-35	NR	HEX7071042.1	2306054	g39324	i0	72.2	2.95932203389831	97	27	98.6	0	3	293	84	180	HEX7071042.1 glycolate oxidase subunit GlcE [Rhodothermales bacterium]	diamond	873	134	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28421837	28421837	PRJNA939415_P_NODE_12566_length_436_cov_5.134986_g12147_i0	PRJNA939415	12566	436	5.134986	22.38853896	Pseudomonadati	3379134	Bacteria	Bacteria	88.2	2.54e-17	NR	WP_259125489.1	146919	g12147	i0	37.8	1.4105504587156	111	63	76.4	1	434	102	299	403	WP_259125489.1 glycosyltransferase family 4 protein [Salinibacter ruber]	diamond	615	88.6	0.99548532731377	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
31352358	31352358	PRJNA939415_P_NODE_67636_length_266_cov_2.259067_g67214_i0	PRJNA939415	67636	266	2.259067	6.00911822	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	119	7.949999999999998e-30	NR	WP_412070417.1	3391575	g67214	i0	69	2.94360902255639	87	27	98.1	0	5	265	67	153	WP_412070417.1 glycosyltransferase [Rubrivirga sp. IMCC43871]	diamond	783	119	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
31636926	31636926	PRJNA939415_P_NODE_98536_length_237_cov_2.359756_g98114_i0	PRJNA939415	98536	237	2.359756	5.59262172	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	68.2	1.62e-11	NR	WP_412062145.1	3391614	g98114	i0	43.8	0.924050632911392	73	37	87.3	1	27	233	143	215	WP_412062145.1 LytR/AlgR family response regulator transcription factor [Rubrivirga sp. IMCC45206]	diamond	219	68.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
32308582	32308582	PRJNA939415_P_NODE_40819_length_293_cov_3.527273_g40397_i0	PRJNA939415	40819	293	3.527273	10.33490989	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	2.13e-23	NR	MDX1531592.1	2306054	g40397	i0	77.6	2.38566552901024	58	13	59.4	0	177	4	1	58	MDX1531592.1 large conductance mechanosensitive channel protein MscL [Rhodothermales bacterium]	diamond	699	98.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;