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

8 rows where analysis = "blastn", bioproject = "PRJEB83711" 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
144562	144562	PRJEB83711_P_NODE_69121_length_247_cov_0.896552_g68855_i0	PRJEB83711	69121	247	0.896552	2.21448344	Labilithrix luteola	1391654	Bacteria	Bacteria	424	4.1099999999999996e-114	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g68855	i0	97.571	141.923076923077	247	6	100	0	1	247	3942662	3942416	Labilithrix luteola strain DSM 27648, complete genome	blastn	35055	424	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2693968	2693968	PRJEB83711_P_NODE_36503_length_300_cov_1.030837_g36237_i0	PRJEB83711	36503	300	1.030837	3.092511	Myxococcus stipitatus	83455	Bacteria	Bacteria	331	3.2e-86	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g36237	i0	91.057	33.7066666666667	246	20	99	2	55	299	8475741	8475985	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	10112	331	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
3970236	3970236	PRJEB83711_P_NODE_44324_length_279_cov_1.145631_g44058_i0	PRJEB83711	44324	279	1.145631	3.19631049	Sorangium cellulosum	56	Bacteria	Bacteria	91.6	5.45e-14	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g44058	i0	76.667	1.93906810035842	180	32	63	8	95	269	4987441	4987615	Sorangium cellulosum 'So ce 56' complete genome	blastn	541	91.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7797220	7797220	PRJEB83711_P_NODE_78387_length_242_cov_0.923077_g78121_i0	PRJEB83711	78387	242	0.923077	2.23384634	Pendulispora brunnea	2905690	Bacteria	Bacteria	246	9.32e-61	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g78121	i0	85.417	369.648760330579	240	32	98	3	1	238	9038215	9037977	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	89455	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
10347749	10347749	PRJEB83711_P_NODE_74849_length_244_cov_0.912281_g74583_i0	PRJEB83711	74849	244	0.912281	2.22596564	Sorangium cellulosum	56	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g74583	i0	89.583	0.19672131147541	48	2	20	3	23	70	7085005	7085049	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	48	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11623264	11623264	PRJEB83711_P_NODE_74890_length_244_cov_0.912281_g74624_i0	PRJEB83711	74890	244	0.912281	2.22596564	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	230	9.47e-56	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g74624	i0	84.146	97.8606557377049	246	29	99	10	4	244	3641588	3641348	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	23878	230	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15447101	15447101	PRJEB83711_P_NODE_61293_length_251_cov_0.876404_g61027_i0	PRJEB83711	61293	251	0.876404	2.19977404	Archangium gephyra	48	Bacteria	Bacteria	291	4.43e-74	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g61027	i0	87.649	91.1195219123506	251	29	99	2	2	251	4305531	4305780	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	22871	291	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
18850538	18850538	PRJEB83711_P_NODE_68195_length_247_cov_1.586207_g67929_i0	PRJEB83711	68195	247	1.586207	3.91793129	Myxococcaceae	31	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g67929	i0	96.356	49.6842105263158	247	9	100	0	1	247	2041026	2040780	Myxococcus stipitatus DSM 14675, complete genome	blastn	12272	411	0.990267639902676	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus

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