metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax_phylum = "Myxococcota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3184901	3184901	PRJNA667863_P_NODE_18543_length_227_cov_2.675325_g18509_i0	PRJNA667863	18543	227	2.675325	6.07298775	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g18509	i0	92.105	0.167400881057269	38	2	17	1	110	147	563091	563055	Corallococcus sp. NCRR chromosome, complete genome	blastn	38	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
10838017	10838017	PRJNA667863_P_NODE_10489_length_255_cov_1.439560_g10455_i0	PRJNA667863	10489	255	1.43956	3.670878	Myxococcus stipitatus	83455	Bacteria	Bacteria	102	2.27e-17	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g10455	i0	87.64	94.2	89	10	35	1	127	214	5311730	5311642	Myxococcus stipitatus DSM 14675, complete genome	blastn	24021	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
10838253	10838253	PRJNA667863_P_NODE_8829_length_265_cov_1.234375_g8795_i0	PRJNA667863	8829	265	1.234375	3.27109375	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	152	2.3199999999999995e-32	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g8795	i0	80.097	64.5849056603774	206	39	77	2	3	207	7393459	7393663	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	17115	152	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13387923	13387923	PRJNA667863_P_NODE_10951_length_252_cov_2.184358_g10917_i0	PRJNA667863	10951	252	2.184358	5.50458216	Sorangium cellulosum	56	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g10917	i0	82.677	97.5119047619048	254	40	100	4	1	252	8655204	8655455	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	24573	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14662844	14662844	PRJNA667863_P_NODE_10792_length_253_cov_1.711111_g10758_i0	PRJNA667863	10792	253	1.711111	4.32911083	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	233	7.64e-57	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g10758	i0	83.806	93.4940711462451	247	38	97	2	1	246	2005238	2005483	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	23654	233	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
17741486	17741486	PRJNA667863_P_NODE_2674_length_362_cov_4.325260_g2640_i0	PRJNA667863	2674	362	4.32526	15.6574412	root	1	Root_unresolved	Root_unresolved	457	6.23e-124	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g2640	i0	89.532	138.483425414365	363	35	100	3	1	362	1227	867	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	50131	459	0.995642701525055	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
25390061	25390061	PRJNA667863_P_NODE_7760_length_272_cov_1.809045_g7726_i0	PRJNA667863	7760	272	1.809045	4.9206024	Sorangium	39643	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g7726	i0	100	0.205882352941176	28	0	10	0	24	51	1152008	1151981	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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