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

8 rows where analysis = "blastn", bioproject = "PRJNA756891" 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
14760918	14760918	PRJNA756891_P_NODE_12532_length_250_cov_0.870056_g12463_i0	PRJNA756891	12532	250	0.870056	2.17514	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	145	3.63e-30	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g12463	i0	81.421	1.068	183	28	72	6	71	250	3419181	3419002	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	267	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
16034617	16034617	PRJNA756891_P_NODE_12013_length_251_cov_1.606742_g11944_i0	PRJNA756891	12013	251	1.606742	4.03292242	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	224	4.5599999999999996e-54	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g11944	i0	84.513	5.91633466135458	226	35	90	0	26	251	3579277	3579502	Anaeromyxobacter oryzae DNA, complete genome	blastn	1485	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
18583867	18583867	PRJNA756891_P_NODE_12615_length_250_cov_0.870056_g12546_i0	PRJNA756891	12615	250	0.870056	2.17514	Labilithrix luteola	1391654	Bacteria	Bacteria	154	6.03e-33	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g12546	i0	78.333	8.508	240	50	96	2	1	239	7995414	7995176	Labilithrix luteola strain DSM 27648, complete genome	blastn	2127	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18583938	18583938	PRJNA756891_P_NODE_9695_length_280_cov_1.487923_g9626_i0	PRJNA756891	9695	280	1.487923	4.1661844	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	161	4.11e-35	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g9626	i0	80.882	0.832142857142857	204	39	73	0	1	204	3915986	3916189	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	233	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19859003	19859003	PRJNA756891_P_NODE_10836_length_266_cov_1.575130_g10767_i0	PRJNA756891	10836	266	1.57513	4.1898458	Pendulispora rubella	2741070	Bacteria	Bacteria	178	3.849999999999999e-40	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g10767	i0	85.143	1.6390977443609	175	24	65	2	1	174	15728	15555	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	436	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20328688	20328688	PRJNA756891_P_NODE_13456_length_248_cov_0.880000_g13387_i0	PRJNA756891	13456	248	0.88	2.1824	Pendulispora	3375062	Bacteria	Bacteria	82.4	2.86e-11	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13387	i0	92.857	0.67741935483871	56	4	23	0	81	136	7775398	7775343	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	168	82.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24958538	24958538	PRJNA756891_P_NODE_15100_length_244_cov_0.900585_g15031_i0	PRJNA756891	15100	244	0.900585	2.1974274	Polyangium aurulentum	2567896	Bacteria	Bacteria	126	1.28e-24	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g15031	i0	83.704	0.55327868852459	135	20	55	2	67	200	9004465	9004598	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	135	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
24958598	24958598	PRJNA756891_P_NODE_8800_length_293_cov_1.163636_g8731_i0	PRJNA756891	8800	293	1.163636	3.40945348	Corallococcus exercitus	2316736	Bacteria	Bacteria	248	3.23e-61	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g8731	i0	82.034	3.00682593856655	295	49	100	4	1	293	9115150	9114858	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	881	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus

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