metadata: contig_metadata: 12 rows where bioproject = "PRJNA946307", tax_clade = "FCB group" and tax

12 rows where bioproject = "PRJNA946307", 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
6363893	6363893	PRJNA946307_P_NODE_118025_length_176_cov_1.535433_g117151_i0	PRJNA946307	118025	176	1.535433	2.70236208	Rhodothermus	29548	Bacteria	Bacteria	121	4.01e-23	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g117151	i0	80.368	2.77840909090909	163	28	91	4	12	172	1665302	1665462	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	489	121	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
13680558	13680558	PRJNA946307_P_NODE_21631_length_275_cov_3.256637_g20758_i0	PRJNA946307	21631	275	3.256637	8.95575175	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	86.3	5.54e-18	NR	HEX8384657.1	2838334	g20758	i0	84	0.545454545454545	50	8	54.5	0	157	8	106	155	HEX8384657.1 alpha/beta hydrolase [Rubricoccaceae bacterium]	diamond	150	86.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
16229539	16229539	PRJNA946307_P_NODE_167133_length_158_cov_4.357798_g166259_i0	PRJNA946307	167133	158	4.357798	6.88532084	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	215	1.57e-51	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g166259	i0	94.326	210.683544303797	141	7	89	1	9	149	1308679	1308540	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	33288	215	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
16563554	16563554	PRJNA946307_P_NODE_8973_length_457_cov_2.213235_g8141_i0	PRJNA946307	8973	457	2.213235	10.11448395	Rubrivirga	1434037	Bacteria	Bacteria	505	2.829999999999999e-138	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g8141	i0	87.788	236.144420131291	434	49	95	4	26	457	1307895	1308326	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	107918	505	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22937646	22937646	PRJNA946307_P_NODE_124278_length_173_cov_2.290323_g123404_i0	PRJNA946307	124278	173	2.290323	3.96225879	Rhodothermus	29548	Bacteria	Bacteria	248	1.73e-61	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g123404	i0	95.513	116.398843930636	156	6	90	1	5	159	1493	1338	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	20137	248	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
22938653	22938653	PRJNA946307_P_NODE_78998_length_195_cov_1.239726_g78124_i0	PRJNA946307	78998	195	1.239726	2.4174657	Rhodothermales	1853224	Bacteria	Bacteria	156	1.25e-33	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g78124	i0	82.632	17.1282051282051	190	19	93	11	1	181	2906396	2906580	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	3340	156	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
27214838	27214838	PRJNA946307_P_NODE_135982_length_168_cov_3.126050_g135108_i0	PRJNA946307	135982	168	3.12605	5.251764	Rhodothermales bacterium	2306054	Bacteria	Bacteria	58.2	2.47e-8	NR	HLA64183.1	2306054	g135108	i0	58.8	3.64285714285714	51	21	91.1	0	3	155	62	112	HLA64183.1 phosphatase PAP2 family protein [Rhodothermales bacterium]	diamond	612	58.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27310133	27310133	PRJNA946307_P_NODE_54963_length_210_cov_2.900621_g54089_i0	PRJNA946307	54963	210	2.900621	6.0913041	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	45.1	0.00336	NR	HEX9953376.1	2838334	g54089	i0	84	0.357142857142857	25	4	35.7	0	16	90	221	245	HEX9953376.1 LytTR family DNA-binding domain-containing protein [Rubricoccaceae bacterium]	diamond	75	45.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29141463	29141463	PRJNA946307_P_NODE_154669_length_164_cov_0.886957_g153795_i0	PRJNA946307	154669	164	0.886957	1.45460948	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	83.6	1.29e-19	NR	HEX8299304.1	2838334	g153795	i0	84.9	1.9390243902439	53	8	97	0	5	163	9	61	HEX8299304.1 heavy-metal-associated domain-containing protein [Rubricoccaceae bacterium]	diamond	318	83.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29835879	29835879	PRJNA946307_P_NODE_64171_length_200_cov_8.311258_g63297_i0	PRJNA946307	64171	200	8.311258	16.622516	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	57.4	5.43e-8	NR	MDX1421222.1	2838334	g63297	i0	93.5	0.945	31	2	46.5	0	194	102	44	74	MDX1421222.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	189	57.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
29835902	29835902	PRJNA946307_P_NODE_91211_length_188_cov_1.971223_g90337_i0	PRJNA946307	91211	188	1.971223	3.70589924	Rhodothermales bacterium	2306054	Bacteria	Bacteria	83.6	4.81e-18	NR	HLA62943.1	2306054	g90337	i0	71.4	1.73936170212766	56	16	89.4	0	173	6	138	193	HLA62943.1 CoA pyrophosphatase [Rhodothermales bacterium]	diamond	327	83.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
31732019	31732019	PRJNA946307_P_NODE_150697_length_165_cov_0.879310_g149823_i0	PRJNA946307	150697	165	0.87931	1.4508615	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	68.6	9.98e-12	NR	HEX9950424.1	2838334	g149823	i0	64.7	0.927272727272727	51	17	90.9	1	164	15	657	707	HEX9950424.1 delta-60 repeat domain-containing protein [Rubricoccaceae bacterium]	diamond	153	68.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae 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);;