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

8 rows where analysis = "blastn", bioproject = "PRJNA382558" 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
405042	405042	PRJNA382558_S_NODE_9081_length_178_cov_4.219858_g9077_i0	PRJNA382558	9081	178	4.219858	7.51134724	Archangium gephyra	48	Bacteria	Bacteria	82.4	1.92e-11	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g9077	i0	94.34	0.297752808988764	53	3	30	0	79	131	8935760	8935708	Archangium gephyra strain DSM 2261, complete genome	blastn	53	82.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
1679667	1679667	PRJNA382558_S_NODE_14202_length_155_cov_7.618644_g14198_i0	PRJNA382558	14202	155	7.618644	11.8088982	Stigmatella aurantiaca	41	Bacteria	Bacteria	95.3	2.09e-15	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g14198	i0	91.304	17.3161290322581	69	6	45	0	1	69	6723805	6723873	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	2684	95.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
9332990	9332990	PRJNA382558_S_NODE_3888_length_226_cov_7.835979_g3884_i0	PRJNA382558	3888	226	7.835979	17.70931254	Corallococcus coralloides	184914	Bacteria	Bacteria	139	1.5e-28	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g3884	i0	78.319	69.9247787610619	226	41	98	7	4	225	9279107	9278886	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	15803	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
10003806	10003806	PRJNA382558_S_NODE_13968_length_156_cov_6.210084_g13964_i0	PRJNA382558	13968	156	6.210084	9.68773104	Myxococcus	32	Bacteria	Bacteria	171	3.399999999999999e-38	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g13964	i0	86.928	79.9871794871795	153	18	97	2	1	152	8538102	8537951	Myxococcus xanthus strain DK1050 chromosome	blastn	12478	171	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10003865	10003865	PRJNA382558_S_NODE_8488_length_181_cov_8.666667_g8484_i0	PRJNA382558	8488	181	8.666667	15.68666727	Pseudomonadati	3379134	Bacteria	Bacteria	89.8	1.17e-13	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g8484	i0	82.407	9.02762430939227	108	13	58	5	76	180	1570140	1570244	Sorangium cellulosum 'So ce 56' complete genome	blastn	1634	89.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15707635	15707635	PRJNA382558_S_NODE_2013_length_269_cov_5.150862_g2009_i0	PRJNA382558	2013	269	5.150862	13.85581878	Myxococcus xanthus	34	Bacteria	Bacteria	302	2.22e-77	NTclustered	gi\|1957989826\|gb\|CP068048.1\|	34	g2009	i0	88.934	25.4684014869888	244	27	91	0	26	269	5179952	5179709	Myxococcus xanthus strain R31 chromosome, complete genome	blastn	6851	302	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
19530846	19530846	PRJNA382558_S_NODE_7576_length_187_cov_9.720000_g7572_i0	PRJNA382558	7576	187	9.72	18.1764	Pendulispora albinea	2741071	Bacteria	Bacteria	145	2.5699999999999997e-30	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g7572	i0	83.125	44.6149732620321	160	25	85	2	3	161	5376422	5376264	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	8343	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
23356885	23356885	PRJNA382558_S_NODE_11219_length_167_cov_5.292308_g11215_i0	PRJNA382558	11219	167	5.292308	8.83815436	Cystobacter fuscus	43	Bacteria	Bacteria	84.2	4.97e-12	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g11215	i0	79.032	0.74251497005988	124	24	74	2	45	167	9293051	9293173	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	124	84.2	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);;