metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA395690" 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
4238616	4238616	PRJNA395690_P_NODE_17224_length_195_cov_2.095890_g17072_i0	PRJNA395690	17224	195	2.09589	4.0869855	Labilithrix luteola	1391654	Bacteria	Bacteria	272	1.19e-68	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17072	i0	91.837	211.85641025641	196	14	100	2	1	195	3942281	3942087	Labilithrix luteola strain DSM 27648, complete genome	blastn	41312	272	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6789343	6789343	PRJNA395690_P_NODE_19846_length_187_cov_1.376812_g19694_i0	PRJNA395690	19846	187	1.376812	2.57463844	Polyangium aurulentum	2567896	Bacteria	Bacteria	180	7.04e-41	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g19694	i0	85.227	0.941176470588235	176	24	94	2	1	175	11485869	11485695	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	176	180	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
8064834	8064834	PRJNA395690_P_NODE_1527_length_631_cov_33.216495_g1384_i0	PRJNA395690	1527	631	33.216495	209.59608345	Labilithrix luteola	1391654	Bacteria	Bacteria	887	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1384	i0	92.089	137.408874801902	632	46	99	4	1	630	7090688	7090059	Labilithrix luteola strain DSM 27648, complete genome	blastn	86705	887	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10007098	10007098	PRJNA395690_P_NODE_27008_length_170_cov_1.264463_g26856_i0	PRJNA395690	27008	170	1.264463	2.1495871	Stigmatella	40	Bacteria	Bacteria	257	2.81e-64	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g26856	i0	94.118	188.988235294118	170	9	100	1	1	170	740	572	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	32128	257	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
13165434	13165434	PRJNA395690_P_NODE_28051_length_167_cov_1.703390_g27899_i0	PRJNA395690	28051	167	1.70339	2.8446613	Pendulispora brunnea	2905690	Bacteria	Bacteria	224	2.81e-54	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g27899	i0	91.411	99.8562874251497	163	14	99	0	4	166	7408347	7408185	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	16676	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
14440594	14440594	PRJNA395690_P_NODE_30532_length_165_cov_1.724138_g30380_i0	PRJNA395690	30532	165	1.724138	2.8448277	Pendulispora albinea	2741071	Bacteria	Bacteria	233	4.5899999999999994e-57	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g30380	i0	92.593	293.042424242424	162	12	98	0	4	165	11179297	11179136	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	48352	233	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
14440723	14440723	PRJNA395690_P_NODE_6512_length_315_cov_2.864662_g6360_i0	PRJNA395690	6512	315	2.864662	9.0236853	Corallococcus exercitus	2316736	Bacteria	Bacteria	167	1.01e-36	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g6360	i0	80.617	41.7619047619048	227	35	71	9	45	267	88212	88433	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	13155	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
19537657	19537657	PRJNA395690_P_NODE_35456_length_161_cov_1.419643_g35304_i0	PRJNA395690	35456	161	1.419643	2.28562523	Corallococcus exercitus	2316736	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g35304	i0	99.379	92.1863354037267	161	1	100	0	1	161	87301	87461	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	14842	292	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
24638184	24638184	PRJNA395690_P_NODE_480_length_1109_cov_5.869811_g403_i0	PRJNA395690	480	1109	5.869811	65.09620399	Labilithrix luteola	1391654	Bacteria	Bacteria	1596	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g403	i0	92.646	159.011722272317	1115	73	100	5	1	1109	3941792	3942903	Labilithrix luteola strain DSM 27648, complete genome	blastn	176344	1596	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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