metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1046144" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1046144" 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
1009487	1009487	PRJNA1046144_P_NODE_8641_length_536_cov_2.965739_g8349_i0	PRJNA1046144	8641	536	2.965739	15.89636104	Pendulispora	3375062	Bacteria	Bacteria	614	5.349999999999998e-171	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g8349	i0	87.337	295.634328358209	537	66	100	2	1	536	7289992	7289457	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	158460	614	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
1009498	1009498	PRJNA1046144_P_NODE_9761_length_506_cov_2.533181_g9468_i0	PRJNA1046144	9761	506	2.533181	12.81789586	Myxococcia	32015	Bacteria	Bacteria	592	2.3599999999999998e-164	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9468	i0	87.921	354.606719367589	505	57	99	4	1	503	3941772	3942274	Labilithrix luteola strain DSM 27648, complete genome	blastn	179431	597	0.991624790619765	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1446996	1446996	PRJNA1046144_P_NODE_40382_length_270_cov_2.348259_g40087_i0	PRJNA1046144	40382	270	2.348259	6.3402993	Labilithrix luteola	1391654	Bacteria	Bacteria	189	1.8099999999999993e-43	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g40087	i0	80	0.962962962962963	260	48	96	3	1	258	8666523	8666266	Labilithrix luteola strain DSM 27648, complete genome	blastn	260	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2284558	2284558	PRJNA1046144_P_NODE_55762_length_235_cov_1.734940_g55467_i0	PRJNA1046144	55762	235	1.73494	4.077109	Myxococcia	32015	Bacteria	Bacteria	350	6.67e-92	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g55467	i0	93.617	277.212765957447	235	14	100	1	1	235	3944632	3944399	Labilithrix luteola strain DSM 27648, complete genome	blastn	65145	350	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11650792	11650792	PRJNA1046144_P_NODE_38010_length_277_cov_2.076923_g37715_i0	PRJNA1046144	38010	277	2.076923	5.75307671	Labilithrix luteola	1391654	Bacteria	Bacteria	329	1.05e-85	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g37715	i0	88.364	138.70036101083	275	30	99	2	5	277	3943227	3942953	Labilithrix luteola strain DSM 27648, complete genome	blastn	38420	329	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12926353	12926353	PRJNA1046144_P_NODE_55911_length_235_cov_1.415663_g55616_i0	PRJNA1046144	55911	235	1.415663	3.32680805	Minicystis rosea	888845	Bacteria	Bacteria	390	3.93e-104	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g55616	i0	96.596	131.310638297872	235	8	100	0	1	235	770148	770382	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	30858	390	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
14201290	14201290	PRJNA1046144_P_NODE_54432_length_238_cov_1.408284_g54137_i0	PRJNA1046144	54432	238	1.408284	3.35171592	Polyangium aurulentum	2567896	Bacteria	Bacteria	346	8.76e-91	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g54137	i0	92.857	217.22268907563	238	17	100	0	1	238	2744011	2744248	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	51699	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
16311814	16311814	PRJNA1046144_P_NODE_62873_length_230_cov_1.664596_g62578_i0	PRJNA1046144	62873	230	1.664596	3.8285708	Haliangium	162027	Bacteria	Bacteria	285	1.86e-72	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g62578	i0	89.13	166.939130434783	230	24	100	1	1	230	847	1075	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	38396	285	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23124156	23124156	PRJNA1046144_P_NODE_17219_length_390_cov_2.451713_g16924_i0	PRJNA1046144	17219	390	2.451713	9.5616807	Pendulispora brunnea	2905690	Bacteria	Bacteria	556	6.48e-154	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g16924	i0	92.347	133.507692307692	392	28	100	2	1	390	7408028	7408419	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	52068	556	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
25235554	25235554	PRJNA1046144_P_NODE_50380_length_247_cov_1.269663_g50085_i0	PRJNA1046144	50380	247	1.269663	3.13606761	Myxococcia	32015	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50085	i0	97.166	203.287449392713	247	7	100	0	1	247	3944346	3944592	Labilithrix luteola strain DSM 27648, complete genome	blastn	50212	418	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);;