metadata: contig_metadata: 5 rows where bioproject = "PRJNA1011844" and tax

5 rows where bioproject = "PRJNA1011844" 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
16732794	16732794	PRJNA1011844_P_NODE_119074_length_285_cov_1.386792_g110497_i0	PRJNA1011844	119074	285	1.386792	3.9523572	uncultured Chlorobiota bacterium	156405	Bacteria	Bacteria	457	4.7699999999999996e-124	NTclustered	gi\|77403655\|dbj\|AB161089.1\|	156405	g110497	i0	97.388	123.6	268	7	94	0	5	272	268	1	Uncultured Chlorobi bacterium gene for 16S ribosomal RNA, partial sequence, clone:3D9	blastn	35226	457	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					uncultured Chlorobiota bacterium
23109087	23109087	PRJNA1011844_P_NODE_23939_length_1122_cov_10.122021_g18166_i0	PRJNA1011844	23939	1122	10.122021	113.56907562	Prosthecochloris sp.	290513	Bacteria	Bacteria	285	7.329999999999999e-89	NR	WP_294348178.1	290513	g18166	i0	48.5	2.62566844919786	328	143	86.4	8	1098	130	137	443	WP_294348178.1 deoxyribodipyrimidine photo-lyase [Prosthecochloris sp.]	diamond	2946	285	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp.
26813278	26813278	PRJNA1011844_P_NODE_19761_length_1263_cov_10.695798_g14731_i0	PRJNA1011844	19761	1263	10.695798	135.08792874	Prosthecochloris sp.	290513	Bacteria	Bacteria	298	2.78e-93	NR	WP_294348178.1	290513	g14731	i0	48.2	11.7719714964371	328	145	77	7	25	996	137	443	WP_294348178.1 deoxyribodipyrimidine photo-lyase [Prosthecochloris sp.]	diamond	14868	298	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp.
30414149	30414149	PRJNA1011844_P_NODE_117713_length_287_cov_1.738318_g109137_i0	PRJNA1011844	117713	287	1.738318	4.98897266	Chlorobium sp.	1095	Bacteria	Bacteria	110	1.98e-26	NR	TLU55303.1	1095	g109137	i0	61.4	0.9198606271777	88	34	92	0	267	4	1	88	TLU55303.1 MAG: LegC family aminotransferase [Chlorobium sp.]	diamond	264	110	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
30501033	30501033	PRJNA1011844_P_NODE_150593_length_248_cov_0.880000_g142014_i0	PRJNA1011844	150593	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	101	6.85e-23	NR	MEI6640133.1	1095	g142014	i0	55	5.83064516129032	80	36	96.8	0	248	9	41	120	MEI6640133.1 hypothetical protein [Chlorobium sp.]	diamond	1446	101	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.

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