metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA971676" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA971676" and tax_phylum = "Actinomycetota"

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
1266358	1266358	PRJNA971676_P_NODE_15621_length_249_cov_0.875000_g15532_i0	PRJNA971676	15621	249	0.875	2.17875	Bifidobacterium	1678	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g15532	i0	100	66.9598393574297	249	0	100	0	1	249	383249	383001	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16673	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
1266367	1266367	PRJNA971676_P_NODE_16461_length_248_cov_1.760000_g16372_i0	PRJNA971676	16461	248	1.76	4.3648	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g16372	i0	100	310.322580645161	248	0	100	0	1	248	53795	53548	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	76960	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
1266483	1266483	PRJNA971676_P_NODE_4901_length_373_cov_0.913333_g4812_i0	PRJNA971676	4901	373	0.913333	3.40673209	Bifidobacterium	1678	Bacteria	Bacteria	684	0	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g4812	i0	99.732	58	373	1	100	0	1	373	41452	41824	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	21634	684	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
2542105	2542105	PRJNA971676_P_NODE_20662_length_244_cov_0.900585_g20573_i0	PRJNA971676	20662	244	0.900585	2.1974274	Bifidobacterium	1678	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g20573	i0	100	66	244	0	100	0	1	244	1209942	1210185	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16104	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
3818378	3818378	PRJNA971676_P_NODE_15703_length_249_cov_0.875000_g15614_i0	PRJNA971676	15703	249	0.875	2.17875	Bifidobacterium	1678	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g15614	i0	100	66	249	0	100	0	1	249	1451926	1452174	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16434	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
3818396	3818396	PRJNA971676_P_NODE_17363_length_247_cov_1.770115_g17274_i0	PRJNA971676	17363	247	1.770115	4.37218405	Bifidobacterium	1678	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17274	i0	100	101.801619433198	247	0	100	0	1	247	470630	470384	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	25145	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
4773027	4773027	PRJNA971676_P_NODE_22144_length_242_cov_0.911243_g22055_i0	PRJNA971676	22144	242	0.911243	2.20520806	Yimella sp. cx-51	2770551	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|2019559805\|gb\|CP072113.1\|	2770551	g22055	i0	87.654	12.1735537190083	243	28	100	2	1	242	41459	41700	Yimella sp. cx-51 chromosome, complete genome	blastn	2946	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Yimella	Yimella sp. cx-51
6370503	6370503	PRJNA971676_P_NODE_17065_length_248_cov_0.880000_g16976_i0	PRJNA971676	17065	248	0.88	2.1824	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g16976	i0	100	66	248	0	100	0	1	248	625340	625093	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16368	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
8919245	8919245	PRJNA971676_P_NODE_15607_length_249_cov_0.886364_g15518_i0	PRJNA971676	15607	249	0.886364	2.20704636	Corynebacterium	1716	Bacteria	Bacteria	418	1.9299999999999995e-112	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g15518	i0	97.177	361.224899598394	248	6	99	1	1	247	624000	624247	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	89945	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
8919273	8919273	PRJNA971676_P_NODE_17607_length_247_cov_0.885057_g17518_i0	PRJNA971676	17607	247	0.885057	2.18609079	Bifidobacterium	1678	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17518	i0	99.595	66	247	1	100	0	1	247	1556586	1556340	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16302	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
10195068	10195068	PRJNA971676_P_NODE_14428_length_251_cov_0.865169_g14339_i0	PRJNA971676	14428	251	0.865169	2.17157419	Bifidobacterium	1678	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g14339	i0	99.602	93.1713147410359	251	1	100	0	1	251	658891	658641	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	23386	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
11148285	11148285	PRJNA971676_P_NODE_21269_length_243_cov_0.905882_g21180_i0	PRJNA971676	21269	243	0.905882	2.20129326	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253825\|emb\|OY969809.1\|	3039803	g21180	i0	100	0.11522633744856	28	0	12	0	199	226	2710345	2710372	MAG: uncultured Actinomycetota bacterium isolate MFD05502.bin.1.34 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
14020261	14020261	PRJNA971676_P_NODE_17931_length_247_cov_0.885057_g17842_i0	PRJNA971676	17931	247	0.885057	2.18609079	Bifidobacterium	1678	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17842	i0	100	66.3481781376518	247	0	100	0	1	247	69044	69290	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16388	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
15294378	15294378	PRJNA971676_P_NODE_16932_length_248_cov_0.880000_g16843_i0	PRJNA971676	16932	248	0.88	2.1824	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g16843	i0	100	73.508064516129	248	0	100	0	1	248	334449	334202	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	18230	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
17843930	17843930	PRJNA971676_P_NODE_20814_length_244_cov_0.900585_g20725_i0	PRJNA971676	20814	244	0.900585	2.1974274	Bifidobacterium	1678	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g20725	i0	100	66	244	0	100	0	1	244	1710898	1710655	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16104	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
19117824	19117824	PRJNA971676_P_NODE_17235_length_248_cov_0.880000_g17146_i0	PRJNA971676	17235	248	0.88	2.1824	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17146	i0	100	92.2620967741936	248	0	100	0	1	248	1041574	1041821	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	22881	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
19117981	19117981	PRJNA971676_P_NODE_8595_length_304_cov_1.000000_g8506_i0	PRJNA971676	8595	304	1	3.04	Bifidobacterium	1678	Bacteria	Bacteria	562	1.06e-155	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g8506	i0	100	65.8914473684211	304	0	100	0	1	304	65277	64974	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	20031	562	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
21668726	21668726	PRJNA971676_P_NODE_15957_length_249_cov_0.875000_g15868_i0	PRJNA971676	15957	249	0.875	2.17875	Bifidobacterium	1678	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g15868	i0	99.598	59	249	1	100	0	1	249	1515985	1516233	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	14691	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
21668750	21668750	PRJNA971676_P_NODE_18317_length_246_cov_0.890173_g18228_i0	PRJNA971676	18317	246	0.890173	2.18982558	Bifidobacterium	1678	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g18228	i0	100	65.890243902439	246	0	100	0	1	246	1858575	1858820	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16209	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
21668834	21668834	PRJNA971676_P_NODE_4237_length_393_cov_1.662500_g4148_i0	PRJNA971676	4237	393	1.6625	6.533625	Actinomycetes	1760	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|610391492\|gb\|CP006842.1\|	1404245	g4148	i0	96.875	0.155216284987277	32	1	8	0	297	328	1711837	1711868	Corynebacterium glyciniphilum AJ 3170, complete genome	blastn	61	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glyciniphilum
22944108	22944108	PRJNA971676_P_NODE_17158_length_248_cov_0.880000_g17069_i0	PRJNA971676	17158	248	0.88	2.1824	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17069	i0	100	66.0120967741936	248	0	100	0	1	248	571334	571581	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16371	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
22944115	22944115	PRJNA971676_P_NODE_18038_length_247_cov_0.885057_g17949_i0	PRJNA971676	18038	247	0.885057	2.18609079	Bifidobacterium	1678	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17949	i0	100	66.0242914979757	247	0	100	0	1	247	125158	125404	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	16308	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
23897194	23897194	PRJNA971676_P_NODE_23679_length_241_cov_0.886905_g23590_i0	PRJNA971676	23679	241	0.886905	2.13744105	Arthrobacter sp. FW305-BF8	2879617	Bacteria	Bacteria	219	2.02e-52	NTclustered	gi\|2186457916\|gb\|CP084561.1\|	2879617	g23590	i0	83.475	55.9128630705394	236	37	98	2	1	235	3430197	3430431	Arthrobacter sp. FW305-BF8 chromosome, complete genome	blastn	13475	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. FW305-BF8
25170912	25170912	PRJNA971676_P_NODE_5520_length_357_cov_0.950704_g5431_i0	PRJNA971676	5520	357	0.950704	3.39401328	Leucobacter sp. CX169	2813744	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1996370406\|gb\|CP071051.1\|	2813744	g5431	i0	100	0.0812324929971989	29	0	8	0	146	174	1727893	1727865	Leucobacter sp. CX169 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter sp. CX169
25492920	25492920	PRJNA971676_P_NODE_17220_length_248_cov_0.880000_g17131_i0	PRJNA971676	17220	248	0.88	2.1824	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1216648486\|gb\|CP017098.1\|	28025	g17131	i0	100	303.782258064516	248	0	100	0	1	248	1481892	1482139	Bifidobacterium animalis strain BL3 chromosome, complete genome	blastn	75338	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis

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