metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
452102	452102	PRJNA492280_P_NODE_29441_length_151_cov_8.561404_g29334_i0	PRJNA492280	29441	151	8.561404	12.92772004	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	102	1.21e-17	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g29334	i0	91.781	8.25165562913907	73	6	48	0	4	76	1696249	1696321	Anaeromyxobacter paludicola DNA, complete genome	blastn	1246	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
2374444	2374444	PRJNA492280_P_NODE_25702_length_164_cov_2.393701_g25595_i0	PRJNA492280	25702	164	2.393701	3.92566964	Pseudomonadati	3379134	Bacteria	Bacteria	86.1	1.35e-12	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g25595	i0	87.838	40.6890243902439	74	8	45	1	89	161	771653	771580	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	6673	86.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
3002679	3002679	PRJNA492280_P_NODE_23623_length_164_cov_2.779528_g23516_i0	PRJNA492280	23623	164	2.779528	4.55842592	Minicystis rosea	888845	Bacteria	Bacteria	130	6.15e-26	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g23516	i0	98.63	9.50609756097561	73	1	45	0	4	76	12822890	12822818	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	1559	130	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
4279042	4279042	PRJNA492280_P_NODE_2544_length_293_cov_10.484375_g2437_i0	PRJNA492280	2544	293	10.484375	30.71921875	Labilithrix luteola	1391654	Bacteria	Bacteria	444	3.84e-120	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2437	i0	94.444	149.778156996587	288	16	98	0	3	290	7090450	7090163	Labilithrix luteola strain DSM 27648, complete genome	blastn	43885	444	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8105052	8105052	PRJNA492280_P_NODE_1907_length_328_cov_4.601375_g1800_i0	PRJNA492280	1907	328	4.601375	15.09251	Pendulispora albinea	2741071	Bacteria	Bacteria	202	2.9e-47	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g1800	i0	90.728	108.158536585366	151	14	70	0	5	155	7191571	7191421	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	35476	202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
10655774	10655774	PRJNA492280_P_NODE_31729_length_151_cov_2.824561_g31622_i0	PRJNA492280	31729	151	2.824561	4.26508711	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	134	4.28e-27	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g31622	i0	98.667	45.6225165562914	75	1	50	0	74	148	1550899	1550973	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	6889	134	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
10655832	10655832	PRJNA492280_P_NODE_5249_length_223_cov_3.295699_g5142_i0	PRJNA492280	5249	223	3.295699	7.34940877	Pendulispora rubella	2741070	Bacteria	Bacteria	207	3.99e-49	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g5142	i0	84.545	11.8251121076233	220	23	98	8	2	220	9852675	9852466	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	2637	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11930555	11930555	PRJNA492280_P_NODE_19510_length_164_cov_3.417323_g19403_i0	PRJNA492280	19510	164	3.417323	5.60440972	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g19403	i0	100	0.176829268292683	29	0	18	0	24	52	74358	74330	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
11930776	11930776	PRJNA492280_P_NODE_850_length_477_cov_8.902273_g755_i0	PRJNA492280	850	477	8.902273	42.46384221	Pendulispora rubella	2741070	Bacteria	Bacteria	508	2.29e-139	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g755	i0	86.105	197.819706498952	475	63	99	3	5	477	7289965	7289492	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	94360	508	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
15754697	15754697	PRJNA492280_P_NODE_33393_length_150_cov_4.035398_g33286_i0	PRJNA492280	33393	150	4.035398	6.053097	Pendulispora albinea	2741071	Bacteria	Bacteria	139	9.12e-29	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g33286	i0	84.138	0.966666666666667	145	21	96	2	7	150	6539901	6539758	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	145	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
19577921	19577921	PRJNA492280_P_NODE_416_length_641_cov_9.399007_g343_i0	PRJNA492280	416	641	9.399007	60.24763487	Labilithrix luteola	1391654	Bacteria	Bacteria	651	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g343	i0	94.749	123.589703588144	419	21	97	1	1	418	3942863	3942445	Labilithrix luteola strain DSM 27648, complete genome	blastn	79221	651	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20853574	20853574	PRJNA492280_P_NODE_1657_length_346_cov_19.394822_g1551_i0	PRJNA492280	1657	346	19.394822	67.10608412	Pendulispora albinea	2741071	Bacteria	Bacteria	331	3.76e-86	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g1551	i0	88.406	95.0231213872832	276	30	79	2	63	337	3589300	3589026	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	32878	331	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea

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