metadata: contig_metadata: 8 rows where bioproject = "PRJNA529241", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA529241", tax_clade = "FCB group" 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
3052423	3052423	PRJNA529241_P_NODE_479383_length_151_cov_7.114035_g477061_i0	PRJNA529241	479383	151	7.114035	10.74219285	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	76.8	7.31e-10	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g477061	i0	92.453	10.5099337748344	53	4	35	0	99	151	474694	474642	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	1587	76.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
6219475	6219475	PRJNA529241_P_NODE_410385_length_171_cov_3.932836_g408063_i0	PRJNA529241	410385	171	3.932836	6.72514956	Bacteria	2	Bacteria	Bacteria	89.8	1.09e-13	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g408063	i0	94.737	4.94736842105263	57	3	33	0	111	167	1348097	1348153	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	846	89.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
14529038	14529038	PRJNA529241_P_NODE_339372_length_173_cov_3.029412_g337050_i0	PRJNA529241	339372	173	3.029412	5.24088276	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	75	3.1e-9	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g337050	i0	86.957	3.08670520231214	69	6	40	2	2	70	1611084	1611149	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	534	75	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
14531269	14531269	PRJNA529241_P_NODE_69112_length_253_cov_7.898148_g66790_i0	PRJNA529241	69112	253	7.898148	19.98231444	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	99	2.91e-16	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g66790	i0	90.541	0.561264822134387	74	7	29	0	161	234	3278042	3278115	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	142	99	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
23452929	23452929	PRJNA529241_P_NODE_408699_length_171_cov_6.373134_g406377_i0	PRJNA529241	408699	171	6.373134	10.89805914	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	87.9	3.93e-13	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g406377	i0	80	3.59649122807018	120	22	70	2	3	121	1994563	1994445	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	615	87.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
27123951	27123951	PRJNA529241_P_NODE_87622_length_230_cov_3.528497_g85300_i0	PRJNA529241	87622	230	3.528497	8.1155431	FCB group	1783270	Bacteria	Bacteria	47.4	6.18e-4	NR	MEF8796398.1	1885341	g85300	i0	35.1	2.66086956521739	74	46	96.5	1	224	3	157	228	MEF8796398.1 class I SAM-dependent methyltransferase [Salinivenus sp.]	diamond	612	47.8	0.99163179916318	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinivenus	Salinivenus sp.
29271389	29271389	PRJNA529241_P_NODE_540809_length_151_cov_3.192982_g538487_i0	PRJNA529241	540809	151	3.192982	4.82140282	FCB group	1783270	Bacteria	Bacteria	56.2	2.3e-8	NR	WP_095509659.1	1196024	g538487	i0	100	3.17880794701987	25	0	49.7	0	76	150	31	55	WP_095509659.1 GPW/gp25 family protein [Rubrivirga marina]	diamond	480	56.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga marina
31578077	31578077	PRJNA529241_P_NODE_371836_length_173_cov_2.654412_g369514_i0	PRJNA529241	371836	173	2.654412	4.59213276	Pseudomonadati	3379134	Bacteria	Bacteria	42.7	0.0143	NR	MFT5126450.1	2306054	g369514	i0	75	2.11560693641619	24	6	41.6	0	75	4	176	199	MFT5126450.1 D-glycerate 3-kinase [Rhodothermales bacterium]	diamond	366	42.7	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);;