metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
2249138	2249138	PRJNA986481_P_NODE_57022_length_244_cov_2.246154_g56497_i0	PRJNA986481	57022	244	2.246154	5.48061576	Chondromyces crocatus	52	Bacteria	Bacteria	165	2.71e-36	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g56497	i0	82.143	0.80327868852459	196	32	80	3	47	240	8744181	8743987	Chondromyces crocatus strain Cm c5, complete genome	blastn	196	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7351346	7351346	PRJNA986481_P_NODE_34986_length_276_cov_1.779736_g34461_i0	PRJNA986481	34986	276	1.779736	4.91207136	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	468	2.13e-127	NTclustered	gi\|545342541\|gb\|KF505773.1\|	417999	g34461	i0	98.502	106.039855072464	267	1	96	3	12	276	504	239	Uncultured Polyangiaceae bacterium clone 5257 16S ribosomal RNA gene, partial sequence	blastn	29267	468	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
7351773	7351773	PRJNA986481_P_NODE_63466_length_198_cov_5.577181_g62941_i0	PRJNA986481	63466	198	5.577181	11.04281838	Pendulispora brunnea	2905690	Bacteria	Bacteria	206	1.25e-48	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g62941	i0	85.427	143.111111111111	199	28	100	1	1	198	9038025	9038223	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	28336	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
11177189	11177189	PRJNA986481_P_NODE_51749_length_250_cov_1.019900_g51224_i0	PRJNA986481	51749	250	1.0199	2.54975	Archangium violaceum	83451	Bacteria	Bacteria	176	1.2899999999999999e-39	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g51224	i0	90.299	47.988	134	13	54	0	93	226	8341192	8341325	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	11997	176	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
22650807	22650807	PRJNA986481_P_NODE_45378_length_257_cov_1.927885_g44853_i0	PRJNA986481	45378	257	1.927885	4.95466445	Chondromyces crocatus	52	Bacteria	Bacteria	76.8	1.39e-9	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g44853	i0	78.4	1.10894941634241	125	21	49	6	132	256	10649892	10649774	Chondromyces crocatus strain Cm c5, complete genome	blastn	285	76.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus

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