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 = "Chlorobiota"

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
12613357	12613357	PRJNA565584_P_NODE_180650_length_248_cov_1.651429_g179498_i0	PRJNA565584	180650	248	1.651429	4.09554392	Chlorobiota bacterium	2268192	Bacteria	Bacteria	149	6.87e-42	NR	HRK06064.1	2268192	g179498	i0	90.5	1.79032258064516	74	7	89.5	0	1	222	253	326	HRK06064.1 malate dehydrogenase [Chlorobiota bacterium]	diamond	444	149	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
27364169	27364169	PRJNA565584_P_NODE_183323_length_248_cov_0.880000_g182171_i0	PRJNA565584	183323	248	0.88	2.1824	Chlorobium sp.	1095	Bacteria	Bacteria	56.6	4.76e-7	NR	WP_331561153.1	1095	g182171	i0	40.3	0.931451612903226	77	44	90.7	1	23	247	137	213	WP_331561153.1 aldehyde reductase [Chlorobium sp.]	diamond	231	56.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
27458732	27458732	PRJNA565584_P_NODE_133543_length_273_cov_1.530000_g132391_i0	PRJNA565584	133543	273	1.53	4.1769	Chlorobiales bacterium	2723030	Bacteria	Bacteria	124	2.26e-32	NR	MCE1274861.1	2723030	g132391	i0	66.3	2.93406593406593	89	30	97.8	0	3	269	139	227	MCE1274861.1 hypothetical protein [Chlorobiales bacterium]	diamond	801	124	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales			Chlorobiales bacterium
28356250	28356250	PRJNA565584_P_NODE_161606_length_254_cov_2.546961_g160454_i0	PRJNA565584	161606	254	2.546961	6.46928094	Pseudomonadati	3379134	Bacteria	Bacteria	116	2.95e-29	NR	WP_303681409.1	1100	g160454	i0	62.2	23.6692913385827	82	31	96.9	0	3	248	126	207	WP_303681409.1 GDP-L-fucose synthase [Pelodictyon luteolum]	diamond	6012	116	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
28640695	28640695	PRJNA565584_P_NODE_188767_length_247_cov_0.885057_g187615_i0	PRJNA565584	188767	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	124	5.5e-31	NR	MEI8032948.1	2067991	g187615	i0	71.3	19.3967611336032	80	22	97.2	1	243	4	71	149	MEI8032948.1 glutamine synthetase III [Chlorobiaceae bacterium]	diamond	4791	125	0.992	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
30395740	30395740	PRJNA565584_P_NODE_168253_length_251_cov_0.865169_g167101_i0	PRJNA565584	168253	251	0.865169	2.17157419	Chlorobiales bacterium	2723030	Bacteria	Bacteria	76.6	4.75e-14	NR	MCE1272931.1	2723030	g167101	i0	47.1	1.0398406374502	87	42	99.2	2	2	250	174	260	MCE1272931.1 autotransporter outer membrane beta-barrel domain-containing protein [Chlorobiales bacterium]	diamond	261	76.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales			Chlorobiales bacterium
30900939	30900939	PRJNA565584_P_NODE_137854_length_270_cov_1.563452_g136702_i0	PRJNA565584	137854	270	1.563452	4.2213204	Chlorobium phaeovibrioides	1094	Bacteria	Bacteria	112	9.36e-28	NR	WP_151419366.1	1094	g136702	i0	69.7	0.733333333333333	66	20	73.3	0	270	73	265	330	WP_151419366.1 hypothetical protein [Chlorobium phaeovibrioides]	diamond	198	112	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeovibrioides
31388791	31388791	PRJNA565584_P_NODE_132516_length_274_cov_1.099502_g131364_i0	PRJNA565584	132516	274	1.099502	3.01263548	Chlorobiales	191411	Bacteria	Bacteria	139	4.51e-36	NR	PIO47334.1	2033588	g131364	i0	65.9	1.99270072992701	91	31	99.6	0	274	2	382	472	PIO47334.1 MAG: glycogen phosphorylase [[Chlorobium] sp. 445]	diamond	546	139	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae		[Chlorobium] sp. 445
32070913	32070913	PRJNA565584_P_NODE_217798_length_237_cov_2.548780_g216646_i0	PRJNA565584	217798	237	2.54878	6.0406086	Chlorobium ferrooxidans	84205	Bacteria	Bacteria	87	1.47e-18	NR	WP_040433325.1	84205	g216646	i0	54.4	1	79	36	100	0	237	1	102	180	WP_040433325.1 hypothetical protein [Chlorobium ferrooxidans]	diamond	237	87	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium ferrooxidans

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);;