metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA927284" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA927284" 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
901881	901881	PRJNA927284_P_NODE_5641_length_233_cov_1.715686_g5434_i0	PRJNA927284	5641	233	1.715686	3.99754838	Streptomyces halobius	2879846	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2235503620\|gb\|CP086322.1\|	2879846	g5434	i0	100	0.137339055793991	32	0	14	0	116	147	8176481	8176450	Streptomyces halobius strain 3_2 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces halobius
901894	901894	PRJNA927284_P_NODE_7821_length_177_cov_4.972973_g7614_i0	PRJNA927284	7821	177	4.972973	8.80216221	Rothia aeria	172042	Bacteria	Bacteria	222	1.08e-53	NTclustered	gi\|2072522805\|gb\|CP079819.1\|	172042	g7614	i0	89.444	312.276836158192	180	14	100	5	1	177	521673	521850	Rothia aeria strain LPB0401 chromosome, complete genome	blastn	55273	222	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
1252576	1252576	PRJNA927284_P_NODE_1441_length_617_cov_31.954082_g1285_i0	PRJNA927284	1441	617	31.954082	197.15668594	Corynebacterium	1716	Bacteria	Bacteria	926	0	NTclustered	gi\|2869842788\|gb\|CP175780.1\|	38304	g1285	i0	93.994	383.26904376013	616	30	100	6	1	614	373502	374112	Corynebacterium tuberculostearicum strain YSMAA1_2_H3 chromosome, complete genome	blastn	236477	928	0.997844827586207	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
2177190	2177190	PRJNA927284_P_NODE_1602_length_576_cov_11.318099_g1000_i1	PRJNA927284	1602	576	11.318099	65.19225024	Naasia aerilata	1162966	Bacteria	Bacteria	634	4.4399999999999985e-177	NTclustered	gi\|2465733196\|dbj\|AP027731.1\|	1162966	g1000	i1	90.928	161.506944444444	474	39	82	3	20	491	3197637	3197166	Naasia aerilata NBRC 108725 DNA, complete genome	blastn	93028	634	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Naasia	Naasia aerilata
2177203	2177203	PRJNA927284_P_NODE_2922_length_387_cov_8.829609_g2720_i0	PRJNA927284	2922	387	8.829609	34.17058683	Rothia aeria	172042	Bacteria	Bacteria	675	0	NTclustered	gi\|1958291603\|gb\|CP068102.1\|	172042	g2720	i0	98.191	389.97157622739	387	5	100	1	1	387	672477	672093	Rothia aeria strain FDAARGOS_1137 chromosome, complete genome	blastn	150919	675	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
2528259	2528259	PRJNA927284_P_NODE_7982_length_174_cov_4.117241_g7775_i0	PRJNA927284	7982	174	4.117241	7.16399934	Actinomyces	1654	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g7775	i0	100	164.597701149425	174	0	100	0	1	174	298069	297896	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	28640	322	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
6356609	6356609	PRJNA927284_P_NODE_4565_length_278_cov_9.108434_g4358_i0	PRJNA927284	4565	278	9.108434	25.32144652	Corynebacterium	1716	Bacteria	Bacteria	429	1.0099999999999999e-115	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g4358	i0	94.624	367.212230215827	279	11	100	3	1	278	990699	990424	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	102085	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
7279958	7279958	PRJNA927284_P_NODE_9366_length_150_cov_1.752066_g9159_i0	PRJNA927284	9366	150	1.752066	2.628099	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g9159	i0	100	174.553333333333	150	0	100	0	1	150	127120	127269	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	26183	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
8905355	8905355	PRJNA927284_P_NODE_1427_length_621_cov_38.819257_g1271_i0	PRJNA927284	1427	621	38.819257	241.06758597	Microbacteriaceae	85023	Bacteria	Bacteria	809	0	NTclustered	gi\|1026621770\|gb\|CP015515.1\|	33888	g1271	i0	90.468	180.547504025765	619	51	99	8	1	617	1190525	1189913	Rathayibacter tritici strain NCPPB 1953, complete genome	blastn	112120	813	0.995079950799508	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter tritici
8905366	8905366	PRJNA927284_P_NODE_907_length_818_cov_34.989861_g782_i0	PRJNA927284	907	818	34.989861	286.21706298	Corynebacterium	1716	Bacteria	Bacteria	1371	0	NTclustered	gi\|470484386\|ref\|NR_076645.1\|	161879	g782	i0	97.059	447.841075794621	816	20	99	4	1	815	15	827	Corynebacterium kroppenstedtii strain DSM 44385 23S ribosomal RNA gene, complete sequence	blastn	366334	1376	0.996366279069767	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
9829618	9829618	PRJNA927284_P_NODE_2608_length_418_cov_32.745501_g2409_i0	PRJNA927284	2608	418	32.745501	136.87619418	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	617	3.16e-172	NTclustered	gi\|664687059\|gb\|CP008889.1\|	1274	g2409	i0	93.51	176.320574162679	416	25	99	2	1	416	1844720	1844307	Dermacoccus nishinomiyaensis strain M25, complete genome	blastn	73702	617	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
10181222	10181222	PRJNA927284_P_NODE_1168_length_696_cov_22.490255_g1028_i0	PRJNA927284	1168	696	22.490255	156.5321748	Mycobacteriales	85007	Bacteria	Bacteria	776	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g1028	i0	88.462	365.271551724138	650	66	93	8	51	696	552993	552349	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	254229	776	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
10181232	10181232	PRJNA927284_P_NODE_5708_length_230_cov_4.776119_g5501_i0	PRJNA927284	5708	230	4.776119	10.9850737	Rothia	32207	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2894499433\|gb\|CP178330.1\|	2047	g5501	i0	100	188.591304347826	230	0	100	0	1	230	902754	902525	Rothia dentocariosa strain SOSUI028 chromosome, complete genome	blastn	43376	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
12732006	12732006	PRJNA927284_P_NODE_2310_length_455_cov_96.800469_g2118_i0	PRJNA927284	2310	455	96.800469	440.44213395	root	1	Root_unresolved	Root_unresolved	647	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2118	i0	100	149.938461538462	350	0	77	0	1	350	53961	53612	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	68222	647	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17830058	17830058	PRJNA927284_P_NODE_3774_length_322_cov_36.617747_g3568_i0	PRJNA927284	3774	322	36.617747	117.90914534	Micrococcales	85006	Bacteria	Bacteria	553	6.799999999999998e-153	NTclustered	gi\|2017475128\|gb\|CP049819.1\|	156980	g3568	i0	97.812	369.593167701863	320	7	99	0	2	321	3106	2787	Arthrobacter woluwensis strain QTS chromosome, complete genome	blastn	119009	555	0.996396396396396	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter woluwensis
17830069	17830069	PRJNA927284_P_NODE_9154_length_153_cov_2.475806_g8947_i0	PRJNA927284	9154	153	2.475806	3.78798318	Schaalia	2529408	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1663040979\|gb\|CP040006.1\|	1660	g8947	i0	100	247.339869281046	153	0	100	0	1	153	535039	535191	Schaalia odontolytica strain XH001 chromosome, complete genome	blastn	37843	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
18753413	18753413	PRJNA927284_P_NODE_2255_length_462_cov_6.547344_g2063_i0	PRJNA927284	2255	462	6.547344	30.24872928	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	773	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g2063	i0	97.561	254.337662337662	451	11	98	0	3	453	553232	553682	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	117504	773	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
19104032	19104032	PRJNA927284_P_NODE_8815_length_159_cov_4.800000_g8608_i0	PRJNA927284	8815	159	4.8	7.632	Microbacteriaceae	85023	Bacteria	Bacteria	187	3.459999999999999e-43	NTclustered	gi\|2667034633\|dbj\|AP029214.1\|	69366	g8608	i0	97.273	135.119496855346	110	3	69	0	50	159	1619596	1619487	Microbacterium flavescens JCM 11568 DNA, unplaced contig sequence4	blastn	21484	187	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium flavescens
20028491	20028491	PRJNA927284_P_NODE_6716_length_200_cov_16.380117_g6509_i0	PRJNA927284	6716	200	16.380117	32.760234	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	331	1.99e-86	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g6509	i0	96.5	338.425	200	7	100	0	1	200	552741	552542	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	67685	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
20378889	20378889	PRJNA927284_P_NODE_3576_length_337_cov_2.577922_g3371_i0	PRJNA927284	3576	337	2.577922	8.68759714	Corynebacterium	1716	Bacteria	Bacteria	623	5.369999999999999e-174	NTclustered	gi\|2809007534\|gb\|CP119163.1\|	2736648	g3371	i0	100	100.172106824926	337	0	100	0	1	337	1819516	1819180	Corynebacterium kroppenstedtii subsp. demodicis strain Df-1 chromosome, complete genome	blastn	33758	623	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
21303842	21303842	PRJNA927284_P_NODE_1177_length_694_cov_20.067669_g1037_i0	PRJNA927284	1177	694	20.067669	139.26962286	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	547	7.249999999999997e-151	NTclustered	gi\|664687059\|gb\|CP008889.1\|	1274	g1037	i0	92.857	130.472622478386	378	25	54	2	3	380	1844307	1844682	Dermacoccus nishinomiyaensis strain M25, complete genome	blastn	90548	547	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
21654809	21654809	PRJNA927284_P_NODE_1977_length_503_cov_18.567511_g1790_i0	PRJNA927284	1977	503	18.567511	93.39458033	Actinomyces	1654	Bacteria	Bacteria	604	3.009999999999999e-168	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g1790	i0	90.83	300.508946322068	458	33	90	8	1	453	944823	944370	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	151156	606	0.996699669966997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
21654813	21654813	PRJNA927284_P_NODE_3237_length_361_cov_3.867470_g3032_i0	PRJNA927284	3237	361	3.86747	13.9615667	Cutibacterium	1912216	Bacteria	Bacteria	662	0	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g3032	i0	99.723	143.595567867036	361	1	100	0	1	361	1444350	1443990	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	51838	662	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22930324	22930324	PRJNA927284_P_NODE_1518_length_596_cov_28.987654_g1354_i0	PRJNA927284	1518	596	28.987654	172.76641784	Actinomyces	1654	Bacteria	Bacteria	843	0	NTclustered	gi\|1866749869\|gb\|CP058259.1\|	712116	g1354	i0	92.231	379.073825503356	605	32	100	13	1	593	952755	953356	Actinomyces sp. oral taxon 169 strain F0496 chromosome, complete genome	blastn	225928	843	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces sp. oral taxon 169
23854113	23854113	PRJNA927284_P_NODE_1139_length_704_cov_28.331852_g1000_i0	PRJNA927284	1139	704	28.331852	199.45623808	Herbiconiux sp. L3-i23	2905871	Bacteria	Bacteria	931	0	NTclustered	gi\|2238890657\|dbj\|AP025737.1\|	2905871	g1000	i0	91.304	178.980113636364	690	49	97	8	1	685	1092275	1091592	Herbiconiux sp. L3-i23 L3-i23 DNA, complete genome	blastn	126002	931	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Herbiconiux	Herbiconiux sp. L3-i23
23854115	23854115	PRJNA927284_P_NODE_1239_length_676_cov_26.383308_g1097_i0	PRJNA927284	1239	676	26.383308	178.35116208	Rothia mucilaginosa	43675	Bacteria	Bacteria	1184	0	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g1097	i0	98.516	337.247041420118	674	5	99	3	1	674	654087	653419	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	227979	1184	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
25479156	25479156	PRJNA927284_P_NODE_1600_length_576_cov_33.038391_g1432_i0	PRJNA927284	1600	576	33.038391	190.30113216	Microbacteriaceae	85023	Bacteria	Bacteria	889	0	NTclustered	gi\|2528150176\|gb\|CP128474.1\|	33883	g1432	i0	94.599	184.621527777778	574	31	99	0	1	574	2056792	2056219	Microbacterium arborescens strain SSF12 chromosome, complete genome	blastn	106342	896	0.9921875	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium arborescens

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