metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJDB14274" and tax

17 rows where analysis = "blastn", bioproject = "PRJDB14274" 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
8555	8555	PRJDB14274_S_NODE_2121_length_420_cov_1.253482_g2043_i0	PRJDB14274	2121	420	1.253482	5.2646244	Lysobacter sp. FW306-1B-D06B	3140250	Bacteria	Bacteria	58.4	8.69e-4	NTclustered	gi\|2720695138\|gb\|CP151802.1\|	3140250	g2043	i0	100	0.685714285714286	31	0	7	0	305	335	1806208	1806238	Lysobacter sp. FW306-1B-D06B chromosome, complete genome	blastn	288	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter sp. FW306-1B-D06B
8581	8581	PRJDB14274_S_NODE_7021_length_239_cov_1.303371_g6943_i0	PRJDB14274	7021	239	1.303371	3.11505669	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	178	3.4e-40	NTclustered	gi\|2621703253\|emb\|OY762427.1\|	1913988	g6943	i0	80.591	8.01255230125523	237	41	98	5	4	237	3621380	3621146	MAG: Alphaproteobacteria bacterium isolate ccf0328c-cffc-48f6-8afa-02e3c565a3a4 genome assembly, chromosome: 1	blastn	1915	178	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
1282789	1282789	PRJDB14274_S_NODE_2822_length_364_cov_16.293729_g2744_i0	PRJDB14274	2822	364	16.293729	59.30917356	Actinobacillus genomosp. 2	230709	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2489107107\|gb\|CP103807.1\|	230709	g2744	i0	96.97	0.0906593406593407	33	0	9	1	297	329	1524494	1524463	Actinobacillus genomosp. 2 strain CCUG15571 chromosome, complete genome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus genomosp. 2
1282815	1282815	PRJDB14274_S_NODE_6662_length_245_cov_1.380435_g6584_i0	PRJDB14274	6662	245	1.380435	3.38206575	Pseudomonas sp. C27(2019)	2604941	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|1755685660\|gb\|CP043320.1\|	2604941	g6584	i0	97.143	516.016326530612	245	7	100	0	1	245	352748	352504	Pseudomonas sp. C27(2019) chromosome, complete genome	blastn	126424	414	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. C27(2019)
6386850	6386850	PRJDB14274_S_NODE_5606_length_264_cov_2.182266_g5528_i0	PRJDB14274	5606	264	2.182266	5.76118224	Roseateles sp. So40a	3400226	Bacteria	Bacteria	455	1.57e-123	NTclustered	gi\|2917352602\|gb\|CP182288.1\|	3400226	g5528	i0	97.727	182.780303030303	264	6	100	0	1	264	4101	3838	Roseateles sp. So40a chromosome, complete genome	blastn	48254	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles sp. So40a
10211427	10211427	PRJDB14274_S_NODE_5229_length_273_cov_1.537736_g5151_i0	PRJDB14274	5229	273	1.537736	4.19801928	Aquabacterium olei	1296669	Bacteria	Bacteria	416	7.709999999999998e-112	NTclustered	gi\|1387992375\|gb\|CP029210.1\|	1296669	g5151	i0	94.203	318.413919413919	276	11	100	5	1	273	276921	277194	Aquabacterium olei strain NBRC 110486 chromosome, complete genome	blastn	86927	416	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium olei
11184258	11184258	PRJDB14274_S_NODE_5409_length_269_cov_1.182692_g5331_i0	PRJDB14274	5409	269	1.182692	3.18144148	Pseudomonadaceae	135621	Bacteria	Bacteria	357	4.66e-94	NTclustered	gi\|2276787761\|gb\|CP073346.1\|	556533	g5331	i0	90.706	426.542750929368	269	24	100	1	1	269	1663129	1662862	Pseudomonas benzenivorans strain D13-4 chromosome, complete genome	blastn	114740	357	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas benzenivorans
11184263	11184263	PRJDB14274_S_NODE_9149_length_210_cov_1.201342_g9071_i0	PRJDB14274	9149	210	1.201342	2.5228182	Pseudomonadaceae	135621	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|2195309741\|gb\|OM736060.1\|	306	g9071	i0	99.524	222.961904761905	210	1	100	0	1	210	10	219	Pseudomonas sp. strain DP-17 16S ribosomal RNA gene, partial sequence	blastn	46822	383	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp.
11486446	11486446	PRJDB14274_S_NODE_1530_length_493_cov_2.224537_g1453_i0	PRJDB14274	1530	493	2.224537	10.96696741	Bradyrhizobium sp. NP1	3049772	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2529304879\|gb\|CP127385.1\|	3049772	g1453	i0	100	0.344827586206897	30	0	6	0	110	139	5124903	5124874	Bradyrhizobium sp. NP1 chromosome, complete genome	blastn	170	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. NP1
11486465	11486465	PRJDB14274_S_NODE_5870_length_259_cov_1.202020_g5792_i0	PRJDB14274	5870	259	1.20202	3.1132318	Aquipseudomonas campi	2731681	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1876483579\|gb\|CP053697.2\|	2731681	g5792	i0	96.875	0.123552123552124	32	1	12	0	54	85	2709033	2709002	Aquipseudomonas campi strain S1-A32-2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas campi
11486471	11486471	PRJDB14274_S_NODE_7270_length_235_cov_1.264368_g7192_i0	PRJDB14274	7270	235	1.264368	2.9712648	Serratia rubidaea	61652	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874137494\|dbj\|AP038874.1\|	61652	g7192	i0	96.97	0.140425531914894	33	0	14	1	91	123	3050148	3050117	Serratia rubidaea SY163 DNA, complete genome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia rubidaea
13734449	13734449	PRJDB14274_S_NODE_7051_length_238_cov_4.762712_g6973_i0	PRJDB14274	7051	238	4.762712	11.33525456	Haemophilus	724	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2087650663\|dbj\|AP024093.1\|	726	g6973	i0	100	0.247899159663866	28	0	12	0	165	192	443337	443310	Haemophilus haemolyticus 2019-19 DNA, complete genome	blastn	59	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus haemolyticus
15310643	15310643	PRJDB14274_S_NODE_4953_length_279_cov_3.091743_g4875_i0	PRJDB14274	4953	279	3.091743	8.62596297	Candidatus Desulfobacillus denitrificans	2608985	Bacteria	Bacteria	152	2.4599999999999995e-32	NTclustered	gi\|1996214876\|dbj\|AP021857.1\|	2608985	g4875	i0	81.675	60.4874551971326	191	28	67	3	92	277	1499085	1499273	Candidatus Desulfobacillus denitrificans DNA, complete genome	blastn	16876	152	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria			Candidatus Desulfobacillus	Candidatus Desulfobacillus denitrificans
18832721	18832721	PRJDB14274_S_NODE_6295_length_251_cov_1.431579_g6217_i0	PRJDB14274	6295	251	1.431579	3.59326329	Paraburkholderia	1822464	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|470477816\|ref\|NR_076411.1\|	36873	g6217	i0	100	261.03984063745	251	0	100	0	1	251	1184	1434	Burkholderia xenovorans strain LB400 23S ribosomal RNA gene, complete sequence	blastn	65521	464	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Paraburkholderia	Paraburkholderia xenovorans
21383121	21383121	PRJDB14274_S_NODE_1657_length_474_cov_1.256659_g1579_i0	PRJDB14274	1657	474	1.256659	5.95656366	Rhodanobacteraceae	1775411	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|664782987\|gb\|CP008884.1\|	1217721	g1579	i0	100	0.118143459915612	28	0	6	0	6	33	2854417	2854390	Dyella japonica A8, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Dyella	Dyella japonica
21383125	21383125	PRJDB14274_S_NODE_3017_length_352_cov_1.505155_g2939_i0	PRJDB14274	3017	352	1.505155	5.2981456	root	1	Root_unresolved	Root_unresolved	619	7.269999999999999e-173	NTclustered	gi\|2548169491\|gb\|CP129672.1\|	285	g2939	i0	99.128	385.965909090909	344	3	98	0	1	344	1249194	1249537	Comamonas testosteroni strain MWF001 chromosome, complete genome	blastn	135860	619	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas testosteroni
21685140	21685140	PRJDB14274_S_NODE_5558_length_265_cov_1.950980_g5480_i0	PRJDB14274	5558	265	1.95098	5.170097	Pantoea agglomerans	549	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2175115189\|gb\|CP090207.1\|	549	g5480	i0	100	0.105660377358491	28	0	11	0	202	229	3779089	3779062	Pantoea agglomerans strain HJS002 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea agglomerans

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