metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA454503" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
8095092	8095092	PRJNA454503_P_NODE_10967_length_339_cov_2.151079_g10638_i0	PRJNA454503	10967	339	2.151079	7.29215781	Pendulispora brunnea	2905690	Bacteria	Bacteria	134	1.11e-26	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g10638	i0	74.847	9.07079646017699	326	67	94	14	23	339	10988228	10987909	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	3075	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
13847192	13847192	PRJNA454503_P_NODE_27511_length_242_cov_84.624309_g27182_i0	PRJNA454503	27511	242	84.624309	204.79082778	Pseudomonadati	3379134	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g27182	i0	99.174	611.012396694215	242	2	100	0	1	242	664	905	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	147865	436	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18294036	18294036	PRJNA454503_P_NODE_375_length_1722_cov_12.786875_g244_i0	PRJNA454503	375	1722	12.786875	220.1899875	Pendulispora albinea	2741071	Bacteria	Bacteria	2170	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g244	i0	89.504	145.381533101045	1734	157	100	19	1	1722	7190399	7192119	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	250347	2170	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22119147	22119147	PRJNA454503_P_NODE_55098_length_211_cov_0.866667_g54769_i0	PRJNA454503	55098	211	0.866667	1.82866737	Corallococcus exercitus	2316736	Bacteria	Bacteria	145	2.97e-30	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g54769	i0	79.524	5.54976303317536	210	37	98	6	2	208	6531739	6531533	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	1171	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
23394841	23394841	PRJNA454503_P_NODE_56919_length_210_cov_1.892617_g56590_i0	PRJNA454503	56919	210	1.892617	3.9744957	Anaeromyxobacter sp. K	447217	Bacteria	Bacteria	172	1.36e-38	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g56590	i0	84.181	9.27619047619048	177	28	84	0	4	180	2511314	2511490	Anaeromyxobacter sp. K, complete genome	blastn	1948	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
24668759	24668759	PRJNA454503_P_NODE_54680_length_211_cov_0.866667_g54351_i0	PRJNA454503	54680	211	0.866667	1.82866737	Labilithrix luteola	1391654	Bacteria	Bacteria	257	3.66e-64	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g54351	i0	88.679	391.668246445498	212	23	100	1	1	211	7089187	7088976	Labilithrix luteola strain DSM 27648, complete genome	blastn	82642	257	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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