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

32 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax_superkingdom = "Bacteria"

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_clade	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
3768316	3768316	PRJNA796639_P_NODE_2963_length_326_cov_0.881423_g2838_i0	PRJNA796639	2963	326	0.881423	2.87343898	Hoylesella	2974257	Bacteria	Bacteria	479	1.1899999999999996e-130	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g2838	i0	93.03	253.613496932515	330	19	100	3	1	326	210154	210483	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	82678	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
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
5044755	5044755	PRJNA796639_P_NODE_6424_length_247_cov_0.885057_g6299_i0	PRJNA796639	6424	247	0.885057	2.18609079	Atribacterales	2847775	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2719065861\|gb\|CP121689.1\|	3039681	g6299	i0	100	0.226720647773279	28	0	11	0	86	113	2121642	2121669	Thermatribacter velox strain B11 chromosome, complete genome	blastn	56	52.8	1	Bacteria		Pseudomonadati	Atribacterota	Atribacteria	Atribacterales	Thermatribacteraceae	Thermatribacter	Thermatribacter velox
7158942	7158942	PRJNA796639_P_NODE_6286_length_248_cov_0.880000_g6161_i0	PRJNA796639	6286	248	0.88	2.1824	Mycolicibacterium chitae	1792	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1806410789\|dbj\|AP022604.1\|	1792	g6161	i0	100	0.233870967741935	29	0	12	0	28	56	4866058	4866086	Mycolicibacterium chitae JCM 12403 DNA, nearly complete genome	blastn	58	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium chitae
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
9708761	9708761	PRJNA796639_P_NODE_6228_length_248_cov_0.880000_g6103_i0	PRJNA796639	6228	248	0.88	2.1824	uncultured Eubacteriales bacterium	172733	Bacteria	Bacteria	340	4.27e-89	NTclustered	gi\|2729058706\|emb\|OZ007006.1\|	172733	g6103	i0	91.498	8.96774193548387	247	21	99	0	1	247	7078	7324	MAG: uncultured Eubacteriales bacterium isolate metabat2_pooled_hifiasm.126 MAG genome assembly, chromosome: 1	blastn	2224	340	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
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
12260021	12260021	PRJNA796639_P_NODE_4810_length_268_cov_1.579487_g4685_i0	PRJNA796639	4810	268	1.579487	4.23302516	Apilactobacillus apisilvae	2923364	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2239972674\|gb\|CP093362.1\|	2923364	g4685	i0	100	0.108208955223881	29	0	11	0	72	100	96647	96619	Apilactobacillus apisilvae strain SG5_A10 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Apilactobacillus	Apilactobacillus apisilvae
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
12260064	12260064	PRJNA796639_P_NODE_7370_length_243_cov_0.905882_g7245_i0	PRJNA796639	7370	243	0.905882	2.20129326	Nocardioides sp. S5	2017486	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g7245	i0	100	230.102880658436	243	0	100	0	1	243	1843263	1843505	Nocardioides sp. S5 chromosome, complete genome	blastn	55915	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
12696253	12696253	PRJNA796639_P_NODE_4370_length_278_cov_1.502439_g4245_i0	PRJNA796639	4370	278	1.502439	4.17678042	Elizabethkingia	308865	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g4245	i0	100	0.201438848920863	28	0	10	0	109	136	1006673	1006646	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
12696259	12696259	PRJNA796639_P_NODE_7830_length_241_cov_0.916667_g7705_i0	PRJNA796639	7830	241	0.916667	2.20916747	Peribacillus	2675229	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1906925978\|gb\|CP050509.1\|	421767	g7705	i0	99.585	1139.9377593361	241	1	100	0	1	241	5138452	5138692	Peribacillus butanolivorans strain KJ40 chromosome, complete genome	blastn	274725	440	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus butanolivorans
13534145	13534145	PRJNA796639_P_NODE_3431_length_304_cov_1.129870_g3306_i0	PRJNA796639	3431	304	1.12987	3.4348048	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g3306	i0	100	0.0921052631578947	28	0	9	0	254	281	995425	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
14809083	14809083	PRJNA796639_P_NODE_5632_length_251_cov_0.865169_g5507_i0	PRJNA796639	5632	251	0.865169	2.17157419	Crocosphaera subtropica	2546360	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g5507	i0	100	0.111553784860558	28	0	11	0	24	51	2156137	2156164	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
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
16519500	16519500	PRJNA796639_P_NODE_1313_length_491_cov_1.031100_g1188_i0	PRJNA796639	1313	491	1.0311	5.062701	Cutibacterium	1912216	Bacteria	Bacteria	898	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g1188	i0	99.594	270.720977596741	493	0	100	1	1	491	608443	608935	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	132924	898	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19068301	19068301	PRJNA796639_P_NODE_4275_length_280_cov_1.681159_g4150_i0	PRJNA796639	4275	280	1.681159	4.7072452	Nocardioides	1839	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1605178659\|gb\|CP038267.1\|	2518370	g4150	i0	98.929	235.482142857143	280	3	100	0	1	280	573651	573372	Nocardioides euryhalodurans strain MMS17-SY117 chromosome, complete genome	blastn	65935	501	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides euryhalodurans
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
22457701	22457701	PRJNA796639_P_NODE_6658_length_246_cov_1.138728_g6533_i0	PRJNA796639	6658	246	1.138728	2.80127088	Chryseobacterium gleum	250	Bacteria	Bacteria	440	4.0599999999999984e-119	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g6533	i0	99.18	304.036585365854	244	2	99	0	3	246	169515	169758	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	74793	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
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
23733325	23733325	PRJNA796639_P_NODE_5999_length_249_cov_0.875000_g5874_i0	PRJNA796639	5999	249	0.875	2.17875	Pedobacter sp. HDW13	2714940	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g5874	i0	100	0.112449799196787	28	0	11	0	80	107	3216799	3216826	Pedobacter sp. HDW13 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
24168233	24168233	PRJNA796639_P_NODE_5659_length_251_cov_0.865169_g5534_i0	PRJNA796639	5659	251	0.865169	2.17157419	Lactiplantibacillus	2767842	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2739944818\|emb\|OZ061355.1\|	1589	g5534	i0	100	480.358565737052	251	0	100	0	1	251	1279560	1279310	Lactiplantibacillus pentosus isolate Lactiplantibacillus pentosus CNRZ1547 genome assembly, chromosome: 1	blastn	120570	464	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus pentosus
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
25006969	25006969	PRJNA796639_P_NODE_6600_length_247_cov_0.885057_g6475_i0	PRJNA796639	6600	247	0.885057	2.18609079	Enterococcus faecalis	1351	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1963785894\|emb\|LR962464.1\|	1351	g6475	i0	100	100	247	0	100	0	1	247	2123226	2122980	Enterococcus faecalis isolate 28157_4#317 genome assembly, chromosome: 1	blastn	24700	457	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
25443370	25443370	PRJNA796639_P_NODE_1860_length_410_cov_2.323442_g1735_i0	PRJNA796639	1860	410	2.323442	9.5261122	Cutibacterium	1912216	Bacteria	Bacteria	758	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1735	i0	100	250.648780487805	410	0	100	0	1	410	55374	55783	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	102766	758	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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