metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA674048" 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
2441520	2441520	PRJNA674048_P_NODE_5842_length_423_cov_3.877005_g5639_i0	PRJNA674048	5842	423	3.877005	16.39973115	Pendulispora	3375062	Bacteria	Bacteria	224	8.159999999999999e-54	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g5639	i0	85.586	49.1725768321513	222	22	50	6	175	386	2910084	2909863	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	20800	226	0.991150442477876	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
3194083	3194083	PRJNA674048_P_NODE_9263_length_312_cov_5.619772_g9060_i0	PRJNA674048	9263	312	5.619772	17.53368864	Pendulispora albinea	2741071	Bacteria	Bacteria	442	1.4799999999999995e-119	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g9060	i0	92.308	258.599358974359	312	22	99	2	3	312	3590691	3590380	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	80683	442	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
9571611	9571611	PRJNA674048_P_NODE_23628_length_181_cov_1.409091_g23425_i0	PRJNA674048	23628	181	1.409091	2.55045471	Labilithrix luteola	1391654	Bacteria	Bacteria	250	5.08e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23425	i0	91.667	136.303867403315	180	15	99	0	2	181	3942544	3942365	Labilithrix luteola strain DSM 27648, complete genome	blastn	24671	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10094489	10094489	PRJNA674048_P_NODE_12968_length_252_cov_8.596059_g12765_i0	PRJNA674048	12968	252	8.596059	21.66206868	Stigmatella	40	Bacteria	Bacteria	388	1.5299999999999998e-103	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g12765	i0	94.466	250.916666666667	253	13	100	1	1	252	513	765	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	63231	388	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
10847138	10847138	PRJNA674048_P_NODE_17369_length_213_cov_1.707317_g17166_i0	PRJNA674048	17369	213	1.707317	3.63658521	Myxococcales bacterium	2026763	Bacteria	Bacteria	204	4.8899999999999997e-48	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g17166	i0	90	88.3380281690141	160	13	74	3	56	213	1310429	1310271	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	18816	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10847191	10847191	PRJNA674048_P_NODE_23689_length_180_cov_4.206107_g23486_i0	PRJNA674048	23689	180	4.206107	7.5709926	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	204	3.98e-48	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g23486	i0	87.293	138.455555555556	181	19	100	3	1	180	8616616	8616793	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	24922	204	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13397243	13397243	PRJNA674048_P_NODE_27471_length_168_cov_1.747899_g27268_i0	PRJNA674048	27471	168	1.747899	2.93647032	Pendulispora albinea	2741071	Bacteria	Bacteria	226	7.859999999999997e-55	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g27268	i0	91.071	264.369047619048	168	14	100	1	1	168	3590583	3590417	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	44414	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
14672237	14672237	PRJNA674048_P_NODE_712_length_1332_cov_14.078722_g627_i0	PRJNA674048	712	1332	14.078722	187.52857704	Pendulispora rubella	2741070	Bacteria	Bacteria	1587	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g627	i0	90.848	140.301051051051	1191	99	89	8	145	1332	7290056	7288873	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	186881	1587	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16468725	16468725	PRJNA674048_P_NODE_12553_length_257_cov_4.572115_g12350_i0	PRJNA674048	12553	257	4.572115	11.75033555	Archangiaceae	39	Bacteria	Bacteria	348	2.6600000000000004e-91	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g12350	i0	92.245	239.081712062257	245	19	95	0	3	247	590	346	S.aurantiaca 23S rRNA gene	blastn	61444	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
20292522	20292522	PRJNA674048_P_NODE_29096_length_166_cov_1.769231_g28893_i0	PRJNA674048	29096	166	1.769231	2.93692346	root	1	Root_unresolved	Root_unresolved	150	4.79e-32	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g28893	i0	83.333	140.451807228916	168	22	100	5	1	166	3690303	3690466	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	23315	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21045679	21045679	PRJNA674048_P_NODE_27697_length_168_cov_0.873950_g27494_i0	PRJNA674048	27697	168	0.87395	1.468236	Labilithrix luteola	1391654	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27494	i0	90.909	79.2083333333333	165	15	98	0	4	168	183965	184129	Labilithrix luteola strain DSM 27648, complete genome	blastn	13307	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22320537	22320537	PRJNA674048_P_NODE_9398_length_309_cov_3.400000_g9195_i0	PRJNA674048	9398	309	3.4	10.506	Labilithrix luteola	1391654	Bacteria	Bacteria	538	1.8199999999999993e-148	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9195	i0	98.058	177.032362459547	309	6	100	0	1	309	3944267	3943959	Labilithrix luteola strain DSM 27648, complete genome	blastn	54703	538	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24869230	24869230	PRJNA674048_P_NODE_1420_length_987_cov_12.591684_g1303_i0	PRJNA674048	1420	987	12.591684	124.27992108	Labilithrix luteola	1391654	Bacteria	Bacteria	1182	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1303	i0	88.708	147.758865248227	983	91	98	17	17	987	7089987	7090961	Labilithrix luteola strain DSM 27648, complete genome	blastn	145838	1182	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);;