metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA857143" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
2510805	2510805	PRJNA857143_S_NODE_112782_length_299_cov_2.641593_g111689_i0	PRJNA857143	112782	299	2.641593	7.89836307	Myxococcales	29	Bacteria	Bacteria	448	3.03e-121	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g111689	i0	93.96	386.976588628763	298	15	99	3	2	297	1062875	1062579	Archangium gephyra strain DSM 2261, complete genome	blastn	115706	451	0.993348115299335	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
3394701	3394701	PRJNA857143_S_NODE_40363_length_423_cov_4.920000_g39271_i0	PRJNA857143	40363	423	4.92	20.8116	Pendulispora brunnea	2905690	Bacteria	Bacteria	60.2	2.44e-4	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g39271	i0	100	0.423167848699764	32	0	8	0	224	255	5501189	5501220	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	179	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
6339221	6339221	PRJNA857143_S_NODE_112225_length_300_cov_1.374449_g111132_i0	PRJNA857143	112225	300	1.374449	4.123347	Myxococcus	32	Bacteria	Bacteria	270	7.08e-68	NTclustered	gi\|545790940\|gb\|KF270703.1\|	33	g111132	i0	83	218.443333333333	300	50	100	1	1	300	54	352	Myxococcus fulvus strain Mxf428 23S ribosomal RNA gene, partial sequence	blastn	65533	270	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
9772633	9772633	PRJNA857143_S_NODE_95388_length_318_cov_2.624490_g94295_i0	PRJNA857143	95388	318	2.62449	8.3458782	Archangium gephyra	48	Bacteria	Bacteria	124	6.2299999999999996e-24	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g94295	i0	80.864	33.5817610062893	162	27	50	3	125	284	3759926	3759767	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	10679	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
11046618	11046618	PRJNA857143_S_NODE_116149_length_296_cov_1.457399_g115056_i0	PRJNA857143	116149	296	1.4573989999999999	4.31390104	Labilithrix luteola	1391654	Bacteria	Bacteria	374	5.1599999999999986e-99	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g115056	i0	89.404	170.114864864865	302	24	99	5	3	296	3942562	3942261	Labilithrix luteola strain DSM 27648, complete genome	blastn	50354	374	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14871515	14871515	PRJNA857143_S_NODE_172312_length_251_cov_5.297753_g171219_i0	PRJNA857143	172312	251	5.297753	13.29736003	Pendulispora brunnea	2905690	Bacteria	Bacteria	217	7.619999999999999e-52	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g171219	i0	84.305	127.215139442231	223	34	90	1	3	224	9038004	9038226	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	31931	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
17422358	17422358	PRJNA857143_S_NODE_55494_length_383_cov_1.609677_g54401_i0	PRJNA857143	55494	383	1.609677	6.16506291	Labilithrix luteola	1391654	Bacteria	Bacteria	638	2.2e-178	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g54401	i0	97.09	155.1227154047	378	11	99	0	1	378	3943845	3944222	Labilithrix luteola strain DSM 27648, complete genome	blastn	59412	638	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21245931	21245931	PRJNA857143_S_NODE_197497_length_236_cov_2.803681_g196404_i0	PRJNA857143	197497	236	2.803681	6.61668716	Archangium violaceum	83451	Bacteria	Bacteria	132	2.64e-26	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g196404	i0	81.212	7.35593220338983	165	29	69	2	12	175	1276883	1276720	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	1736	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
24186827	24186827	PRJNA857143_S_NODE_118279_length_294_cov_1.411765_g117186_i0	PRJNA857143	118279	294	1.411765	4.1505891	Myxococcaceae	31	Bacteria	Bacteria	243	1.5100000000000001e-59	NTclustered	gi\|545790945\|gb\|KF270708.1\|	83456	g117186	i0	81.757	106.697278911565	296	49	100	5	1	294	9	301	Myxococcus virescens strain Mxv2 23S ribosomal RNA gene, partial sequence	blastn	31369	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus virescens

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