metadata: contig_metadata: 10 rows where bioproject = "PRJEB4632" and tax

10 rows where bioproject = "PRJEB4632" 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
2265284	2265284	PRJEB4632_P_NODE_522_length_308_cov_1.404255_g484_i0	PRJEB4632	522	308	1.404255	4.3251054	root	1	Root_unresolved	Root_unresolved	320	7.14e-83	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g484	i0	85.437	234.516233766234	309	43	100	2	1	308	9037910	9038217	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	72231	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
4817903	4817903	PRJEB4632_P_NODE_124_length_744_cov_4.818182_g88_i0	PRJEB4632	124	744	4.818182	35.84727408	Sorangium	39643	Bacteria	Bacteria	976	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g88	i0	90.349	132.638440860215	746	69	100	3	1	744	3690916	3690172	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	98683	976	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12469117	12469117	PRJEB4632_P_NODE_270_length_454_cov_2.960630_g232_i0	PRJEB4632	270	454	2.96063	13.4412602	root	1	Root_unresolved	Root_unresolved	488	2.8299999999999995e-133	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g232	i0	86.334	112.735682819383	461	48	100	14	1	454	4849288	4849740	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	51182	488	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15363790	15363790	PRJEB4632_P_NODE_473_length_321_cov_2.975806_g435_i0	PRJEB4632	473	321	2.975806	9.55233726	Labilithrix luteola	1391654	Bacteria	Bacteria	544	4.08e-150	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g435	i0	97.196	146.230529595016	321	9	100	0	1	321	3944268	3943948	Labilithrix luteola strain DSM 27648, complete genome	blastn	46940	544	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17913100	17913100	PRJEB4632_P_NODE_955_length_243_cov_0.900000_g917_i0	PRJEB4632	955	243	0.9	2.187	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	185	2.0699999999999998e-42	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g917	i0	80.992	159.827160493827	242	38	99	3	1	241	2385083	2384849	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	38838	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
18841717	18841717	PRJEB4632_P_NODE_255_length_469_cov_3.189394_g217_i0	PRJEB4632	255	469	3.189394	14.95825786	Sorangium	39643	Bacteria	Bacteria	549	1.3299999999999994e-151	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g217	i0	87.949	143.944562899787	473	47	99	8	2	469	11965275	11964808	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	67510	549	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20116595	20116595	PRJEB4632_P_NODE_976_length_242_cov_0.911243_g938_i0	PRJEB4632	976	242	0.911243	2.20520806	Sorangium	39643	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g938	i0	87.967	32.9049586776859	241	26	99	3	1	240	11963879	11964117	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	7963	281	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21738287	21738287	PRJEB4632_P_NODE_338_length_393_cov_3.553125_g300_i0	PRJEB4632	338	393	3.553125	13.96378125	Labilithrix luteola	1391654	Bacteria	Bacteria	555	2.3499999999999994e-153	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g300	i0	92.112	175.880407124682	393	31	100	0	1	393	3944268	3943876	Labilithrix luteola strain DSM 27648, complete genome	blastn	69121	555	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22666946	22666946	PRJEB4632_P_NODE_998_length_238_cov_2.387879_g960_i0	PRJEB4632	998	238	2.387879	5.68315202	Sorangium	39643	Bacteria	Bacteria	248	2.54e-61	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g960	i0	87.215	51.7142857142857	219	26	91	1	22	238	1556	1774	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	12308	248	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
30033601	30033601	PRJEB4632_P_NODE_951_length_243_cov_0.905882_g913_i0	PRJEB4632	951	243	0.905882	2.20129326	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	58.2	1.31e-7	NR	NOU34320.1	2268199	g913	i0	56.3	0.592592592592593	48	21	59.3	0	80	223	361	408	NOU34320.1 hypothetical protein [Polyangiaceae bacterium]	diamond	144	58.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium

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