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

10 rows where 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
5084545	5084545	PRJNA939415_P_NODE_11044_length_468_cov_1.496203_g10626_i0	PRJNA939415	11044	468	1.496203	7.00223004	Rhodothermales	1853224	Bacteria	Bacteria	89.8	3.47e-13	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g10626	i0	80	0.576923076923077	135	16	27	9	339	466	2387855	2387725	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	270	89.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
5084887	5084887	PRJNA939415_P_NODE_57984_length_275_cov_10.529703_g57562_i0	PRJNA939415	57984	275	10.529703	28.95668325	Rhodothermus	29548	Bacteria	Bacteria	193	1.43e-44	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g57562	i0	81.513	5.49090909090909	238	40	86	3	8	243	197329	197564	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	1510	193	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
21317622	21317622	PRJNA939415_P_NODE_43037_length_290_cov_3.764977_g42615_i0	PRJNA939415	43037	290	3.764977	10.9184333	Rhodothermales bacterium	2306054	Bacteria	Bacteria	87.9	7.36e-13	NTclustered	gi\|2891482048\|emb\|OZ219799.1\|	2306054	g42615	i0	91.935	0.213793103448276	62	5	21	0	108	169	1327777	1327838	MAG: Rhodothermales bacterium isolate da3e7c24-c5f3-4507-9669-19e8aa5a93cb genome assembly, chromosome: 1	blastn	62	87.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
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);;