metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA879314" 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
857935	857935	PRJNA879314_P_NODE_8381_length_247_cov_0.896552_g8331_i0	PRJNA879314	8381	247	0.896552	2.21448344	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	244	3.43e-60	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g8331	i0	84.836	4.00404858299595	244	35	98	2	5	247	755282	755524	Anaeromyxobacter oryzae DNA, complete genome	blastn	989	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
2133244	2133244	PRJNA879314_P_NODE_7102_length_249_cov_0.886364_g7052_i0	PRJNA879314	7102	249	0.886364	2.20704636	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	217	7.55e-52	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g7052	i0	83.197	1.95180722891566	244	33	96	7	2	241	293680	293441	Anaeromyxobacter oryzae DNA, complete genome	blastn	486	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
2133281	2133281	PRJNA879314_P_NODE_9782_length_244_cov_0.912281_g9732_i0	PRJNA879314	9782	244	0.912281	2.22596564	Archangium violaceum	83451	Bacteria	Bacteria	150	7.589999999999999e-32	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g9732	i0	89.744	8.07377049180328	117	12	48	0	4	120	9697396	9697280	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	1970	150	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
3408643	3408643	PRJNA879314_P_NODE_3503_length_274_cov_1.248756_g3453_i0	PRJNA879314	3503	274	1.248756	3.42159144	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	167	8.609999999999999e-37	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g3453	i0	81.553	21.6240875912409	206	34	74	4	31	234	6311825	6311622	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	5925	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
8510843	8510843	PRJNA879314_P_NODE_8327_length_247_cov_0.896552_g8277_i0	PRJNA879314	8327	247	0.896552	2.21448344	Corallococcus coralloides	184914	Bacteria	Bacteria	233	7.429999999999999e-57	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g8277	i0	84.746	5.93522267206478	236	32	95	3	1	234	7435610	7435843	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	1466	233	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
11061509	11061509	PRJNA879314_P_NODE_4609_length_253_cov_0.866667_g4559_i0	PRJNA879314	4609	253	0.866667	2.19266751	Haliangium ochraceum	80816	Bacteria	Bacteria	183	7.8e-42	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g4559	i0	81.498	47.4822134387352	227	38	89	4	4	228	3407134	3407358	Haliangium ochraceum DSM 14365, complete genome	blastn	12013	183	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
13994238	13994238	PRJNA879314_P_NODE_7071_length_249_cov_0.886364_g7021_i0	PRJNA879314	7071	249	0.886364	2.20704636	Myxococcus	32	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g7021	i0	97.992	20.9598393574297	249	5	100	0	1	249	2760927	2761175	Myxococcus xanthus strain DK1050 chromosome	blastn	5219	433	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14885894	14885894	PRJNA879314_P_NODE_6012_length_251_cov_0.876404_g5962_i0	PRJNA879314	6012	251	0.876404	2.19977404	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g5962	i0	87.302	68.5577689243028	252	30	100	2	1	251	4321841	4321591	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	17208	287	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
15268307	15268307	PRJNA879314_P_NODE_10472_length_243_cov_0.917647_g10422_i0	PRJNA879314	10472	243	0.917647	2.22988221	Polyangiaceae	49	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g10422	i0	85	126.242798353909	240	34	100	2	5	243	10485722	10485484	Chondromyces crocatus strain Cm c5, complete genome	blastn	30677	243	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
16542932	16542932	PRJNA879314_P_NODE_3033_length_286_cov_1.136150_g2983_i0	PRJNA879314	3033	286	1.13615	3.249389	Anaeromyxobacter	161492	Bacteria	Bacteria	425	1.35e-114	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g2983	i0	93.662	74.8706293706294	284	18	99	0	3	286	2615714	2615431	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	21413	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20366710	20366710	PRJNA879314_P_NODE_4996_length_252_cov_0.871508_g4946_i0	PRJNA879314	4996	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	141	4.74e-29	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g4946	i0	80.628	10.8849206349206	191	29	74	7	59	245	7649081	7649267	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	2743	141	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
21259862	21259862	PRJNA879314_P_NODE_10317_length_243_cov_0.917647_g10267_i0	PRJNA879314	10317	243	0.917647	2.22988221	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	263	9.3e-66	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g10267	i0	86.364	4.73251028806584	242	31	99	2	3	243	135697	135457	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	1150	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
23809992	23809992	PRJNA879314_P_NODE_10099_length_244_cov_0.912281_g10049_i0	PRJNA879314	10099	244	0.912281	2.22596564	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	161	3.5e-35	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g10049	i0	80.269	1.7827868852459	223	36	89	8	1	218	2862977	2863196	Anaeromyxobacter oryzae DNA, complete genome	blastn	435	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
24191865	24191865	PRJNA879314_P_NODE_11079_length_242_cov_0.923077_g11029_i0	PRJNA879314	11079	242	0.923077	2.23384634	Myxococcus	32	Bacteria	Bacteria	84.2	7.73e-12	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g11029	i0	76.301	4.71487603305785	173	31	69	8	16	183	10750757	10750590	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	1141	84.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
25467098	25467098	PRJNA879314_P_NODE_9800_length_244_cov_0.912281_g9750_i0	PRJNA879314	9800	244	0.912281	2.22596564	Pseudomonadati	3379134	Bacteria	Bacteria	111	3.58e-20	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g9750	i0	94.444	52.0245901639344	72	4	30	0	165	236	5475467	5475538	Chondromyces crocatus strain Cm c5, complete genome	blastn	12694	111	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus

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