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

5 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
2366363	2366363	PRJNA438572_P_NODE_11182_length_307_cov_2.000000_g11063_i0	PRJNA438572	11182	307	2	6.14	Haliangium	162027	Bacteria	Bacteria	377	4.16e-100	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g11063	i0	88.961	177.625407166124	308	31	99	3	1	306	1279	973	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	54531	377	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
3641953	3641953	PRJNA438572_P_NODE_1683_length_740_cov_1.272864_g1579_i0	PRJNA438572	1683	740	1.272864	9.4191936	Stigmatella	40	Bacteria	Bacteria	981	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1579	i0	90.701	242.933783783784	742	61	100	5	1	740	917	182	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	179771	981	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
6812843	6812843	PRJNA438572_P_NODE_24126_length_242_cov_0.923077_g24007_i0	PRJNA438572	24126	242	0.923077	2.23384634	Minicystis rosea	888845	Bacteria	Bacteria	185	2.06e-42	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g24007	i0	81.092	70.8512396694215	238	39	97	6	1	235	10105655	10105889	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	17146	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17012295	17012295	PRJNA438572_P_NODE_17194_length_253_cov_0.866667_g17075_i0	PRJNA438572	17194	253	0.866667	2.19266751	Polyangium aurulentum	2567896	Bacteria	Bacteria	254	5.86e-63	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g17075	i0	85.156	3.04347826086957	256	28	99	9	3	253	8660101	8660351	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	770	254	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
25317292	25317292	PRJNA438572_P_NODE_7540_length_369_cov_1.050676_g7421_i0	PRJNA438572	7540	369	1.050676	3.87699444	Haliangium	162027	Bacteria	Bacteria	420	8.34e-113	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g7421	i0	88.122	239.691056910569	362	32	98	7	8	369	1523	1173	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	88446	420	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum

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