metadata: contig_metadata: 7 rows where bioproject = "PRJNA495917", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA495917", tax_kingdom = "Pseudomonadati" 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
477545	477545	PRJNA495917_S_NODE_1981_length_345_cov_16.183871_g1787_i0	PRJNA495917	1981	345	16.183871	55.83435495	Labilithrix luteola	1391654	Bacteria	Bacteria	422	2.16e-113	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1787	i0	88.857	192.379710144928	350	29	100	8	1	345	7089141	7089485	Labilithrix luteola strain DSM 27648, complete genome	blastn	66371	422	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8130485	8130485	PRJNA495917_S_NODE_10587_length_172_cov_1.167883_g10393_i0	PRJNA495917	10587	172	1.167883	2.00875876	Sorangium cellulosum	56	Bacteria	Bacteria	126	8.38e-25	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g10393	i0	81.132	3.38953488372093	159	28	92	2	1	158	6822794	6822637	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	583	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9405458	9405458	PRJNA495917_S_NODE_2648_length_300_cov_25.309434_g2454_i0	PRJNA495917	2648	300	25.309434	75.928302	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	540	4.89e-149	NTclustered	gi\|545342541\|gb\|KF505773.1\|	417999	g2454	i0	99.007	101.706666666667	302	1	100	2	1	300	198	499	Uncultured Polyangiaceae bacterium clone 5257 16S ribosomal RNA gene, partial sequence	blastn	30512	540	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
17685711	17685711	PRJNA495917_S_NODE_3034_length_281_cov_257.593496_g2840_i0	PRJNA495917	3034	281	257.593496	723.83772376	Pendulispora	3375062	Bacteria	Bacteria	438	1.7e-118	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2840	i0	94.982	258.654804270463	279	14	99	0	1	279	7287188	7287466	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	72682	438	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
19603446	19603446	PRJNA495917_S_NODE_2736_length_295_cov_29.530769_g2542_i0	PRJNA495917	2736	295	29.530769	87.11576855	Pendulispora albinea	2741071	Bacteria	Bacteria	425	1.3999999999999999e-114	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2542	i0	92.617	159.752542372881	298	19	100	2	1	295	7191655	7191358	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	47127	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22785032	22785032	PRJNA495917_S_NODE_458_length_661_cov_26.873802_g319_i0	PRJNA495917	458	661	26.873802	177.63583122	Pendulispora	3375062	Bacteria	Bacteria	990	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g319	i0	93.807	155.886535552194	662	36	100	3	1	661	7289538	7288881	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	103041	990	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
23429908	23429908	PRJNA495917_S_NODE_1979_length_345_cov_32.935484_g1785_i0	PRJNA495917	1979	345	32.935484	113.6274198	Labilithrix luteola	1391654	Bacteria	Bacteria	472	2.1099999999999999e-128	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1785	i0	91.379	168.246376811594	348	24	100	5	1	345	3941936	3942280	Labilithrix luteola strain DSM 27648, complete genome	blastn	58045	472	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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