metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA725806" 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
3263143	3263143	PRJNA725806_P_NODE_24603_length_302_cov_1.864151_g24306_i0	PRJNA725806	24603	302	1.864151	5.62973602	Archangium violaceum	83451	Bacteria	Bacteria	291	5.47e-74	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g24306	i0	86.742	8.49006622516556	264	32	87	3	18	280	5108856	5108595	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	2564	291	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
3746176	3746176	PRJNA725806_P_NODE_17843_length_326_cov_31.211073_g17549_i0	PRJNA725806	17843	326	31.211073	101.74809798	Myxococcales	29	Bacteria	Bacteria	525	1.5e-144	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g17549	i0	95.732	269.782208588957	328	11	99	2	2	326	885	558	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	87949	525	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8365323	8365323	PRJNA725806_P_NODE_98667_length_198_cov_3.950311_g98365_i0	PRJNA725806	98667	198	3.950311	7.82161578	Pendulispora brunnea	2905690	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g98365	i0	100	0.287878787878788	29	0	15	0	143	171	8402110	8402138	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
12191176	12191176	PRJNA725806_P_NODE_188210_length_153_cov_1.000000_g187908_i0	PRJNA725806	188210	153	1	1.53	Haliangium ochraceum	80816	Bacteria	Bacteria	178	1.98e-40	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g187908	i0	88.435	0.96078431372549	147	17	96	0	6	152	3656691	3656545	Haliangium ochraceum DSM 14365, complete genome	blastn	147	178	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
12191266	12191266	PRJNA725806_P_NODE_4790_length_446_cov_4.775061_g4514_i0	PRJNA725806	4790	446	4.775061	21.29677206	Labilithrix luteola	1391654	Bacteria	Bacteria	580	4.449999999999999e-161	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4514	i0	91.667	133.632286995516	420	34	94	1	18	436	3943846	3944265	Labilithrix luteola strain DSM 27648, complete genome	blastn	59600	580	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24938177	24938177	PRJNA725806_P_NODE_109740_length_190_cov_9.032680_g109438_i0	PRJNA725806	109740	190	9.03268	17.162092	Myxococcales bacterium	2026763	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g109438	i0	100	0.152631578947368	29	0	15	0	137	165	1728971	1728999	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
25420988	25420988	PRJNA725806_P_NODE_177280_length_157_cov_1.500000_g176978_i0	PRJNA725806	177280	157	1.5	2.355	Myxococcales	29	Bacteria	Bacteria	278	1.96e-70	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g176978	i0	98.718	237.535031847134	156	2	99	0	1	156	1926	1771	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	37293	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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