metadata: contig_metadata: 12 rows where bioproject = "PRJNA1068830", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA1068830", 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
10386230	10386230	PRJNA1068830_P_NODE_50589_length_308_cov_1.195745_g49886_i0	PRJNA1068830	50589	308	1.195745	3.6828946	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	115	3.62e-21	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g49886	i0	83.871	5.81493506493506	124	17	40	2	21	144	5928048	5928168	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	1791	115	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12493259	12493259	PRJNA1068830_P_NODE_85790_length_244_cov_0.912281_g85087_i0	PRJNA1068830	85790	244	0.912281	2.22596564	Myxococcaceae	31	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g85087	i0	98.77	245.844262295082	244	3	100	0	1	244	533	290	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	59986	435	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
21859620	21859620	PRJNA1068830_P_NODE_44878_length_329_cov_1.898438_g44175_i0	PRJNA1068830	44878	329	1.898438	6.24586102	Archangium violaceum	83451	Bacteria	Bacteria	403	7.419999999999998e-108	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g44175	i0	88.922	238.762917933131	334	28	100	8	1	329	585142	585471	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	78553	403	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
28015063	28015063	PRJNA1068830_P_NODE_83465_length_245_cov_1.302326_g82762_i0	PRJNA1068830	83465	245	1.302326	3.1906987	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.8	0.00304	NR	MBL8616282.1	2026735	g82762	i0	43.6	0.673469387755102	55	29	67.3	1	243	79	147	199	MBL8616282.1 IPT/TIG domain-containing protein [Deltaproteobacteria bacterium]	diamond	165	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28015064	28015064	PRJNA1068830_P_NODE_85605_length_244_cov_0.912281_g84902_i0	PRJNA1068830	85605	244	0.912281	2.22596564	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	44.3	0.00732	NR	MDF3070876.1	2268199	g84902	i0	44.7	0.467213114754098	38	21	46.7	0	3	116	8	45	MDF3070876.1 pth [Polyangiaceae bacterium]	diamond	114	44.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29214946	29214946	PRJNA1068830_P_NODE_55609_length_292_cov_1.273973_g54906_i0	PRJNA1068830	55609	292	1.273973	3.72000116	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	44.3	0.0184	NR	HEX3765821.1	2212474	g54906	i0	41	0.852739726027397	83	45	84.2	3	42	287	8	87	HEX3765821.1 polysaccharide deacetylase family protein [Kofleriaceae bacterium]	diamond	249	44.3	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
29972546	29972546	PRJNA1068830_P_NODE_81491_length_247_cov_0.896552_g80788_i0	PRJNA1068830	81491	247	0.896552	2.21448344	Myxococcales bacterium	2026763	Bacteria	Bacteria	49.3	1.95e-4	NR	MBL8683386.1	2026763	g80788	i0	40.4	0.692307692307692	57	32	69.2	1	243	73	45	99	MBL8683386.1 hypothetical protein [Myxococcales bacterium]	diamond	171	49.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30035806	30035806	PRJNA1068830_P_NODE_70711_length_256_cov_1.300546_g70008_i0	PRJNA1068830	70711	256	1.300546	3.32939776	Myxococcales bacterium	2026763	Bacteria	Bacteria	67	2.6e-11	NR	MCP4448234.1	2026763	g70008	i0	43	2.0390625	86	46	97.3	1	3	251	63	148	MCP4448234.1 hypothetical protein [Myxococcales bacterium]	diamond	522	67	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30288897	30288897	PRJNA1068830_P_NODE_53892_length_297_cov_1.620536_g53189_i0	PRJNA1068830	53892	297	1.620536	4.81299192	Cystobacter fuscus	43	Bacteria	Bacteria	66.6	2.88e-10	NR	WP_095988725.1	43	g53189	i0	46.7	2.70707070707071	60	32	60.6	0	118	297	431	490	WP_095988725.1 multicopper oxidase family protein [Cystobacter fuscus]	diamond	804	66.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
30793943	30793943	PRJNA1068830_P_NODE_82114_length_246_cov_0.901734_g81411_i0	PRJNA1068830	82114	246	0.901734	2.21826564	Archangium gephyra	48	Bacteria	Bacteria	153	2.14e-42	NR	PZR13889.1	48	g81411	i0	91.4	0.98780487804878	81	7	98.8	0	3	245	370	450	PZR13889.1 MAG: NADH-quinone oxidoreductase subunit H [Archangium gephyra]	diamond	243	153	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
31109822	31109822	PRJNA1068830_P_NODE_69095_length_259_cov_2.494624_g68392_i0	PRJNA1068830	69095	259	2.494624	6.46107616	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.7	0.0414	NR	MBK7586224.1	2026763	g68392	i0	25.3	0.868725868725869	75	56	86.9	0	257	33	52	126	MBK7586224.1 PEGA domain-containing protein [Myxococcales bacterium]	diamond	225	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31457935	31457935	PRJNA1068830_P_NODE_62156_length_276_cov_1.093596_g61453_i0	PRJNA1068830	62156	276	1.093596	3.01832496	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	50.4	1.06e-4	NR	NUP12796.1	2268199	g61453	i0	51.1	0.489130434782609	45	20	46.7	1	130	2	157	201	NUP12796.1 hypothetical protein [Polyangiaceae bacterium]	diamond	135	50.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium

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