metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA796639" 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
3331624	3331624	PRJNA796639_P_NODE_6563_length_247_cov_0.885057_g6438_i0	PRJNA796639	6563	247	0.885057	2.18609079	Comamonadaceae bacterium OS-1	2993872	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2328124537\|dbj\|AP026969.1\|	2993872	g6438	i0	94.286	0.1417004048583	35	1	14	1	22	55	4878262	4878228	Comamonadaceae bacterium OS-1 DNA, nearly complete genome	blastn	35	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium OS-1
4608871	4608871	PRJNA796639_P_NODE_3244_length_312_cov_1.288703_g3119_i0	PRJNA796639	3244	312	1.288703	4.02075336	Stenotrophomonas maltophilia	40324	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1192692663\|gb\|CP015612.1\|	40324	g3119	i0	96.97	0.208333333333333	33	1	11	0	254	286	4433301	4433269	Stenotrophomonas maltophilia strain OUC_Est10, complete genome	blastn	65	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia
5044753	5044753	PRJNA796639_P_NODE_5444_length_252_cov_2.547486_g5319_i0	PRJNA796639	5444	252	2.547486	6.41966472	Comamonadaceae	80864	Bacteria	Bacteria	436	5.4e-118	NTclustered	gi\|1373249612\|gb\|CP028292.1\|	80867	g5319	i0	98.008	222.480158730159	251	5	99	0	1	251	5231218	5230968	Paracidovorax avenae strain INDB2 chromosome	blastn	56065	436	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Paracidovorax	Paracidovorax avenae
7594742	7594742	PRJNA796639_P_NODE_2726_length_341_cov_1.156716_g2601_i0	PRJNA796639	2726	341	1.156716	3.94440156	Comamonadaceae	80864	Bacteria	Bacteria	595	1.1899999999999999e-165	NTclustered	gi\|1586158954\|gb\|CP031395.1\|	80880	g2601	i0	98.235	199.718475073314	340	6	99	0	1	340	392931	392592	Hylemonella gracilis strain NS1 chromosome	blastn	68104	601	0.990016638935108	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hylemonella	Hylemonella gracilis
7594752	7594752	PRJNA796639_P_NODE_5386_length_254_cov_1.309392_g5261_i0	PRJNA796639	5386	254	1.309392	3.32585568	Enterobacteriaceae	543	Bacteria	Bacteria	459	1.1599999999999999e-124	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g5261	i0	99.213	665.775590551181	254	2	100	0	1	254	186540	186287	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	169107	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8433618	8433618	PRJNA796639_P_NODE_5327_length_255_cov_2.318681_g5202_i0	PRJNA796639	5327	255	2.318681	5.91263655	Pseudomonas congelans	200452	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2045689390\|gb\|CP053030.1\|	200452	g5202	i0	100	0.227450980392157	29	0	11	0	171	199	2688761	2688733	Pseudomonas congelans strain 508 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas congelans
8433639	8433639	PRJNA796639_P_NODE_6267_length_248_cov_0.880000_g6142_i0	PRJNA796639	6267	248	0.88	2.1824	Candidatus Nasuia deltocephalincola	1160784	Bacteria	Bacteria	60.2	1.34e-4	NTclustered	gi\|2293493133\|gb\|CP094186.1\|	1160784	g6142	i0	94.872	0.157258064516129	39	1	15	1	201	238	61594	61556	Candidatus Nasuia deltocephalinicola strain KIMY chromosome, complete genome	blastn	39	60.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria			Candidatus Nasuia	Candidatus Nasuia deltocephalincola
8433660	8433660	PRJNA796639_P_NODE_7567_length_242_cov_0.911243_g7442_i0	PRJNA796639	7567	242	0.911243	2.20520806	Acinetobacter johnsonii	40214	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1995442560\|gb\|CP070867.1\|	40214	g7442	i0	100	193.342975206612	242	0	100	0	1	242	26696	26455	Acinetobacter johnsonii strain XY27 plasmid plas1, complete sequence	blastn	46789	448	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
10984486	10984486	PRJNA796639_P_NODE_6509_length_247_cov_0.885057_g6384_i0	PRJNA796639	6509	247	0.885057	2.18609079	Vibrio misgurnus	2993714	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2482491404\|gb\|CP113242.1\|	2993714	g6384	i0	99.19	2	247	2	100	0	1	247	139655	139409	Vibrio sp. gvc chromosome 2, complete sequence	blastn	494	446	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio misgurnus
12260031	12260031	PRJNA796639_P_NODE_5630_length_251_cov_0.865169_g5505_i0	PRJNA796639	5630	251	0.865169	2.17157419	Agrobacterium tumefaciens	358	Bacteria	Bacteria	348	2.5900000000000005e-91	NTclustered	gi\|1633808627\|gb\|CP039889.1\|	358	g5505	i0	91.633	75.800796812749	251	21	100	0	1	251	1906224	1906474	Agrobacterium tumefaciens strain CFBP5499 chromosome linear, complete sequence	blastn	19026	348	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Agrobacterium	Agrobacterium tumefaciens
12260044	12260044	PRJNA796639_P_NODE_6210_length_248_cov_0.880000_g6085_i0	PRJNA796639	6210	248	0.88	2.1824	Vibrio misgurnus	2993714	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2482491403\|gb\|CP113241.1\|	2993714	g6085	i0	100	2.1008064516129	248	0	100	0	1	248	1286190	1285943	Vibrio sp. gvc chromosome 1, complete sequence	blastn	521	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio misgurnus
15245050	15245050	PRJNA796639_P_NODE_5992_length_249_cov_0.875000_g5867_i0	PRJNA796639	5992	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	449	6.840000000000001e-122	NTclustered	gi\|2499340541\|gb\|CP123918.1\|	106648	g5867	i0	99.197	671.951807228916	249	2	100	0	1	249	24997	25245	Acinetobacter bereziniae strain UCO-554 chromosome, complete genome	blastn	167316	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter bereziniae
19907318	19907318	PRJNA796639_P_NODE_4576_length_273_cov_2.100000_g4451_i0	PRJNA796639	4576	273	2.1	5.733	Buchnera aphidicola	9	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2736164353\|gb\|CP140035.1\|	3093910	g4451	i0	100	0.10989010989011	30	0	11	0	49	78	431365	431336	MAG: Buchnera aphidicola (Nurudea shiraii) isolate R20 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
22894247	22894247	PRJNA796639_P_NODE_5398_length_254_cov_1.000000_g5273_i0	PRJNA796639	5398	254	1	2.54	Acinetobacter	469	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|1958425625\|gb\|CP068206.1\|	40214	g5273	i0	100	631.090551181102	254	0	100	0	1	254	1095934	1095681	Acinetobacter johnsonii strain FDAARGOS_1092 chromosome, complete genome	blastn	160297	470	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
25006944	25006944	PRJNA796639_P_NODE_4520_length_275_cov_1.311881_g4395_i0	PRJNA796639	4520	275	1.311881	3.60767275	Aurantimonas sp. HBX-1	2906072	Bacteria	Bacteria	183	8.59e-42	NTclustered	gi\|2174753144\|gb\|CP090066.1\|	2906072	g4395	i0	78.986	3.42545454545455	276	53	100	4	1	275	3054616	3054345	Aurantimonas sp. HBX-1 chromosome, complete genome	blastn	942	183	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Aurantimonadaceae	Aurantimonas	Aurantimonas sp. HBX-1

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