metadata: contig_metadata: 28 rows where bioproject = "PRJNA764222" and tax

28 rows where bioproject = "PRJNA764222" 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
6309858	6309858	PRJNA764222_S_NODE_4545_length_317_cov_1.992593_g4387_i0	PRJNA764222	4545	317	1.992593	6.31651981	Cutibacterium	1912216	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4387	i0	100	272.003154574133	317	0	100	0	1	317	56697	57013	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	86225	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6309883	6309883	PRJNA764222_S_NODE_9045_length_269_cov_5.274775_g8887_i0	PRJNA764222	9045	269	5.274775	14.18914475	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	175	1.05e-53	NR	PYC99494.1	57043	g8887	i0	98.9	0.992565055762082	89	1	99.3	0	1	267	68	156	PYC99494.1 hypothetical protein B4U78_016800, partial [Microbacterium esteraromaticum]	diamond	267	175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
10134404	10134404	PRJNA764222_S_NODE_4728_length_314_cov_1.955056_g4570_i0	PRJNA764222	4728	314	1.955056	6.13887584	Cutibacterium	1912216	Bacteria	Bacteria	575	1.4099999999999994e-159	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4570	i0	99.683	269.070063694268	315	0	100	1	1	314	56233	56547	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	84488	575	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11409574	11409574	PRJNA764222_S_NODE_18569_length_216_cov_1.538462_g18411_i0	PRJNA764222	18569	216	1.538462	3.32307792	Streptomyces	1883	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2656536241\|gb\|CP109419.1\|	2903888	g18411	i0	92.308	0.361111111111111	39	1	17	2	113	149	679940	679902	Streptomyces sp. NBC_01508 chromosome, complete genome	blastn	78	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01508
12224243	12224243	PRJNA764222_S_NODE_13890_length_239_cov_2.208333_g13732_i0	PRJNA764222	13890	239	2.208333	5.27791587	Rothia kristinae	37923	Bacteria	Bacteria	326	1.15e-84	NTclustered	gi\|1943322775\|gb\|CP065738.1\|	37923	g13732	i0	91.322	334.305439330544	242	16	100	5	1	239	984256	984017	Rothia kristinae strain FDAARGOS_864 chromosome, complete genome	blastn	79899	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia kristinae
13498450	13498450	PRJNA764222_S_NODE_24471_length_190_cov_2.706294_g24313_i0	PRJNA764222	24471	190	2.706294	5.1419586	Cutibacterium acnes	1747	Bacteria	Bacteria	302	1.47e-77	NTclustered	gi\|2415255273\|gb\|CP114143.1\|	1734925	g24313	i0	100	38.6052631578947	163	0	86	0	1	163	436264	436426	Cutibacterium acnes subsp. acnes strain CCSM0331 chromosome, complete genome	blastn	7335	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13959714	13959714	PRJNA764222_S_NODE_1431_length_491_cov_5.396396_g1278_i0	PRJNA764222	1431	491	5.396396	26.49630436	Cutibacterium	1912216	Bacteria	Bacteria	907	0	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g1278	i0	100	272.979633401222	491	0	100	0	1	491	775254	775744	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	134033	907	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13959770	13959770	PRJNA764222_S_NODE_24351_length_191_cov_1.465278_g24193_i0	PRJNA764222	24351	191	1.465278	2.79868098	Micrococcus	1269	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g24193	i0	99.476	297.083769633508	191	1	100	0	1	191	346911	346721	Micrococcus luteus strain V017 chromosome, complete genome	blastn	56743	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17322969	17322969	PRJNA764222_S_NODE_20314_length_208_cov_1.503106_g20156_i0	PRJNA764222	20314	208	1.503106	3.12646048	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	161	2.8999999999999997e-35	NTclustered	gi\|2874253834\|emb\|OY969884.1\|	3039803	g20156	i0	81.592	4.61057692307692	201	31	95	6	3	200	33434	33631	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.2 genome assembly, chromosome: 1	blastn	959	161	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
20332148	20332148	PRJNA764222_S_NODE_16376_length_226_cov_2.513966_g16218_i0	PRJNA764222	16376	226	2.513966	5.68156316	Cutibacterium	1912216	Bacteria	Bacteria	357	3.81e-94	NTclustered	gi\|1059945062\|gb\|CP016954.1\|	33010	g16218	i0	95.175	287.849557522124	228	7	100	3	1	226	22481	22256	Cutibacterium avidum strain DPC 6544, complete genome	blastn	65054	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
21147327	21147327	PRJNA764222_S_NODE_31597_length_164_cov_3.700855_g31439_i0	PRJNA764222	31597	164	3.700855	6.0694022	Kocuria palustris	71999	Bacteria	Bacteria	252	1.26e-62	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g31439	i0	95.031	274.841463414634	161	7	98	1	1	160	501399	501559	Kocuria palustris strain MU14/1, complete genome	blastn	45074	252	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
24157457	24157457	PRJNA764222_S_NODE_2719_length_366_cov_4.670846_g2561_i0	PRJNA764222	2719	366	4.670846	17.09529636	Corynebacterium	1716	Bacteria	Bacteria	632	9.759999999999998e-177	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g2561	i0	97.814	369.136612021858	366	8	100	0	1	366	2560	2925	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	135104	638	0.990595611285266	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24157476	24157476	PRJNA764222_S_NODE_30419_length_168_cov_1.652893_g30261_i0	PRJNA764222	30419	168	1.652893	2.77686024	Corynebacterium	1716	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|2531251647\|gb\|CP046606.1\|	144183	g30261	i0	98.817	373.666666666667	169	1	100	1	1	168	1150374	1150206	Corynebacterium afermentans subsp. afermentans strain DSM 44280 chromosome, complete genome	blastn	62776	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
25432405	25432405	PRJNA764222_S_NODE_2160_length_401_cov_1.985876_g2002_i0	PRJNA764222	2160	401	1.985876	7.96336276	Corynebacterium	1716	Bacteria	Bacteria	654	0	NTclustered	gi\|2869840509\|gb\|CP175798.1\|	38304	g2002	i0	96.259	393.69825436409	401	11	99	4	3	401	2217968	2217570	Corynebacterium tuberculostearicum strain YSMAA1_1_C1 chromosome, complete genome	blastn	157873	654	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
26768352	26768352	PRJNA764222_S_NODE_13781_length_240_cov_1.295337_g13623_i0	PRJNA764222	13781	240	1.295337	3.1088088	Cutibacterium acnes	1747	Bacteria	Bacteria	52.4	4.65e-6	NR	MES9280136.1	1747	g13623	i0	43.8	2.1125	80	41	97.5	3	7	240	60	137	MES9280136.1 reverse transcriptase domain-containing protein [Cutibacterium acnes]	diamond	507	52.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27147606	27147606	PRJNA764222_S_NODE_10282_length_261_cov_1.878505_g10124_i0	PRJNA764222	10282	261	1.878505	4.90289805	Cutibacterium acnes	1747	Bacteria	Bacteria	58.2	4.99e-9	NR	MES6750617.1	1747	g10124	i0	48.4	0.71264367816092	62	25	63.2	1	27	191	4	65	MES6750617.1 hypothetical protein [Cutibacterium acnes]	diamond	186	58.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27242815	27242815	PRJNA764222_S_NODE_8663_length_273_cov_1.150442_g8505_i0	PRJNA764222	8663	273	1.150442	3.14070666	Saccharopolyspora elongata	2530387	Bacteria	Bacteria	40.8	0.0496	NR	WP_132489592.1	2530387	g8505	i0	45.3	0.582417582417582	53	27	57.1	2	187	32	33	84	WP_132489592.1 hypothetical protein [Saccharopolyspora elongata]	diamond	159	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora elongata
27274505	27274505	PRJNA764222_S_NODE_10763_length_257_cov_4.600000_g10605_i0	PRJNA764222	10763	257	4.6	11.822	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	47.4	0.00103	NR	MBM3808383.1	2080302	g10605	i0	36.8	0.88715953307393	76	37	75.9	3	241	47	195	270	MBM3808383.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	228	47.4	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
27306214	27306214	PRJNA764222_S_NODE_19623_length_211_cov_1.823171_g19465_i0	PRJNA764222	19623	211	1.823171	3.84689081	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	43.1	0.0183	NR	WP_398314961.1	3365031	g19465	i0	30	0.995260663507109	70	45	93.8	2	14	211	165	234	WP_398314961.1 DNA/RNA non-specific endonuclease [Streptomyces sp. NPDC018026]	diamond	210	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC018026
29484486	29484486	PRJNA764222_S_NODE_19990_length_209_cov_2.308642_g19832_i0	PRJNA764222	19990	209	2.308642	4.82506178	Nocardioides sp.	35761	Bacteria	Bacteria	108	1.8499999999999999e-28	NR	HEX8780462.1	35761	g19832	i0	75.4	0.990430622009569	69	17	99	0	209	3	75	143	HEX8780462.1 hypothetical protein [Nocardioides sp.]	diamond	207	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
29683485	29683485	PRJNA764222_S_NODE_21890_length_201_cov_1.655844_g21732_i0	PRJNA764222	21890	201	1.655844	3.32824644	Actinomycetes	1760	Bacteria	Bacteria	42.4	0.0292	NR	HYP93838.1	1785	g21732	i0	40.7	1.65671641791045	54	29	80.6	1	6	167	295	345	HYP93838.1 hypothetical protein [Mycobacterium sp.]	diamond	333	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
30210984	30210984	PRJNA764222_S_NODE_4772_length_313_cov_2.748120_g4614_i0	PRJNA764222	4772	313	2.74812	8.6016156	Streptomyces sp.	1931	Bacteria	Bacteria	43.5	0.0405	NR	WP_415940400.1	2789263	g4614	i0	72	0.23961661341853	25	7	24	0	120	194	160	184	WP_415940400.1 endonuclease/exonuclease/phosphatase family protein, partial [Streptomyces sp. 039-1]	diamond	75	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 039-1
30852677	30852677	PRJNA764222_S_NODE_5314_length_305_cov_5.189922_g5156_i0	PRJNA764222	5314	305	5.189922	15.8292621	Bacillati	1783272	Bacteria	Bacteria	213	2.3199999999999994e-67	NR	PYC99595.1	57043	g5156	i0	100	1.98688524590164	101	0	99.3	0	3	305	38	138	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	606	213	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
31032947	31032947	PRJNA764222_S_NODE_8235_length_276_cov_3.484716_g8077_i0	PRJNA764222	8235	276	3.484716	9.61781616	Nocardioides speluncae	2670337	Bacteria	Bacteria	43.5	0.0289	NR	WP_109507820.1	2670337	g8077	i0	33.3	0.91304347826087	84	41	88	4	25	267	313	384	WP_109507820.1 hypothetical protein [Nocardioides speluncae]	diamond	252	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides speluncae
31158702	31158702	PRJNA764222_S_NODE_8775_length_272_cov_1.613333_g8617_i0	PRJNA764222	8775	272	1.613333	4.38826576	Nonomuraea cypriaca	1187855	Bacteria	Bacteria	43.5	0.0267	NR	WP_195898817.1	1187855	g8617	i0	35.5	0.683823529411765	62	40	68.4	0	67	252	256	317	WP_195898817.1 hypothetical protein [Nonomuraea cypriaca]	diamond	186	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea cypriaca
32276035	32276035	PRJNA764222_S_NODE_24938_length_188_cov_2.645390_g24780_i0	PRJNA764222	24938	188	2.64539	4.9733332	root	1	Root_unresolved	Root_unresolved	47.4	4.13e-4	NR	MES8310468.1	1747	g24780	i0	57.6	2.63297872340426	33	14	52.7	0	152	54	304	336	MES8310468.1 hypothetical protein [Cutibacterium acnes]	diamond	495	47.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32551243	32551243	PRJNA764222_S_NODE_25799_length_185_cov_1.811594_g25641_i0	PRJNA764222	25799	185	1.811594	3.3514489	Nocardia nova	37330	Bacteria	Bacteria	40.8	0.0128	NR	WP_267465073.1	37330	g25641	i0	39.6	0.778378378378378	48	29	77.8	0	145	2	8	55	WP_267465073.1 RBD-like domain-containing protein, partial [Nocardia nova]	diamond	144	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia nova
32875440	32875440	PRJNA764222_S_NODE_17360_length_221_cov_3.683908_g17202_i0	PRJNA764222	17360	221	3.683908	8.14143668	root	1	Root_unresolved	Root_unresolved	44.3	0.00453	NR	MES6300509.1	1747	g17202	i0	63.9	5.37556561085973	36	12	47.5	1	219	115	61	96	MES6300509.1 reverse transcriptase domain-containing protein [Cutibacterium acnes]	diamond	1188	44.3	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);;