metadata: contig_metadata: 9 rows where bioproject = "PRJNA565584", tax_clade = "FCB group" and tax

9 rows where bioproject = "PRJNA565584", 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
15162170	15162170	PRJNA565584_P_NODE_146272_length_264_cov_3.329843_g145120_i0	PRJNA565584	146272	264	3.329843	8.79078552	Rhodothermales	1853224	Bacteria	Bacteria	75	5.15e-9	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g145120	i0	93.878	2.38636363636364	49	3	19	0	83	131	3459806	3459758	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	630	75	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
27584906	27584906	PRJNA565584_P_NODE_32184_length_537_cov_1.564655_g31035_i0	PRJNA565584	32184	537	1.564655	8.40219735	Rhodothermales bacterium	2306054	Bacteria	Bacteria	147	1.03e-39	NR	MEZ4702482.1	2306054	g31035	i0	56	6.79329608938547	150	55	83.8	3	534	85	157	295	MEZ4702482.1 carboxylating nicotinate-nucleotide diphosphorylase [Rhodothermales bacterium]	diamond	3648	147	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28027116	28027116	PRJNA565584_P_NODE_83765_length_325_cov_1.115079_g82613_i0	PRJNA565584	83765	325	1.115079	3.62400675	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	44.7	0.0151	NR	HEX9953108.1	2838334	g82613	i0	35	1.69846153846154	80	49	72.9	2	323	87	50	127	HEX9953108.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	552	44.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29321334	29321334	PRJNA565584_P_NODE_126349_length_278_cov_1.126829_g125197_i0	PRJNA565584	126349	278	1.126829	3.13258462	Rhodothermales bacterium	2306054	Bacteria	Bacteria	115	1.38e-29	NR	MDX1532285.1	2306054	g125197	i0	60.9	1.98561151079137	92	36	99.3	0	276	1	27	118	MDX1532285.1 hypothetical protein [Rhodothermales bacterium]	diamond	552	115	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30016383	30016383	PRJNA565584_P_NODE_81331_length_330_cov_0.894942_g80179_i0	PRJNA565584	81331	330	0.894942	2.9533086	Rubrivirga marina	1196024	Bacteria	Bacteria	44.7	0.021	NR	WP_095509985.1	1196024	g80179	i0	40.9	0.6	66	35	60	1	325	128	314	375	WP_095509985.1 endonuclease [Rubrivirga marina]	diamond	198	44.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga marina
30205549	30205549	PRJNA565584_P_NODE_50992_length_416_cov_4.306122_g49841_i0	PRJNA565584	50992	416	4.306122	17.91346752	Rhodothermales bacterium	2306054	Bacteria	Bacteria	50.1	3.19e-4	NR	HYE58369.1	2306054	g49841	i0	72.7	0.771634615384615	33	9	23.8	0	414	316	153	185	HYE58369.1 glycoside hydrolase family 19 protein [Rhodothermales bacterium]	diamond	321	50.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32166029	32166029	PRJNA565584_P_NODE_212658_length_241_cov_1.535714_g211506_i0	PRJNA565584	212658	241	1.535714	3.70107074	Rhodothermales bacterium	2306054	Bacteria	Bacteria	46.6	2.17e-4	NR	HUF10043.1	2306054	g211506	i0	37.3	0.734439834024896	59	36	73.4	1	179	3	10	67	HUF10043.1 tectonin domain-containing protein [Rhodothermales bacterium]	diamond	177	46.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32324340	32324340	PRJNA565584_P_NODE_136379_length_271_cov_1.555556_g135227_i0	PRJNA565584	136379	271	1.555556	4.21555676	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	47.8	9.08e-4	NR	HLT46706.1	2838334	g135227	i0	42.7	0.830258302583026	75	37	83	3	244	20	64	132	HLT46706.1 PQQ-dependent sugar dehydrogenase [Rubricoccaceae bacterium]	diamond	225	47.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32639717	32639717	PRJNA565584_P_NODE_103840_length_293_cov_1.400000_g102688_i0	PRJNA565584	103840	293	1.4	4.102	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	53.5	9.72e-6	NR	NNF57245.1	2026787	g102688	i0	34.7	0.767918088737201	75	47	74.7	2	257	39	150	224	NNF57245.1 T9SS type A sorting domain-containing protein [Rhodothermaceae bacterium]	diamond	225	53.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae 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);;