metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_phylum = "Pseudomonadota"

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
9295358	9295358	PRJNA229468_S_NODE_1188_length_163_cov_0.894737_g1175_i0	PRJNA229468	1188	163	0.894737	1.45842131	Burkholderiales bacterium	1891238	Bacteria	Bacteria	61.2	3.8e-9	NR	MCZ2292184.1	1891238	g1175	i0	60.4	1.95092024539877	53	21	97.5	0	162	4	58	110	MCZ2292184.1 phage tail protein [Burkholderiales bacterium]	diamond	318	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
13121077	13121077	PRJNA229468_S_NODE_1031_length_168_cov_1.285714_g1018_i0	PRJNA229468	1031	168	1.285714	2.15999952	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	3.63e-16	NR	WP_044427194.1	393310	g1018	i0	66.7	5.89285714285714	54	18	96.4	0	4	165	314	367	WP_044427194.1 glucose-6-phosphate isomerase [Skermanella aerolata]	diamond	990	81.6	0.996323529411765	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Azospirillaceae	Skermanella	Skermanella aerolata
19493247	19493247	PRJNA229468_S_NODE_636_length_204_cov_0.922581_g623_i0	PRJNA229468	636	204	0.922581	1.88206524	root	1	Root_unresolved	Root_unresolved	119	3.82e-33	NR	WP_336506879.1	573	g623	i0	77.6	86.6470588235294	67	15	98.5	0	2	202	21	87	WP_336506879.1 30S ribosomal protein S8, partial [Klebsiella pneumoniae]	diamond	17676	120	0.991666666666667	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
26648402	26648402	PRJNA229468_S_NODE_1061_length_167_cov_0.864407_g1048_i0	PRJNA229468	1061	167	0.864407	1.44355969	Rhodobacterales	204455	Bacteria	Bacteria	89.7	3.69e-19	NR	WP_055188731.1	154981	g1048	i0	74.5	16.7964071856287	55	14	98.8	0	166	2	166	220	WP_055188731.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Aliiroseovarius crassostreae]	diamond	2805	89.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Aliiroseovarius	Aliiroseovarius crassostreae
27042402	27042402	PRJNA229468_S_NODE_682_length_198_cov_0.939597_g669_i0	PRJNA229468	682	198	0.939597	1.86040206	Klebsiella pneumoniae	573	Bacteria	Bacteria	50.1	3.3e-6	NR	WP_217900948.1	573	g669	i0	69.2	0.393939393939394	26	8	39.4	0	116	39	1	26	WP_217900948.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	78	50.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
27091800	27091800	PRJNA229468_S_NODE_402_length_248_cov_1.025126_g389_i0	PRJNA229468	402	248	1.025126	2.54231248	root	1	Root_unresolved	Root_unresolved	100	1.74e-25	NR	WP_171259430.1	470	g389	i0	73.3	82.8870967741936	60	16	72.6	0	181	2	29	88	WP_171259430.1 hypothetical protein, partial [Acinetobacter baumannii]	diamond	20556	101	0.99009900990099	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
27390248	27390248	PRJNA229468_S_NODE_1123_length_165_cov_0.879310_g1110_i0	PRJNA229468	1123	165	0.87931	1.4508615	Sphingobium sp. SYK-6	627192	Bacteria	Bacteria	60.1	5.68e-9	NR	WP_041392175.1	627192	g1110	i0	66	4.65454545454545	50	16	90.9	1	160	11	8	56	WP_041392175.1 SDR family NAD(P)-dependent oxidoreductase [Sphingobium sp. SYK-6]	diamond	768	60.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium sp. SYK-6
28021702	28021702	PRJNA229468_S_NODE_945_length_174_cov_1.216000_g932_i0	PRJNA229468	945	174	1.216	2.11584	Methylobacter sp.	2051955	Bacteria	Bacteria	65.9	4.78e-11	NR	WP_333874727.1	2051955	g932	i0	58.6	2	58	23	98.3	1	172	2	162	219	WP_333874727.1 glucose 1-dehydrogenase [Methylobacter sp.]	diamond	348	65.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales	Methylococcaceae	Methylobacter	Methylobacter sp.
28354969	28354969	PRJNA229468_S_NODE_1206_length_162_cov_2.203540_g1193_i0	PRJNA229468	1206	162	2.20354	3.5697348	root	1	Root_unresolved	Root_unresolved	69.3	3.2e-12	NR	WP_270022569.1	287	g1193	i0	64.2	525.092592592593	53	19	98.1	0	1	159	104	156	WP_270022569.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	85065	69.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28463739	28463739	PRJNA229468_S_NODE_346_length_268_cov_1.598174_g333_i0	PRJNA229468	346	268	1.598174	4.28310632	unclassified Mesorhizobium	325217	Bacteria	Bacteria	43.5	0.012	NR	WP_353641598.1	325217	g333	i0	41.8	1.84701492537313	55	29	58.2	1	231	76	82	136	WP_353641598.1 MULTISPECIES: ion channel [unclassified Mesorhizobium]	diamond	495	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium
28670905	28670905	PRJNA229468_S_NODE_1227_length_162_cov_0.902655_g1214_i0	PRJNA229468	1227	162	0.902655	1.4623011	root	1	Root_unresolved	Root_unresolved	47.4	3.57e-5	NR	WP_336506774.1	573	g1214	i0	44.2	5.90740740740741	52	29	96.3	0	5	160	6	57	WP_336506774.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	957	47.8	0.99163179916318	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
29032143	29032143	PRJNA229468_S_NODE_328_length_274_cov_1.751111_g315_i0	PRJNA229468	328	274	1.751111	4.79804414	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	137	1.15e-39	NR	MEL6702651.1	1977087	g315	i0	73	0.974452554744526	89	24	97.4	0	271	5	22	110	MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium]	diamond	267	137	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
30295573	30295573	PRJNA229468_S_NODE_1252_length_161_cov_0.910714_g1239_i0	PRJNA229468	1252	161	0.910714	1.46624954	Candidatus Competibacteraceae bacterium	2053538	Bacteria	Bacteria	84.7	1.75e-17	NR	NJL71865.1	2053538	g1239	i0	75.5	20.7204968944099	53	13	98.8	0	161	3	384	436	NJL71865.1 class II fumarate hydratase [Candidatus Competibacteraceae bacterium]	diamond	3336	84.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria		Candidatus Competibacteraceae		Candidatus Competibacteraceae bacterium
30484790	30484790	PRJNA229468_S_NODE_1253_length_161_cov_0.910714_g1240_i0	PRJNA229468	1253	161	0.910714	1.46624954	Burkholderiales bacterium	1891238	Bacteria	Bacteria	55.1	5.37e-7	NR	MDE2418557.1	1891238	g1240	i0	67.5	1.73291925465839	40	13	74.5	0	128	9	186	225	MDE2418557.1 hypothetical protein [Burkholderiales bacterium]	diamond	279	55.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
30863792	30863792	PRJNA229468_S_NODE_334_length_272_cov_1.125561_g321_i0	PRJNA229468	334	272	1.125561	3.06152592	Acinetobacter baumannii	470	Bacteria	Bacteria	62	7.73e-9	NR	APX42443.1	470	g321	i0	70.8	0.529411764705882	48	14	52.9	0	146	3	6	53	APX42443.1 beta-lactamase TEM-1, partial [Acinetobacter baumannii]	diamond	144	62	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
31355853	31355853	PRJNA229468_S_NODE_856_length_181_cov_1.136364_g843_i0	PRJNA229468	856	181	1.136364	2.05681884	root	1	Root_unresolved	Root_unresolved	91.3	4.03e-21	NR	WP_138062938.1	470	g843	i0	82.8	239.270718232044	58	10	96.1	0	1	174	139	196	WP_138062938.1 30S ribosomal protein S7, partial [Acinetobacter baumannii]	diamond	43308	92	0.992391304347826	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii

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