metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA358009" 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
3623684	3623684	PRJNA358009_P_NODE_3243_length_327_cov_2.787770_g3180_i0	PRJNA358009	3243	327	2.78777	9.1160079	Polyangiaceae	49	Bacteria	Bacteria	148	3.81e-31	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g3180	i0	95.652	28.9938837920489	92	4	28	0	1	92	3731510	3731601	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	9481	148	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6775918	6775918	PRJNA358009_P_NODE_3766_length_327_cov_2.453237_g3703_i0	PRJNA358009	3766	327	2.453237	8.02208499	Chondromyces crocatus	52	Bacteria	Bacteria	63.9	1.42e-5	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g3703	i0	84.848	0.201834862385321	66	6	20	3	264	327	9208024	9208087	Chondromyces crocatus strain Cm c5, complete genome	blastn	66	63.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
9326486	9326486	PRJNA358009_P_NODE_9908_length_183_cov_2.731343_g9839_i0	PRJNA358009	9908	183	2.731343	4.99835769	Labilithrix luteola	1391654	Bacteria	Bacteria	222	1.12e-53	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9839	i0	88.587	98.9890710382514	184	19	100	2	1	183	9082997	9083179	Labilithrix luteola strain DSM 27648, complete genome	blastn	18115	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15700905	15700905	PRJNA358009_P_NODE_16533_length_160_cov_7.135135_g16464_i0	PRJNA358009	16533	160	7.135135	11.416216	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	276	7.230000000000001e-70	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g16464	i0	98.101	140.125	158	3	99	0	1	158	9677593	9677436	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	22420	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15700939	15700939	PRJNA358009_P_NODE_2373_length_327_cov_4.190647_g2310_i0	PRJNA358009	2373	327	4.190647	13.70341569	Pendulispora rubella	2741070	Bacteria	Bacteria	219	2.8599999999999993e-52	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2310	i0	97.638	34.2874617737003	127	3	69	0	2	128	7289166	7289292	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	11212	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16975726	16975726	PRJNA358009_P_NODE_6714_length_326_cov_1.797834_g6651_i0	PRJNA358009	6714	326	1.797834	5.86093884	Minicystis rosea	888845	Bacteria	Bacteria	143	1.77e-29	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g6651	i0	94.565	2.56441717791411	92	5	28	0	7	98	3215529	3215438	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	836	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18250023	18250023	PRJNA358009_P_NODE_9355_length_186_cov_6.328467_g9286_i0	PRJNA358009	9355	186	6.328467	11.77094862	Pendulispora albinea	2741071	Bacteria	Bacteria	267	5.22e-67	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g9286	i0	93.785	172.166666666667	177	11	95	0	4	180	3590038	3589862	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	32023	267	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22074839	22074839	PRJNA358009_P_NODE_2198_length_328_cov_1.741935_g2135_i0	PRJNA358009	2198	328	1.741935	5.7135468	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	111	5.02e-20	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g2135	i0	89.011	0.679878048780488	91	8	27	2	10	99	267464	267375	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	223	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
22749822	22749822	PRJNA358009_P_NODE_18358_length_151_cov_74.176471_g18289_i0	PRJNA358009	18358	151	74.176471	112.00647121	Pseudomonadati	3379134	Bacteria	Bacteria	257	2.43e-64	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g18289	i0	97.351	577.271523178808	151	4	100	0	1	151	854	704	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	87168	257	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);;