metadata: contig_metadata: 20 rows where bioproject = "PRJNA981359" and tax

20 rows where bioproject = "PRJNA981359" 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
2237792	2237792	PRJNA981359_S_NODE_38642_length_305_cov_3.448276_g38542_i0	PRJNA981359	38642	305	3.448276	10.5172418	Corynebacterium appendicis	163202	Bacteria	Bacteria	521	1.8e-143	NTclustered	gi\|2531255973\|gb\|CP046976.1\|	1161099	g38542	i0	97.394	444.445901639344	307	6	100	1	1	305	586782	587088	Corynebacterium appendicis CIP 107643 chromosome, complete genome	blastn	135556	521	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium appendicis
2237973	2237973	PRJNA981359_S_NODE_45342_length_290_cov_3.073733_g45242_i0	PRJNA981359	45342	290	3.073733	8.9138257	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	496	1.03e-135	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g45242	i0	97.578	225.3	289	7	99	0	2	290	553543	553255	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	65337	496	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2238285	2238285	PRJNA981359_S_NODE_57682_length_265_cov_2.880208_g57582_i0	PRJNA981359	57682	265	2.880208	7.6325512	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	473	4.3599999999999987e-129	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g57582	i0	98.868	290.192452830189	265	3	100	0	1	265	553567	553303	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	76901	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
5099127	5099127	PRJNA981359_S_NODE_40324_length_301_cov_7.833333_g40224_i0	PRJNA981359	40324	301	7.833333	23.57833233	Cutibacterium	1912216	Bacteria	Bacteria	556	4.87e-154	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g40224	i0	100	263.461794019934	301	0	100	0	1	301	55805	55505	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	79302	556	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11474511	11474511	PRJNA981359_S_NODE_2549_length_605_cov_2.646617_g2454_i0	PRJNA981359	2549	605	2.646617	16.01203285	Corynebacterium	1716	Bacteria	Bacteria	861	0	NTclustered	gi\|2547417233\|gb\|CP073096.1\|	38304	g2454	i0	92.422	372.333884297521	607	41	100	5	1	605	789191	789794	Corynebacterium tuberculostearicum strain CTNIH20 chromosome, complete genome	blastn	225262	861	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
11474563	11474563	PRJNA981359_S_NODE_73929_length_240_cov_2.335329_g73829_i0	PRJNA981359	73929	240	2.335329	5.6047896	Propionibacteriaceae	31957	Bacteria	Bacteria	383	6.74e-102	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g73829	i0	95.798	317.170833333333	238	9	99	1	1	238	1044511	1044747	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	76121	385	0.994805194805195	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
14990076	14990076	PRJNA981359_S_NODE_27672_length_334_cov_2.747126_g27572_i0	PRJNA981359	27672	334	2.747126	9.17540084	Corynebacterium marquesiae	2913503	Bacteria	Bacteria	584	2.509999999999999e-162	NTclustered	gi\|2869822234\|gb\|CP175776.1\|	2913503	g27572	i0	98.209	374.236526946108	335	5	100	1	1	334	1954902	1954568	Corynebacterium marquesiae strain YSMAA3_1_G3 chromosome, complete genome	blastn	124995	584	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium marquesiae
17539959	17539959	PRJNA981359_S_NODE_24634_length_343_cov_4.444444_g24534_i0	PRJNA981359	24634	343	4.444444	15.24444292	Corynebacterium accolens	38284	Bacteria	Bacteria	634	2.5299999999999996e-177	NTclustered	gi\|2550468567\|gb\|CP100375.1\|	38284	g24534	i0	100	349.166180758018	343	0	100	0	1	343	2492486	2492828	Corynebacterium accolens strain CA8 chromosome	blastn	119764	634	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
17848463	17848463	PRJNA981359_S_NODE_76054_length_230_cov_2.484076_g75954_i0	PRJNA981359	76054	230	2.484076	5.7133748	Cutibacterium	1912216	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g75954	i0	100	267.947826086957	230	0	100	0	1	230	56237	56466	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	61628	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21364450	21364450	PRJNA981359_S_NODE_33737_length_317_cov_3.655738_g33637_i0	PRJNA981359	33737	317	3.655738	11.58868946	Corynebacterium coyleae	53374	Bacteria	Bacteria	468	2.49e-127	NTclustered	gi\|2058472593\|gb\|CP077302.1\|	53374	g33637	i0	93.375	357.350157728707	317	20	99	1	2	317	501790	501474	Corynebacterium coyleae strain FDAARGOS 1425 chromosome, complete genome	blastn	113280	468	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium coyleae
22948553	22948553	PRJNA981359_S_NODE_29278_length_329_cov_3.687500_g29178_i0	PRJNA981359	29278	329	3.6875	12.131875	Micrococcales	85006	Bacteria	Bacteria	608	1.4599999999999995e-169	NTclustered	gi\|2528150176\|gb\|CP128474.1\|	33883	g29178	i0	100	170.987841945289	329	0	100	0	1	329	2056468	2056140	Microbacterium arborescens strain SSF12 chromosome, complete genome	blastn	56255	608	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium arborescens
27816243	27816243	PRJNA981359_S_NODE_74424_length_238_cov_2.036364_g74324_i0	PRJNA981359	74424	238	2.036364	4.84654632	Corynebacterium pyruviciproducens	598660	Bacteria	Bacteria	41.6	0.014	NR	WP_284842837.1	598660	g74324	i0	62.5	0.403361344537815	32	11	39.1	1	28	120	26	57	WP_284842837.1 hypothetical protein, partial [Corynebacterium pyruviciproducens]	diamond	96	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pyruviciproducens
27910504	27910504	PRJNA981359_S_NODE_37805_length_307_cov_3.452991_g37705_i0	PRJNA981359	37805	307	3.452991	10.60068237	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	151	3.56e-45	NR	PYC99673.1	57043	g37705	i0	100	0.801302931596091	82	0	80.1	0	307	62	33	114	PYC99673.1 hypothetical protein B4U78_015020 [Microbacterium esteraromaticum]	diamond	246	151	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
28011690	28011690	PRJNA981359_S_NODE_50725_length_279_cov_1.893204_g50625_i0	PRJNA981359	50725	279	1.893204	5.28203916	root	1	Root_unresolved	Root_unresolved	64.7	8.36e-10	NR	MES6376112.1	1747	g50625	i0	54.5	17.7849462365591	66	28	71	1	244	47	41	104	MES6376112.1 reverse transcriptase family protein [Cutibacterium acnes]	diamond	4962	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
28068590	28068590	PRJNA981359_S_NODE_61025_length_259_cov_1.913978_g60925_i0	PRJNA981359	61025	259	1.913978	4.95720302	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	45.1	0.00623	NR	HEY8103918.1	2838783	g60925	i0	39.7	0.72972972972973	63	34	70.7	2	2	184	155	215	HEY8103918.1 phosphatidate cytidylyltransferase [Gaiellaceae bacterium]	diamond	189	45.1	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
28100066	28100066	PRJNA981359_S_NODE_65705_length_251_cov_2.191011_g65605_i0	PRJNA981359	65705	251	2.191011	5.49943761	Cutibacterium acnes	1747	Bacteria	Bacteria	56.2	5.61e-8	NR	MES7991023.1	1747	g65605	i0	66.7	2.64143426294821	42	13	49	1	156	34	33	74	MES7991023.1 hypothetical protein [Cutibacterium acnes]	diamond	663	56.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
28643146	28643146	PRJNA981359_S_NODE_20407_length_359_cov_1.419580_g20307_i0	PRJNA981359	20407	359	1.41958	5.0962922	root	1	Root_unresolved	Root_unresolved	61.2	5.79e-9	NR	WP_258225418.1	43765	g20307	i0	61.7	3.49303621169916	47	18	39.3	0	309	169	37	83	WP_258225418.1 hypothetical protein [Corynebacterium amycolatum]	diamond	1254	61.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium amycolatum
31796100	31796100	PRJNA981359_S_NODE_53917_length_273_cov_1.170000_g53817_i0	PRJNA981359	53917	273	1.17	3.1941	Cutibacterium acnes	1747	Bacteria	Bacteria	57	1.52e-8	NR	MES6869092.1	1747	g53817	i0	58.5	0.582417582417582	53	20	56	1	2	154	12	64	MES6869092.1 hypothetical protein [Cutibacterium acnes]	diamond	159	57	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32302852	32302852	PRJNA981359_S_NODE_47379_length_286_cov_2.197183_g47279_i0	PRJNA981359	47379	286	2.197183	6.28394338	Leucobacter tenebrionis	2873270	Bacteria	Bacteria	43.9	0.025	NR	WP_223043024.1	2873270	g47279	i0	42.9	0.513986013986014	49	28	51.4	0	86	232	707	755	WP_223043024.1 hypothetical protein [Leucobacter tenebrionis]	diamond	147	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter tenebrionis
32713065	32713065	PRJNA981359_S_NODE_66160_length_251_cov_0.876404_g66060_i0	PRJNA981359	66160	251	0.876404	2.19977404	Streptomyces capillispiralis	68182	Bacteria	Bacteria	43.5	0.0222	NR	WP_145870881.1	68182	g66060	i0	38.2	0.812749003984064	68	37	75.3	2	43	231	203	270	WP_145870881.1 enoyl-CoA hydratase/isomerase [Streptomyces capillispiralis]	diamond	204	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces capillispiralis

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