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

12 rows where analysis = "blastn", bioproject = "PRJNA558770" 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
541323	541323	PRJNA558770_P_NODE_360601_length_232_cov_6.837563_g358596_i0	PRJNA558770	360601	232	6.837563	15.86314616	Archangium gephyra	48	Bacteria	Bacteria	69.4	2.06e-7	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g358596	i0	86.885	2.31896551724138	61	8	26	0	172	232	3839633	3839573	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	538	69.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
5643127	5643127	PRJNA558770_P_NODE_207345_length_234_cov_3.507538_g205340_i0	PRJNA558770	207345	234	3.507538	8.20763892	Archangium violaceum	83451	Bacteria	Bacteria	58.4	4.5e-4	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g205340	i0	97.059	0.145299145299145	34	1	15	0	173	206	3383701	3383734	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
5644296	5644296	PRJNA558770_P_NODE_278885_length_234_cov_1.753769_g276880_i0	PRJNA558770	278885	234	1.753769	4.10381946	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	91.6	4.44e-14	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g276880	i0	91.045	1.23076923076923	67	6	29	0	10	76	10222382	10222448	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	288	91.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12608404	12608404	PRJNA558770_P_NODE_266150_length_234_cov_1.979899_g264145_i0	PRJNA558770	266150	234	1.979899	4.63296366	Sorangium	39643	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g264145	i0	86.275	1.08974358974359	51	5	21	2	161	210	11297421	11297372	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	255	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15842368	15842368	PRJNA558770_P_NODE_221113_length_234_cov_3.060302_g219108_i0	PRJNA558770	221113	234	3.060302	7.16110668	Stigmatella aurantiaca	41	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g219108	i0	91.071	6.8034188034188	56	5	24	0	20	75	7437850	7437795	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	1592	76.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
17117439	17117439	PRJNA558770_P_NODE_232674_length_234_cov_2.728643_g230669_i0	PRJNA558770	232674	234	2.728643	6.38502462	Cystobacter fuscus	43	Bacteria	Bacteria	73.1	1.61e-8	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g230669	i0	85.507	1.40598290598291	69	10	29	0	8	76	2108883	2108815	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	329	73.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
18391537	18391537	PRJNA558770_P_NODE_226395_length_234_cov_2.909548_g224390_i0	PRJNA558770	226395	234	2.909548	6.80834232	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	58.4	4.5e-4	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g224390	i0	94.595	0.158119658119658	37	2	16	0	23	59	893685	893721	Anaeromyxobacter paludicola DNA, complete genome	blastn	37	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
18392407	18392407	PRJNA558770_P_NODE_282215_length_234_cov_1.698492_g280210_i0	PRJNA558770	282215	234	1.698492	3.97447128	Sorangium cellulosum	56	Bacteria	Bacteria	67.6	7.48e-7	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g280210	i0	93.333	0.192307692307692	45	3	19	0	175	219	9133414	9133458	Sorangium cellulosum So0157-2, complete genome	blastn	45	67.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21531372	21531372	PRJNA558770_P_NODE_250097_length_234_cov_2.306533_g248092_i0	PRJNA558770	250097	234	2.306533	5.39728722	Sorangium	39643	Bacteria	Bacteria	62.1	3.48e-5	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g248092	i0	84.058	0.884615384615385	69	6	29	4	165	232	3581802	3581866	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	207	62.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22215052	22215052	PRJNA558770_P_NODE_140818_length_234_cov_7.125628_g138813_i0	PRJNA558770	140818	234	7.125628	16.67396952	Pendulispora brunnea	2905690	Bacteria	Bacteria	87.9	5.74e-13	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g138813	i0	90.769	26.4017094017094	65	6	28	0	12	76	4600099	4600163	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	6178	87.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
22806399	22806399	PRJNA558770_P_NODE_236458_length_234_cov_2.628141_g234453_i0	PRJNA558770	236458	234	2.628141	6.14984994	Myxococcales	29	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g234453	i0	93.056	79.7863247863248	72	5	62	0	160	231	451202	451131	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	18670	106	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
25355756	25355756	PRJNA558770_P_NODE_270600_length_234_cov_1.899497_g268595_i0	PRJNA558770	270600	234	1.899497	4.44482298	Myxococcaceae	31	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g268595	i0	100	115.102564102564	75	0	64	0	2	76	3271	3197	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	26934	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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