metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1180292" 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
1592466	1592466	PRJNA1180292_P_NODE_10142_length_248_cov_0.891429_g10010_i0	PRJNA1180292	10142	248	0.891429	2.21074392	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g10010	i0	81.452	2.02822580645161	248	46	100	0	1	248	692804	692557	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	503	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
6695698	6695698	PRJNA1180292_P_NODE_11346_length_246_cov_0.878613_g11214_i0	PRJNA1180292	11346	246	0.878613	2.16138798	Labilithrix luteola	1391654	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11214	i0	97.447	158.422764227642	235	4	95	2	13	246	3942553	3942786	Labilithrix luteola strain DSM 27648, complete genome	blastn	38972	399	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6695710	6695710	PRJNA1180292_P_NODE_12206_length_244_cov_0.912281_g12074_i0	PRJNA1180292	12206	244	0.912281	2.22596564	Pendulispora albinea	2741071	Bacteria	Bacteria	261	3.36e-65	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g12074	i0	86.809	91.6065573770492	235	29	96	2	6	239	1863832	1863599	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	22352	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
7971183	7971183	PRJNA1180292_P_NODE_8787_length_251_cov_0.876404_g8655_i0	PRJNA1180292	8787	251	0.876404	2.19977404	Polyangium aurulentum	2567896	Bacteria	Bacteria	224	4.5599999999999996e-54	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g8655	i0	83.267	5.27888446215139	251	35	98	6	1	246	4841492	4841740	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1325	224	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
8694173	8694173	PRJNA1180292_P_NODE_13187_length_239_cov_2.349398_g13055_i0	PRJNA1180292	13187	239	2.349398	5.61506122	Haliangium	162027	Bacteria	Bacteria	313	8.93e-81	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g13055	i0	90.638	323.355648535565	235	22	98	0	4	238	2927	2693	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	77282	313	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
9969387	9969387	PRJNA1180292_P_NODE_8788_length_251_cov_0.876404_g8656_i0	PRJNA1180292	8788	251	0.876404	2.19977404	Sorangium	39643	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g8656	i0	80.972	3.94820717131474	247	43	98	4	7	251	12355699	12355943	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	991	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13071557	13071557	PRJNA1180292_P_NODE_9871_length_249_cov_0.886364_g9739_i0	PRJNA1180292	9871	249	0.886364	2.20704636	Labilithrix luteola	1391654	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9739	i0	86.192	52.9879518072289	239	33	96	0	11	249	11530302	11530540	Labilithrix luteola strain DSM 27648, complete genome	blastn	13194	259	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14346942	14346942	PRJNA1180292_P_NODE_7612_length_255_cov_2.967033_g7480_i0	PRJNA1180292	7612	255	2.967033	7.56593415	Nannocystis exedens	54	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|1386873112\|gb\|MF774779.1\|	54	g7480	i0	97.189	202.470588235294	249	7	98	0	7	255	310	62	Nannocystis exedens strain Na e1 23S ribosomal RNA gene, partial sequence	blastn	51630	422	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
16894950	16894950	PRJNA1180292_P_NODE_12954_length_242_cov_0.923077_g12822_i0	PRJNA1180292	12954	242	0.923077	2.23384634	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g12822	i0	82.857	6.67355371900826	245	36	100	6	1	242	3770956	3771197	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	1615	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
24543908	24543908	PRJNA1180292_P_NODE_9420_length_250_cov_0.881356_g9288_i0	PRJNA1180292	9420	250	0.881356	2.20339	Cystobacter fuscus	43	Bacteria	Bacteria	148	2.8099999999999993e-31	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g9288	i0	78.696	0.92	230	43	91	6	21	247	8264694	8264920	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	230	148	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus

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