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

9 rows where analysis = "blastn", bioproject = "PRJNA599026" 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
3122652	3122652	PRJNA599026_S_NODE_38363_length_184_cov_3.644444_g37907_i0	PRJNA599026	38363	184	3.644444	6.70577696	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	67.6	5.6e-7	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g37907	i0	97.436	0.21195652173913	39	1	21	0	64	102	6479044	6479082	Anaeromyxobacter oryzae DNA, complete genome	blastn	39	67.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
3122913	3122913	PRJNA599026_S_NODE_61663_length_164_cov_0.886957_g61207_i0	PRJNA599026	61663	164	0.886957	1.45460948	Archangium violaceum	83451	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g61207	i0	85.833	2.26219512195122	120	17	73	0	3	122	8271480	8271599	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	371	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
6950113	6950113	PRJNA599026_S_NODE_54066_length_166_cov_0.871795_g53610_i0	PRJNA599026	54066	166	0.871795	1.4471797	Chondromyces crocatus	52	Bacteria	Bacteria	145	2.23e-30	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g53610	i0	83.23	1.78915662650602	161	23	96	4	2	160	5406201	5406359	Chondromyces crocatus strain Cm c5, complete genome	blastn	297	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
11344611	11344611	PRJNA599026_S_NODE_47809_length_170_cov_2.107438_g47353_i0	PRJNA599026	47809	170	2.107438	3.5826446	Corallococcus	83461	Bacteria	Bacteria	193	8.03e-45	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g47353	i0	88.679	38.9764705882353	159	16	93	2	1	158	8457816	8457973	Myxococcus macrosporus strain HW-1, complete genome	blastn	6626	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
12050964	12050964	PRJNA599026_S_NODE_48070_length_170_cov_1.264463_g47614_i0	PRJNA599026	48070	170	1.264463	2.1495871	Stigmatella aurantiaca	41	Bacteria	Bacteria	220	3.68e-53	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g47614	i0	91.463	129.823529411765	164	8	96	3	1	163	576875	577033	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	22070	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
19698408	19698408	PRJNA599026_S_NODE_56676_length_165_cov_0.879310_g56220_i0	PRJNA599026	56676	165	0.87931	1.4508615	Myxococcus sp. NMCA1	2996785	Bacteria	Bacteria	187	3.6199999999999985e-43	NTclustered	gi\|2410912425\|gb\|CP113950.1\|	2996785	g56220	i0	87.654	22.830303030303	162	18	98	2	3	163	6688436	6688276	Myxococcus sp. NMCA1 chromosome, complete genome	blastn	3767	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. NMCA1
20974269	20974269	PRJNA599026_S_NODE_62137_length_164_cov_0.860870_g61681_i0	PRJNA599026	62137	164	0.86087	1.4118268	Myxococcus fulvus	33	Bacteria	Bacteria	180	6.02e-41	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g61681	i0	87.037	84.2378048780488	162	17	98	4	5	164	8827906	8828065	Myxococcus fulvus 124B02, complete genome	blastn	13815	180	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22249152	22249152	PRJNA599026_S_NODE_65918_length_162_cov_1.451327_g65462_i0	PRJNA599026	65918	162	1.451327	2.35114974	Sorangium cellulosum	56	Bacteria	Bacteria	121	3.639999999999999e-23	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g65462	i0	82.394	35.6234567901235	142	21	87	4	22	161	13169310	13169449	Sorangium cellulosum So0157-2, complete genome	blastn	5771	121	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24797722	24797722	PRJNA599026_S_NODE_27640_length_207_cov_2.873418_g27184_i0	PRJNA599026	27640	207	2.873418	5.94797526	Archangium gephyra	48	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g27184	i0	100	0.140096618357488	29	0	14	0	59	87	3262858	3262830	Archangium gephyra strain DSM 2261, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra

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