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

13 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
2585592	2585592	PRJEB30004_P_NODE_294743_length_285_cov_2.601626_g279116_i0	PRJEB30004	294743	285	2.601626	7.4146341	Pendulispora brunnea	2905690	Bacteria	Bacteria	394	3.8e-105	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g279116	i0	91.579	145.333333333333	285	24	100	0	1	285	7408384	7408100	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	41420	394	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
8641971	8641971	PRJEB30004_P_NODE_686627_length_150_cov_2.234234_g671000_i0	PRJEB30004	686627	150	2.234234	3.351351	Myxococcales	29	Bacteria	Bacteria	250	4.04e-62	NTclustered	gi\|545790931\|gb\|KF270694.1\|	38	g671000	i0	96.667	268.28	150	5	100	0	1	150	748	599	Angiococcus disciformis strain And1 23S ribosomal RNA gene, partial sequence	blastn	40242	250	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium disciforme
10242933	10242933	PRJEB30004_P_NODE_390289_length_231_cov_2.088542_g374662_i0	PRJEB30004	390289	231	2.088542	4.82453202	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	204	5.3799999999999997e-48	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g374662	i0	82.819	35.995670995671	227	39	98	0	1	227	4859756	4859982	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	8315	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
10254745	10254745	PRJEB30004_P_NODE_634989_length_160_cov_1.272727_g619362_i0	PRJEB30004	634989	160	1.272727	2.0363632	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	126	7.71e-25	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g619362	i0	81.761	35.675	159	22	98	6	4	160	2650705	2650552	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	5708	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11519525	11519525	PRJEB30004_P_NODE_415470_length_220_cov_2.425414_g399843_i0	PRJEB30004	415470	220	2.425414	5.3359108	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	124	4.07e-24	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g399843	i0	86.607	1.02272727272727	112	15	51	0	106	217	3054489	3054378	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	225	124	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
14064170	14064170	PRJEB30004_P_NODE_301032_length_281_cov_1.690083_g285405_i0	PRJEB30004	301032	281	1.690083	4.74913323	Stigmatella aurantiaca	41	Bacteria	Bacteria	329	1.07e-85	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g285405	i0	87.9	222.843416370107	281	32	99	2	2	281	1211	1490	S.aurantiaca 23S rRNA gene	blastn	62619	329	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
15016317	15016317	PRJEB30004_P_NODE_136132_length_501_cov_5.413420_g120624_i0	PRJEB30004	136132	501	5.41342	27.1212342	Myxococcia	32015	Bacteria	Bacteria	562	1.8299999999999997e-155	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g120624	i0	87.052	200.223552894212	502	59	99	5	1	499	3942267	3941769	Labilithrix luteola strain DSM 27648, complete genome	blastn	100312	566	0.992932862190813	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15350854	15350854	PRJEB30004_P_NODE_568753_length_174_cov_0.911111_g553126_i0	PRJEB30004	568753	174	0.911111	1.58533314	Labilithrix luteola	1391654	Bacteria	Bacteria	147	6.53e-31	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g553126	i0	88.43	5.31609195402299	121	14	70	0	4	124	6172371	6172491	Labilithrix luteola strain DSM 27648, complete genome	blastn	925	147	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15354891	15354891	PRJEB30004_P_NODE_652333_length_156_cov_2.820513_g636706_i0	PRJEB30004	652333	156	2.820513	4.40000028	uncultured Sorangium sp.	491148	Bacteria	Bacteria	215	1.55e-51	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g636706	i0	100	111.794871794872	116	0	74	0	1	116	1114	1229	Uncultured Sorangium sp. clone 3_E21 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17440	215	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
17890164	17890164	PRJEB30004_P_NODE_356735_length_247_cov_13.908654_g341108_i0	PRJEB30004	356735	247	13.908654	34.35437538	Pendulispora brunnea	2905690	Bacteria	Bacteria	346	9.14e-91	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g341108	i0	91.935	129.089068825911	248	18	99	2	2	247	7408402	7408155	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	31885	346	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
19180665	19180665	PRJEB30004_P_NODE_84836_length_708_cov_3.847534_g69960_i1	PRJEB30004	84836	708	3.847534	27.24054072	Pendulispora rubella	2741070	Bacteria	Bacteria	780	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g69960	i1	86.611	120.532485875706	717	82	100	12	1	708	9853122	9852411	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	85337	780	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22989755	22989755	PRJEB30004_P_NODE_340379_length_256_cov_2.926267_g324752_i0	PRJEB30004	340379	256	2.926267	7.49124352	Labilithrix luteola	1391654	Bacteria	Bacteria	274	4.5599999999999997e-69	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g324752	i0	86.047	135.625	258	32	100	4	1	256	3942267	3942012	Labilithrix luteola strain DSM 27648, complete genome	blastn	34720	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24254041	24254041	PRJEB30004_P_NODE_132180_length_512_cov_5.501057_g116707_i0	PRJEB30004	132180	512	5.501057	28.16541184	Labilithrix luteola	1391654	Bacteria	Bacteria	725	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g116707	i0	92.1	156.3515625	519	33	99	5	2	512	3942287	3942805	Labilithrix luteola strain DSM 27648, complete genome	blastn	80052	725	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);;