metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA902515" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA902515" 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
2156586	2156586	PRJNA902515_P_NODE_14202_length_246_cov_0.901734_g14179_i0	PRJNA902515	14202	246	0.901734	2.21826564	Collinsella aerofaciens	74426	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1526295663\|gb\|CP024960.1\|	74426	g14179	i0	100	65.0934959349593	246	0	100	0	1	246	1290117	1289872	Collinsella aerofaciens strain C11 chromosome, complete genome	blastn	16013	455	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella aerofaciens
2156591	2156591	PRJNA902515_P_NODE_14442_length_246_cov_0.901734_g14419_i0	PRJNA902515	14442	246	0.901734	2.21826564	Schaalia odontolytica	1660	Bacteria	Bacteria	388	1.49e-103	NTclustered	gi\|1780452079\|gb\|CP046315.1\|	1660	g14419	i0	95.122	1.97967479674797	246	12	100	0	1	246	2313206	2312961	Schaalia odontolytica strain FDAARGOS_732 chromosome, complete genome	blastn	487	388	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
3798602	3798602	PRJNA902515_P_NODE_12683_length_250_cov_0.881356_g12660_i0	PRJNA902515	12683	250	0.881356	2.20339	Bifidobacterium	1678	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2128320732\|dbj\|AP024712.1\|	1681	g12660	i0	100	89.828	250	0	100	0	1	250	632686	632935	Bifidobacterium bifidum YIT 10347 DNA, complete genome	blastn	22457	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium bifidum
5074771	5074771	PRJNA902515_P_NODE_11244_length_253_cov_0.866667_g11221_i0	PRJNA902515	11244	253	0.866667	2.19266751	Bacillati	1783272	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|761598910\|emb\|LN824140.1\|	1682	g11221	i0	100	104.584980237154	253	0	100	0	1	253	1227328	1227076	Bifidobacterium longum subsp. infantis genome assembly Bifidobacterium longum subsp. infantis CECT7210, chromosome : I	blastn	26460	468	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
7259245	7259245	PRJNA902515_P_NODE_11926_length_251_cov_0.876404_g11903_i0	PRJNA902515	11926	251	0.876404	2.19977404	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g11903	i0	100	12	251	0	100	0	1	251	725569	725319	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	3012	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
7259288	7259288	PRJNA902515_P_NODE_13466_length_248_cov_0.891429_g13443_i0	PRJNA902515	13466	248	0.891429	2.21074392	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g13443	i0	99.597	84.2177419354839	248	1	100	0	1	248	1381153	1381400	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	20886	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
8534065	8534065	PRJNA902515_P_NODE_12087_length_251_cov_0.876404_g12064_i0	PRJNA902515	12087	251	0.876404	2.19977404	Collinsella sp. i05-0019-G5	3132705	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2777581102\|dbj\|AP031421.1\|	3132705	g12064	i0	99.203	4	251	2	100	0	1	251	1918990	1919240	Collinsella sp. i05-0019-G5 DNA, complete genome	blastn	1004	453	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella sp. i05-0019-G5
8534138	8534138	PRJNA902515_P_NODE_14307_length_246_cov_0.901734_g14284_i0	PRJNA902515	14307	246	0.901734	2.21826564	Corynebacterium matruchotii	43768	Bacteria	Bacteria	361	3.25e-95	NTclustered	gi\|2006291222\|gb\|CP050134.2\|	43768	g14284	i0	93.089	2	246	17	100	0	1	246	2041172	2040927	Corynebacterium matruchotii strain ATCC 14266 chromosome, complete genome	blastn	492	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
10175184	10175184	PRJNA902515_P_NODE_11588_length_252_cov_0.871508_g11565_i0	PRJNA902515	11588	252	0.871508	2.19620016	Bifidobacterium	1678	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2179090907\|gb\|CP090598.1\|	28026	g11565	i0	100	99.8928571428571	252	0	100	0	1	252	1033878	1033627	Bifidobacterium pseudocatenulatum strain JCLA3 chromosome, complete genome	blastn	25173	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
10175186	10175186	PRJNA902515_P_NODE_12088_length_251_cov_0.876404_g12065_i0	PRJNA902515	12088	251	0.876404	2.19977404	Bifidobacterium	1678	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2179090907\|gb\|CP090598.1\|	28026	g12065	i0	99.203	12	251	2	100	0	1	251	1507817	1508067	Bifidobacterium pseudocatenulatum strain JCLA3 chromosome, complete genome	blastn	3012	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
11084790	11084790	PRJNA902515_P_NODE_12169_length_251_cov_0.876404_g12146_i0	PRJNA902515	12169	251	0.876404	2.19977404	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g12146	i0	99.602	218.509960159363	251	1	100	0	1	251	2139560	2139810	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	54846	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
11084836	11084836	PRJNA902515_P_NODE_13769_length_247_cov_0.896552_g13746_i0	PRJNA902515	13769	247	0.896552	2.21448344	Actinomyces sp. oral taxon 414	712122	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|925194983\|gb\|CP012590.1\|	712122	g13746	i0	97.826	1.23886639676113	138	2	55	1	1	137	2355899	2356036	Actinomyces sp. oral taxon 414 strain F0588, complete genome	blastn	306	237	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces sp. oral taxon 414
11085078	11085078	PRJNA902515_P_NODE_8829_length_280_cov_1.038647_g8806_i0	PRJNA902515	8829	280	1.038647	2.9082116	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	390	4.809999999999999e-104	NTclustered	gi\|2874253834\|emb\|OY969884.1\|	3039803	g8806	i0	92.058	245.6	277	22	99	0	1	277	33196	33472	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.2 genome assembly, chromosome: 1	blastn	68768	390	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
12726194	12726194	PRJNA902515_P_NODE_12370_length_250_cov_0.881356_g12347_i0	PRJNA902515	12370	250	0.881356	2.20339	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|1979349502\|gb\|CP069279.1\|	1681	g12347	i0	100	32.96	250	0	100	0	1	250	1833004	1832755	Bifidobacterium bifidum strain HN002 chromosome, complete genome	blastn	8240	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium bifidum
12726202	12726202	PRJNA902515_P_NODE_15350_length_244_cov_0.912281_g15327_i0	PRJNA902515	15350	244	0.912281	2.22596564	Cutibacterium	1912216	Bacteria	Bacteria	448	2.4e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g15327	i0	100	261.040983606557	242	0	99	0	1	242	55571	55812	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	63694	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14000571	14000571	PRJNA902515_P_NODE_11351_length_253_cov_0.866667_g11328_i0	PRJNA902515	11351	253	0.866667	2.19266751	Bifidobacterium	1678	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1064281795\|gb\|CP016019.1\|	1679	g11328	i0	100	70.1818181818182	253	0	100	0	1	253	268735	268483	Bifidobacterium longum subsp. longum strain AH1206 chromosome, complete genome	blastn	17756	468	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
15274599	15274599	PRJNA902515_P_NODE_10992_length_254_cov_0.839779_g10969_i0	PRJNA902515	10992	254	0.839779	2.13303866	Geodermatophilaceae	85030	Bacteria	Bacteria	418	1.9699999999999995e-112	NTclustered	gi\|470468736\|ref\|NR_076134.1\|	1861	g10969	i0	98.723	388.590551181102	235	3	93	0	1	235	40	274	Geodermatophilus obscurus strain DSM 43160 23S ribosomal RNA gene, complete sequence	blastn	98702	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Geodermatophilus	Geodermatophilus obscurus
15274607	15274607	PRJNA902515_P_NODE_13452_length_248_cov_0.891429_g13429_i0	PRJNA902515	13452	248	0.891429	2.21074392	Bifidobacterium	1678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2713080865\|gb\|CP150432.1\|	1679	g13429	i0	100	99.6612903225806	248	0	100	0	1	248	118225	117978	Bifidobacterium longum subsp. longum strain FB1-1 chromosome, complete genome	blastn	24716	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
17459545	17459545	PRJNA902515_P_NODE_4134_length_374_cov_1.033223_g4111_i0	PRJNA902515	4134	374	1.033223	3.86425402	Modestobacter sp. L9-4	2851567	Bacteria	Bacteria	547	3.7199999999999985e-151	NTclustered	gi\|2063288892\|gb\|CP077800.1\|	2851567	g4111	i0	93.316	498.328877005348	374	19	100	4	1	374	2999	2632	Modestobacter sp. L9-4 chromosome, complete genome	blastn	186375	547	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter sp. L9-4
18732699	18732699	PRJNA902515_P_NODE_15015_length_244_cov_0.912281_g14992_i0	PRJNA902515	15015	244	0.912281	2.22596564	Nocardioides sp. HDW12B	2714939	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g14992	i0	100	0.114754098360656	28	0	11	0	212	239	3514020	3513993	Nocardioides sp. HDW12B chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
20007773	20007773	PRJNA902515_P_NODE_12636_length_250_cov_0.881356_g12613_i0	PRJNA902515	12636	250	0.881356	2.20339	Bifidobacterium catenulatum	1686	Bacteria	Bacteria	407	4.1899999999999994e-109	NTclustered	gi\|757807349\|dbj\|AP012327.1\|	1150460	g12613	i0	96	12	250	10	100	0	1	250	1882564	1882315	Bifidobacterium kashiwanohense JCM 15439 = DSM 21854 DNA, complete genome	blastn	3000	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium catenulatum
20007864	20007864	PRJNA902515_P_NODE_15936_length_242_cov_0.923077_g15913_i0	PRJNA902515	15936	242	0.923077	2.23384634	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2119983138\|gb\|CP079231.1\|	28026	g15913	i0	100	12.9504132231405	242	0	100	0	1	242	1181717	1181958	Bifidobacterium pseudocatenulatum strain YIT12820 chromosome, complete genome	blastn	3134	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
21283157	21283157	PRJNA902515_P_NODE_13797_length_247_cov_0.896552_g13774_i0	PRJNA902515	13797	247	0.896552	2.21448344	Microbacterium pygmaeum	370764	Bacteria	Bacteria	147	9.96e-31	NTclustered	gi\|1085647670\|emb\|LT629692.1\|	370764	g13774	i0	79.343	14.2591093117409	213	40	85	4	37	247	264052	263842	Microbacterium pygmaeum strain DSM 23142 genome assembly, chromosome: I	blastn	3522	147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium pygmaeum
22924276	22924276	PRJNA902515_P_NODE_11118_length_253_cov_0.866667_g11095_i0	PRJNA902515	11118	253	0.866667	2.19266751	Bifidobacterium	1678	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g11095	i0	99.605	10	253	1	100	0	1	253	789686	789434	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	2530	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
23833366	23833366	PRJNA902515_P_NODE_14679_length_245_cov_0.906977_g14656_i0	PRJNA902515	14679	245	0.906977	2.22209365	Bifidobacterium pseudocatenulatum	28026	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2777572590\|dbj\|AP031419.1\|	28026	g14656	i0	99.184	13	245	2	100	0	1	245	1078482	1078726	Bifidobacterium pseudocatenulatum i02-0019-A2 DNA, complete genome	blastn	3185	442	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum
25473297	25473297	PRJNA902515_P_NODE_11460_length_252_cov_1.145251_g11437_i0	PRJNA902515	11460	252	1.145251	2.88603252	Bifidobacterium	1678	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|2179090907\|gb\|CP090598.1\|	28026	g11437	i0	98.81	80.0396825396825	252	3	100	0	1	252	1235847	1235596	Bifidobacterium pseudocatenulatum strain JCLA3 chromosome, complete genome	blastn	20170	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pseudocatenulatum

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