metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA600413" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA600413" 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
3693288	3693288	PRJNA600413_P_NODE_135083_length_163_cov_0.894737_g134382_i0	PRJNA600413	135083	163	0.894737	1.45842131	Myxococcaceae	31	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g134382	i0	95.706	44.2515337423313	163	7	100	0	1	163	5464911	5464749	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	7213	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
6245310	6245310	PRJNA600413_P_NODE_106705_length_167_cov_0.864407_g106004_i0	PRJNA600413	106705	167	0.864407	1.44355969	Corallococcus	83461	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g106004	i0	100	0.335329341317365	28	0	17	0	26	53	3168320	3168347	Corallococcus sp. EGB chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
8226230	8226230	PRJNA600413_P_NODE_121167_length_165_cov_0.879310_g120466_i0	PRJNA600413	121167	165	0.87931	1.4508615	Melittangium boletus	83453	Bacteria	Bacteria	139	1.03e-28	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g120466	i0	91.262	1.87272727272727	103	7	62	2	1	102	2548901	2548800	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	309	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
12052216	12052216	PRJNA600413_P_NODE_122010_length_165_cov_0.879310_g121309_i0	PRJNA600413	122010	165	0.87931	1.4508615	Myxococcus stipitatus	83455	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g121309	i0	84.733	22.3393939393939	131	20	79	0	2	132	494072	493942	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	3686	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
14602285	14602285	PRJNA600413_P_NODE_144492_length_161_cov_1.821429_g143791_i0	PRJNA600413	144492	161	1.821429	2.93250069	Sorangium cellulosum	56	Bacteria	Bacteria	158	2.76e-34	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g143791	i0	84.375	0.993788819875776	160	25	99	0	2	161	13226612	13226453	Sorangium cellulosum So0157-2, complete genome	blastn	160	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15877900	15877900	PRJNA600413_P_NODE_79333_length_180_cov_1.557252_g78632_i0	PRJNA600413	79333	180	1.557252	2.8030536	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	69.4	1.52e-7	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g78632	i0	95.349	0.544444444444444	43	2	24	0	105	147	2819718	2819760	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	98	69.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
22252399	22252399	PRJNA600413_P_NODE_92858_length_172_cov_1.357724_g92157_i0	PRJNA600413	92858	172	1.357724	2.33528528	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	156	1.07e-33	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g92157	i0	83.14	1	172	27	99	2	2	172	1877306	1877476	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	172	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
24799622	24799622	PRJNA600413_P_NODE_147480_length_161_cov_0.910714_g146779_i0	PRJNA600413	147480	161	0.910714	1.46624954	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	159	7.66e-35	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g146779	i0	86.275	16.1055900621118	153	14	94	6	2	152	1662635	1662488	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	2593	159	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus

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