metadata: contig_metadata: 16 rows where bioproject = "PRJNA672101" and tax

16 rows where bioproject = "PRJNA672101" 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
641927	641927	PRJNA672101_S_NODE_27001_length_256_cov_2.524590_g26970_i0	PRJNA672101	27001	256	2.52459	6.4629504	Rothia nasimurium	85336	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|1890911746\|gb\|CP056080.1\|	85336	g26970	i0	92.174	267.8125	230	18	90	0	6	235	1714374	1714603	Rothia nasimurium strain E1706032 chromosome, complete genome	blastn	68560	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia nasimurium
7020691	7020691	PRJNA672101_S_NODE_35226_length_210_cov_4.291971_g35195_i0	PRJNA672101	35226	210	4.291971	9.0131391	Streptomyces uncialis	1048205	Bacteria	Bacteria	65.8	2.37e-6	NTclustered	gi\|2655924843\|gb\|CP109290.1\|	1048205	g35195	i0	90.385	0.49047619047619	52	2	24	3	3	52	5130118	5130168	Streptomyces uncialis strain NBC 01624 chromosome, complete genome	blastn	103	65.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces uncialis
7543388	7543388	PRJNA672101_S_NODE_7106_length_377_cov_3.753289_g7075_i0	PRJNA672101	7106	377	3.753289	14.14989953	Cutibacterium	1912216	Bacteria	Bacteria	697	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7075	i0	100	269.623342175066	377	0	100	0	1	377	56706	57082	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	101648	697	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10845963	10845963	PRJNA672101_S_NODE_229_length_856_cov_30.168582_g211_i0	PRJNA672101	229	856	30.168582	258.24306192	Brevibacterium casei	33889	Bacteria	Bacteria	1581	0	NTclustered	gi\|1958263390\|gb\|CP068173.1\|	33889	g211	i0	100	296.420560747664	856	0	100	0	1	856	173304	172449	Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome	blastn	253736	1581	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
14670805	14670805	PRJNA672101_S_NODE_15112_length_311_cov_3.134454_g15081_i0	PRJNA672101	15112	311	3.134454	9.74815194	Actinomyces viscosus	1656	Bacteria	Bacteria	490	5.1999999999999985e-134	NTclustered	gi\|1540150178\|emb\|LR134477.1\|	1656	g15081	i0	95.208	262.392282958199	313	10	99	4	1	309	245454	245143	Actinomyces viscosus strain NCTC10951 genome assembly, chromosome: 1	blastn	81604	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces viscosus
15194088	15194088	PRJNA672101_S_NODE_12812_length_326_cov_4.000000_g12781_i0	PRJNA672101	12812	326	4	13.04	Propionibacteriaceae	31957	Bacteria	Bacteria	558	1.48e-154	NTclustered	gi\|2016305036\|gb\|CP071870.1\|	2760308	g12781	i0	97.546	229.003067484663	326	8	100	0	1	326	2050501	2050826	Propioniciclava sp. MC1595 chromosome, complete genome	blastn	74655	558	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propioniciclava	Propioniciclava sp. MC1595
15194101	15194101	PRJNA672101_S_NODE_27552_length_254_cov_2.475138_g27521_i0	PRJNA672101	27552	254	2.475138	6.28685052	Actinomycetes	1760	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|1828205916\|gb\|MT279343.1\|	51513	g27521	i0	99.606	100.007874015748	254	1	100	0	1	254	450	197	Agromyces sp. strain LA10 16S ribosomal RNA gene, partial sequence	blastn	25402	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces sp.
16468409	16468409	PRJNA672101_S_NODE_21053_length_280_cov_6.951691_g21022_i0	PRJNA672101	21053	280	6.951691	19.4647348	root	1	Root_unresolved	Root_unresolved	518	2.12e-142	NTclustered	gi\|1313740129\|dbj\|LC341276.1\|	1747	g21022	i0	100	103	280	0	100	0	1	280	1039	1318	Cutibacterium acnes JK12.2 gene for 16S ribosomal RNA, partial sequence	blastn	28840	518	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19017237	19017237	PRJNA672101_S_NODE_33115_length_241_cov_3.482143_g33084_i0	PRJNA672101	33115	241	3.482143	8.39196463	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g33084	i0	100	59.4647302904564	241	0	100	0	1	241	88110	88350	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14331	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22319457	22319457	PRJNA672101_S_NODE_8858_length_358_cov_6.150877_g8827_i0	PRJNA672101	8858	358	6.150877	22.02013966	uncultured Frankia sp.	181582	Bacteria	Bacteria	412	1.35e-110	NTclustered	gi\|48728172\|gb\|AY627744.1\|	181582	g8827	i0	87.465	155.220670391061	359	43	100	2	1	358	530	887	Uncultured Frankia sp. clone CEIN1811 16S-23S intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55569	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Frankia	uncultured Frankia sp.
24867935	24867935	PRJNA672101_S_NODE_11440_length_336_cov_7.543726_g11409_i0	PRJNA672101	11440	336	7.543726	25.34691936	Pedococcus dokdonensis	443156	Bacteria	Bacteria	527	4.3199999999999985e-145	NTclustered	gi\|1085742359\|emb\|LT629711.1\|	443156	g11409	i0	94.94	349.488095238095	336	17	100	0	1	336	1368415	1368080	Phycicoccus dokdonensis strain DSM 22329 genome assembly, chromosome: I	blastn	117428	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Pedococcus	Pedococcus dokdonensis
24868063	24868063	PRJNA672101_S_NODE_19360_length_288_cov_3.390698_g19329_i0	PRJNA672101	19360	288	3.390698	9.76521024	Brevibacterium casei	33889	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g19329	i0	100	16.0381944444444	288	0	100	0	1	288	3028899	3029186	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	4619	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
26923597	26923597	PRJNA672101_S_NODE_31022_length_246_cov_0.890173_g30991_i0	PRJNA672101	31022	246	0.890173	2.18982558	Paractinoplanes lichenicola	2802976	Bacteria	Bacteria	43.5	0.0166	NR	WP_202994310.1	2802976	g30991	i0	42.4	0.719512195121951	59	33	70.7	1	177	4	142	200	WP_202994310.1 DUF4386 domain-containing protein [Paractinoplanes lichenicola]	diamond	177	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Paractinoplanes	Paractinoplanes lichenicola
32231723	32231723	PRJNA672101_S_NODE_20998_length_281_cov_1.110577_g20967_i0	PRJNA672101	20998	281	1.110577	3.12072137	Streptomyces narbonensis	67333	Bacteria	Bacteria	59.3	3.32e-8	NR	WP_229833193.1	67333	g20967	i0	39.4	2.13523131672598	99	49	96.1	4	270	1	69	165	WP_229833193.1 hypothetical protein, partial [Streptomyces narbonensis]	diamond	600	59.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces narbonensis
32453248	32453248	PRJNA672101_S_NODE_12259_length_330_cov_4.494163_g12228_i0	PRJNA672101	12259	330	4.494163	14.8307379	Streptomyces physcomitrii	2724184	Bacteria	Bacteria	156	1.84e-46	NR	WP_246342120.1	2724184	g12228	i0	68.8	8.90909090909091	109	31	99.1	1	1	327	44	149	WP_246342120.1 hypothetical protein [Streptomyces physcomitrii]	diamond	2940	156	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces physcomitrii
32484746	32484746	PRJNA672101_S_NODE_8679_length_360_cov_3.881533_g8648_i0	PRJNA672101	8679	360	3.881533	13.9735188	Bifidobacterium animalis	28025	Bacteria	Bacteria	45.1	0.0164	NR	MED7637831.1	28025	g8648	i0	51.7	0.741666666666667	89	32	70	3	87	338	69	151	MED7637831.1 hypothetical protein [Bifidobacterium animalis]	diamond	267	45.1	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);;