metadata: contig_metadata: 14 rows where bioproject = "PRJNA529224" and tax

14 rows where bioproject = "PRJNA529224" 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
1773178	1773178	PRJNA529224_S_NODE_582_length_255_cov_2354.778761_g575_i0	PRJNA529224	582	255	2354.778761	6004.68584055	Pendulispora albinea	2741071	Bacteria	Bacteria	355	1.58e-93	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g575	i0	91.765	256.039215686275	255	21	100	0	1	255	3590303	3590557	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	65290	355	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
4324921	4324921	PRJNA529224_S_NODE_24_length_648_cov_60.239095_g20_i0	PRJNA529224	24	648	60.239095	390.3493356	Labilithrix luteola	1391654	Bacteria	Bacteria	830	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g20	i0	89.771	128.953703703704	655	57	100	7	1	648	7090717	7090066	Labilithrix luteola strain DSM 27648, complete genome	blastn	83562	830	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4324929	4324929	PRJNA529224_S_NODE_684_length_238_cov_254.928230_g677_i0	PRJNA529224	684	238	254.92823	606.7291874	Labilithrix luteola	1391654	Bacteria	Bacteria	207	4.31e-49	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g677	i0	83.117	234.760504201681	231	35	96	4	10	238	3941942	3942170	Labilithrix luteola strain DSM 27648, complete genome	blastn	55873	207	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4324934	4324934	PRJNA529224_S_NODE_84_length_476_cov_14.805369_g79_i0	PRJNA529224	84	476	14.805369	70.47355644	Labilithrix luteola	1391654	Bacteria	Bacteria	385	4.02e-102	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g79	i0	85.156	101.674369747899	384	47	80	10	98	476	3942332	3941954	Labilithrix luteola strain DSM 27648, complete genome	blastn	48397	385	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5601786	5601786	PRJNA529224_S_NODE_25_length_647_cov_63.328479_g21_i0	PRJNA529224	25	647	63.328479	409.73525913	Polyangium aurulentum	2567896	Bacteria	Bacteria	699	0	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g21	i0	86.196	127.106646058733	652	83	100	7	1	647	11727735	11727086	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	82238	699	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
6875674	6875674	PRJNA529224_S_NODE_26_length_647_cov_62.255663_g22_i0	PRJNA529224	26	647	62.255663	402.79413961	Labilithrix luteola	1391654	Bacteria	Bacteria	706	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22	i0	86.474	116.789799072643	658	72	100	16	1	647	7915862	7915211	Labilithrix luteola strain DSM 27648, complete genome	blastn	75563	706	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10043038	10043038	PRJNA529224_S_NODE_908_length_214_cov_59.594595_g901_i0	PRJNA529224	908	214	59.594595	127.5324333	Pendulispora	3375062	Bacteria	Bacteria	302	1.7e-77	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g901	i0	92.056	138.827102803738	214	17	100	0	1	214	7287692	7287905	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	29709	302	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11976744	11976744	PRJNA529224_S_NODE_30_length_622_cov_45.951096_g25_i0	PRJNA529224	30	622	45.951096	285.81581712	Labilithrix luteola	1391654	Bacteria	Bacteria	715	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g25	i0	87.52	143.551446945338	633	61	99	14	1	620	7089940	7089313	Labilithrix luteola strain DSM 27648, complete genome	blastn	89289	715	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14526885	14526885	PRJNA529224_S_NODE_112_length_445_cov_17.257212_g105_i0	PRJNA529224	112	445	17.257212	76.7945934	Pendulispora albinea	2741071	Bacteria	Bacteria	366	1.3499999999999996e-96	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g105	i0	81.779	111.802247191011	461	62	99	15	3	445	7191904	7191448	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	49752	366	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
17075317	17075317	PRJNA529224_S_NODE_854_length_218_cov_42.322751_g847_i0	PRJNA529224	854	218	42.322751	92.26359718	Pendulispora brunnea	2905690	Bacteria	Bacteria	220	4.99e-53	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g847	i0	84.932	387.288990825688	219	31	100	2	1	218	7409287	7409504	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	84429	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
18349496	18349496	PRJNA529224_S_NODE_1635_length_163_cov_108.522388_g1628_i0	PRJNA529224	1635	163	108.522388	176.89149244	Pendulispora rubella	2741070	Bacteria	Bacteria	193	7.669999999999999e-45	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g1628	i0	88.272	300.067484662577	162	17	99	2	1	161	7287219	7287059	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	48911	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21516441	21516441	PRJNA529224_S_NODE_1637_length_163_cov_97.746269_g1630_i0	PRJNA529224	1637	163	97.746269	159.32641847	Sorangium	39643	Bacteria	Bacteria	189	9.92e-44	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g1630	i0	88.535	238.386503067485	157	16	97	2	1	155	3692237	3692393	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	38857	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21516457	21516457	PRJNA529224_S_NODE_397_length_301_cov_2018.632353_g390_i0	PRJNA529224	397	301	2018.632353	6076.08338253	Polyangiales	3031712	Bacteria	Bacteria	401	2.4099999999999992e-107	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g390	i0	90.728	269.953488372093	302	26	100	2	1	301	8615058	8615358	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	81256	401	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
25340871	25340871	PRJNA529224_S_NODE_620_length_247_cov_770.596330_g613_i0	PRJNA529224	620	247	770.59633	1903.3729351	Sorangium	39643	Bacteria	Bacteria	279	9.41e-71	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g613	i0	87.2	456.931174089069	250	27	100	3	1	247	3691414	3691167	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	112862	279	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);;