metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA492363" 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
25566258	25566258	PRJNA492363_S_NODE_34385_length_239_cov_1.342697_g33564_i0	PRJNA492363	34385	239	1.342697	3.20904583	Chlorobiota bacterium	2268192	Bacteria	Bacteria	237	5.5300000000000005e-58	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g33564	i0	88.325	1.22175732217573	197	23	82	0	20	216	3137186	3137382	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	292	237	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
25702209	25702209	PRJNA492363_S_NODE_2338_length_591_cov_13392.003774_g1537_i0	PRJNA492363	2338	591	13392.003774	79146.74230434	Chlorobiota bacterium	2268192	Bacteria	Bacteria	183	1.99e-41	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g1537	i0	97.222	104.003384094755	108	3	18	0	400	507	3140224	3140117	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	61466	183	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
25974328	25974328	PRJNA492363_S_NODE_14628_length_261_cov_2.220000_g13807_i0	PRJNA492363	14628	261	2.22	5.7942	Chlorobiota bacterium	2268192	Bacteria	Bacteria	200	8.029999999999999e-47	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g13807	i0	93.382	12.1072796934866	136	8	52	1	106	240	3131526	3131661	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	3160	200	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
26110305	26110305	PRJNA492363_S_NODE_13101_length_272_cov_2.601896_g12280_i0	PRJNA492363	13101	272	2.601896	7.07715712	Chlorobiota bacterium	2268192	Bacteria	Bacteria	254	6.37e-63	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g12280	i0	84.921	0.926470588235294	252	36	92	2	20	270	3138980	3139230	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	252	254	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
26111314	26111314	PRJNA492363_S_NODE_75765_length_219_cov_3.037975_g74944_i0	PRJNA492363	75765	219	3.037975	6.65316525	Chlorobiota bacterium	2268192	Bacteria	Bacteria	243	1.0700000000000001e-59	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g74944	i0	91.061	185.643835616438	179	16	82	0	1	179	3137684	3137506	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	40656	243	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
26382479	26382479	PRJNA492363_S_NODE_1815_length_729_cov_3.531437_g1040_i0	PRJNA492363	1815	729	3.531437	25.74417573	Chlorobium limicola DSM 245	290315	Bacteria	Bacteria	156	5.41e-33	NTclustered	gi\|189339705\|gb\|CP001097.1\|	290315	g1040	i0	86.713	7.39780521262003	143	16	19	3	272	412	1585568	1585427	Chlorobium limicola DSM 245 chromosome, complete genome	blastn	5393	156	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola

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