metadata: contig_metadata: 7 rows where bioproject = "PRJNA312899", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA312899", 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
5483368	5483368	PRJNA312899_P_NODE_61385_length_214_cov_6.157576_g60943_i0	PRJNA312899	61385	214	6.157576	13.17721264	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	255	1.34e-63	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g60943	i0	88.128	97.2476635514019	219	20	100	4	1	214	1309237	1309020	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	20811	255	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
9307285	9307285	PRJNA312899_P_NODE_27568_length_354_cov_6.068852_g27126_i0	PRJNA312899	27568	354	6.068852	21.48373608	Pseudomonadati	3379134	Bacteria	Bacteria	101	2.51e-22	NR	WP_098061350.1	1469170	g27126	i0	54	3.27118644067797	100	40	79.7	2	351	70	435	534	WP_098061350.1 sialidase family protein [Longimonas halophila]	diamond	1158	102	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Longimonas	Longimonas halophila
10583546	10583546	PRJNA312899_P_NODE_47929_length_253_cov_1.980392_g47487_i0	PRJNA312899	47929	253	1.980392	5.01039176	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	313	9.539999999999999e-81	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g47487	i0	88.933	2	253	28	100	0	1	253	2403367	2403619	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	506	313	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
27358944	27358944	PRJNA312899_P_NODE_85223_length_168_cov_1.714286_g84781_i0	PRJNA312899	85223	168	1.714286	2.88000048	Rhodothermales bacterium	2306054	Bacteria	Bacteria	107	2.47e-26	NR	HEX7070170.1	2306054	g84781	i0	87.3	0.982142857142857	55	7	98.2	0	3	167	195	249	HEX7070170.1 amidohydrolase family protein [Rhodothermales bacterium]	diamond	165	107	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29473938	29473938	PRJNA312899_P_NODE_16750_length_461_cov_6.031553_g16311_i0	PRJNA312899	16750	461	6.031553	27.80545933	Rubricoccus marinus	716817	Bacteria	Bacteria	120	2.1e-28	NR	WP_094552099.1	716817	g16311	i0	50.3	0.956616052060738	147	72	95.7	1	445	5	299	444	WP_094552099.1 relaxase/mobilization nuclease domain-containing protein [Rubricoccus marinus]	diamond	441	120	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
29758296	29758296	PRJNA312899_P_NODE_45691_length_260_cov_7.265403_g45249_i0	PRJNA312899	45691	260	7.265403	18.8900478	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	68.9	1.38e-11	NR	MDX1438758.1	2838334	g45249	i0	72.1	0.992307692307692	43	12	49.6	0	4	132	220	262	MDX1438758.1 TatD family hydrolase [Rubricoccaceae bacterium]	diamond	258	68.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32666453	32666453	PRJNA312899_P_NODE_79380_length_180_cov_1.152672_g78938_i0	PRJNA312899	79380	180	1.152672	2.0748096	Rhodothermales bacterium	2306054	Bacteria	Bacteria	95.9	2.0500000000000003e-21	NR	HYE57152.1	2306054	g78938	i0	69	0.966666666666667	58	18	96.7	0	177	4	202	259	HYE57152.1 beta-galactosidase [Rhodothermales bacterium]	diamond	174	95.9	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);;