metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA795983" 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
1216411	1216411	PRJNA795983_S_NODE_29101_length_271_cov_0.964646_g28976_i0	PRJNA795983	29101	271	0.964646	2.6141906600000002	Microbacterium	33882	Bacteria	Bacteria	407	4.6e-109	NTclustered	gi\|2059373039\|gb\|CP064873.1\|	199592	g28976	i0	93.727	36.3284132841328	271	17	100	0	1	271	1356815	1357085	Microbacterium paraoxydans strain 70447 chromosome, complete genome	blastn	9845	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium paraoxydans
2056136	2056136	PRJNA795983_S_NODE_40682_length_244_cov_0.900585_g40557_i0	PRJNA795983	40682	244	0.900585	2.1974274	Microbacterium sp. Nx66	2766784	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1898671386\|emb\|LR880474.1\|	2766784	g40557	i0	98.77	59.2622950819672	244	3	100	0	1	244	781146	781389	Microbacterium sp. Nx66 genome assembly, chromosome: Nx66	blastn	14460	435	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. Nx66
2491919	2491919	PRJNA795983_S_NODE_21922_length_298_cov_1.555556_g21797_i0	PRJNA795983	21922	298	1.555556	4.63555688	Cutibacterium	1912216	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g21797	i0	100	290.288590604027	298	0	100	0	1	298	56065	55768	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	86506	551	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3331228	3331228	PRJNA795983_S_NODE_28803_length_272_cov_0.924623_g28678_i0	PRJNA795983	28803	272	0.924623	2.51497456	Pseudarthrobacter psychrotolerans	2697569	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1799228131\|gb\|CP047898.1\|	2697569	g28678	i0	100	0.102941176470588	28	0	10	0	148	175	3934314	3934287	Pseudarthrobacter psychrotolerans strain YJ56 chromosome contig_1, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter psychrotolerans
5044652	5044652	PRJNA795983_S_NODE_31624_length_262_cov_3.095238_g31499_i0	PRJNA795983	31624	262	3.095238	8.10952356	Corynebacterium	1716	Bacteria	Bacteria	470	5.57e-128	NTclustered	gi\|507148198\|ref\|NR_103005.1\|	1727	g31499	i0	100	306.435114503817	254	0	97	0	1	254	2328	2581	Corynebacterium variabile strain DSM 44702 23S ribosomal RNA gene, complete sequence	blastn	80286	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium variabile
5044662	5044662	PRJNA795983_S_NODE_39804_length_245_cov_0.965116_g39679_i0	PRJNA795983	39804	245	0.965116	2.3645342	Cutibacterium	1912216	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g39679	i0	100	51.9918367346939	245	0	100	0	1	245	921358	921114	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12738	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6320523	6320523	PRJNA795983_S_NODE_2465_length_662_cov_2.830221_g2352_i0	PRJNA795983	2465	662	2.830221	18.73606302	Microbacterium	33882	Bacteria	Bacteria	1144	0	NTclustered	gi\|2528150176\|gb\|CP128474.1\|	33883	g2352	i0	97.885	166.996978851964	662	13	99	1	1	661	2055835	2056496	Microbacterium arborescens strain SSF12 chromosome, complete genome	blastn	110552	1144	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium arborescens
6320545	6320545	PRJNA795983_S_NODE_40125_length_245_cov_0.877907_g40000_i0	PRJNA795983	40125	245	0.877907	2.15087215	Cutibacterium	1912216	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g40000	i0	100	53	245	0	100	0	1	245	1283199	1283443	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12985	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7158433	7158433	PRJNA795983_S_NODE_22186_length_297_cov_1.267857_g22061_i0	PRJNA795983	22186	297	1.267857	3.76553529	Arthrobacter sp. PAMC 25486	1494608	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|723606223\|gb\|CP007595.1\|	1494608	g22061	i0	100	0.0942760942760943	28	0	9	0	84	111	200914	200941	Arthrobacter sp. PAMC25486, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. PAMC 25486
7158605	7158605	PRJNA795983_S_NODE_37886_length_248_cov_0.880000_g37761_i0	PRJNA795983	37886	248	0.88	2.1824	Paenarthrobacter aurescens	43663	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|119951388\|gb\|CP000475.1\|	290340	g37761	i0	87.903	5.72177419354839	248	30	100	0	1	248	308676	308923	Paenarthrobacter aurescens TC1 plasmid pTC1, complete sequence	blastn	1419	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Paenarthrobacter	Paenarthrobacter aurescens
8869705	8869705	PRJNA795983_S_NODE_34287_length_255_cov_1.379121_g34162_i0	PRJNA795983	34287	255	1.379121	3.51675855	Sanguibacter	60919	Bacteria	Bacteria	442	1.1799999999999994e-119	NTclustered	gi\|470485463\|ref\|NR_076702.1\|	60920	g34162	i0	98.413	303.18431372548997	252	3	98	1	5	255	919	1170	Sanguibacter keddieii strain ST-74 23S ribosomal RNA gene, complete sequence	blastn	77312	442	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Sanguibacteraceae	Sanguibacter	Sanguibacter keddieii
10144979	10144979	PRJNA795983_S_NODE_13168_length_352_cov_2.401434_g13043_i0	PRJNA795983	13168	352	2.401434	8.45304768	Cutibacterium	1912216	Bacteria	Bacteria	573	5.739999999999999e-159	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13043	i0	96.802	273.386363636364	344	9	97	2	10	352	56428	56770	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	96232	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12259710	12259710	PRJNA795983_S_NODE_39170_length_246_cov_0.890173_g39045_i0	PRJNA795983	39170	246	0.890173	2.18982558	Arthrobacter alpinus	656366	Bacteria	Bacteria	106	1.68e-18	NTclustered	gi\|953319885\|gb\|CP013200.1\|	656366	g39045	i0	85.859	8.86991869918699	99	14	40	0	1	99	643847	643945	Arthrobacter alpinus strain ERGS4:06, complete genome	blastn	2182	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter alpinus
15244944	15244944	PRJNA795983_S_NODE_39412_length_246_cov_0.878613_g39287_i0	PRJNA795983	39412	246	0.878613	2.16138798	Cutibacterium	1912216	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g39287	i0	100	51	246	0	100	0	1	246	1350759	1351004	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12546	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15244947	15244947	PRJNA795983_S_NODE_40872_length_244_cov_0.894737_g40747_i0	PRJNA795983	40872	244	0.894737	2.18315828	Cutibacterium	1912216	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g40747	i0	99.59	50.7663934426229	244	1	100	0	1	244	2338359	2338602	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12387	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16082634	16082634	PRJNA795983_S_NODE_29553_length_269_cov_1.556122_g29428_i0	PRJNA795983	29553	269	1.556122	4.18596818	Rothia terrae	396015	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1907834973\|gb\|CP061539.1\|	396015	g29428	i0	100	238.520446096654	269	0	100	0	1	269	1733375	1733643	Rothia terrae strain KJZ-14 chromosome, complete genome	blastn	64162	497	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
16082715	16082715	PRJNA795983_S_NODE_39293_length_246_cov_0.890173_g39168_i0	PRJNA795983	39293	246	0.890173	2.18982558	Janibacter terrae	103817	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2732501705\|gb\|CP144167.1\|	103817	g39168	i0	97.967	2.19512195121951	246	5	100	0	1	246	834171	833926	Janibacter terrae strain Sec5.9 chromosome, complete genome	blastn	540	427	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter terrae
16082736	16082736	PRJNA795983_S_NODE_41353_length_243_cov_0.905882_g41228_i0	PRJNA795983	41353	243	0.905882	2.20129326	Microbacterium meiriae (nom. nud.)	3041512	Bacteria	Bacteria	327	3.25e-85	NTclustered	gi\|2588111594\|gb\|CP133984.1\|	3041512	g41228	i0	90.947	1	243	22	100	0	1	243	1296296	1296054	Microbacterium meiriae (nom. nud.) strain F6_8S_P_2B chromosome	blastn	243	327	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium meiriae (nom. nud.)
17358399	17358399	PRJNA795983_S_NODE_20974_length_303_cov_0.847826_g20849_i0	PRJNA795983	20974	303	0.847826	2.56891278	Micromonospora inositola	47865	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1052686253\|emb\|LT607754.1\|	47865	g20849	i0	97.059	0.112211221122112	34	0	11	1	35	67	1195017	1195050	Micromonospora inositola strain DSM 43819 genome assembly, chromosome: I	blastn	34	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora inositola
17794212	17794212	PRJNA795983_S_NODE_37214_length_249_cov_0.875000_g37089_i0	PRJNA795983	37214	249	0.875	2.17875	Cutibacterium	1912216	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g37089	i0	100	51	249	0	100	0	1	249	694305	694553	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12699	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18631692	18631692	PRJNA795983_S_NODE_36515_length_250_cov_0.870056_g36390_i0	PRJNA795983	36515	250	0.870056	2.17514	Nocardioides rotundus	1774216	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2093991421\|gb\|CP082922.1\|	1774216	g36390	i0	100	1.6	250	0	100	0	1	250	3910247	3910496	Nocardioides rotundus strain MCCC 1A10561 chromosome, complete genome	blastn	400	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides rotundus
19068197	19068197	PRJNA795983_S_NODE_35195_length_252_cov_2.335196_g35070_i0	PRJNA795983	35195	252	2.335196	5.88469392	Cellulosimicrobium	157920	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1708014107\|gb\|CP041694.1\|	1710	g35070	i0	100	267.440476190476	252	0	100	0	1	252	2394583	2394834	Cellulosimicrobium cellulans strain NEB113 chromosome, complete genome	blastn	67395	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Promicromonosporaceae	Cellulosimicrobium	Cellulosimicrobium cellulans
19068213	19068213	PRJNA795983_S_NODE_44075_length_232_cov_2.735849_g43950_i0	PRJNA795983	44075	232	2.735849	6.34716968	Cutibacterium	1912216	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1898669123\|emb\|LR588480.1\|	1747	g43950	i0	99.569	242.530172413793	232	1	100	0	1	232	423	192	Cutibacterium acnes partial 16S rRNA gene, isolate PD1MD	blastn	56267	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19906940	19906940	PRJNA795983_S_NODE_33836_length_256_cov_1.644809_g33711_i0	PRJNA795983	33836	256	1.644809	4.21071104	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	451	1.96e-122	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g33711	i0	99.2	307.03515625	250	2	98	0	7	256	552420	552171	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	78601	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
20342921	20342921	PRJNA795983_S_NODE_13396_length_350_cov_2.353791_g13271_i0	PRJNA795983	13396	350	2.353791	8.2382685	Streptomyces	1883	Bacteria	Bacteria	108	6.96e-19	NTclustered	gi\|2659919528\|gb\|CP109211.1\|	1919	g13271	i0	81.022	38.4285714285714	137	24	39	2	214	349	6117352	6117217	Streptomyces microflavus strain NBC 01683 chromosome, complete genome	blastn	13450	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces microflavus
20342963	20342963	PRJNA795983_S_NODE_40896_length_244_cov_0.883041_g40771_i0	PRJNA795983	40896	244	0.883041	2.15462004	Cutibacterium	1912216	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g40771	i0	100	53	244	0	100	0	1	244	120470	120227	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12932	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21182634	21182634	PRJNA795983_S_NODE_33757_length_256_cov_1.967213_g33632_i0	PRJNA795983	33757	256	1.967213	5.03606528	Rothia amarae	169480	Bacteria	Bacteria	379	9.4e-101	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g33632	i0	94.672	295.87109375	244	13	95	0	1	244	1622742	1622985	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	75743	379	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
22894117	22894117	PRJNA795983_S_NODE_2198_length_694_cov_3.478261_g2092_i0	PRJNA795983	2198	694	3.478261	24.13913134	root	1	Root_unresolved	Root_unresolved	1275	0	NTclustered	gi\|1852867433\|gb\|MT604801.1\|	1747	g2092	i0	99.856	100	694	0	99	1	1	693	304	997	Cutibacterium acnes strain 2344 16S ribosomal RNA gene, partial sequence	blastn	69400	1275	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23732978	23732978	PRJNA795983_S_NODE_32439_length_260_cov_1.620321_g32314_i0	PRJNA795983	32439	260	1.620321	4.2128346	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	464	2.57e-126	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g32314	i0	98.846	344.742307692308	260	3	100	0	1	260	759448	759189	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	89633	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
23733010	23733010	PRJNA795983_S_NODE_36639_length_250_cov_0.870056_g36514_i0	PRJNA795983	36639	250	0.870056	2.17514	Nocardioides sp. JS614	196162	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|119534933\|gb\|CP000509.1\|	196162	g36514	i0	79.399	0.932	233	42	92	5	20	250	198830	199058	Nocardioides sp. JS614, complete genome	blastn	233	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. JS614
23733064	23733064	PRJNA795983_S_NODE_43199_length_241_cov_0.910714_g43074_i0	PRJNA795983	43199	241	0.910714	2.19482074	Microbacterium sp. str. 'China'	2103230	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|1357648428\|gb\|CP027434.1\|	2103230	g43074	i0	94.894	8.72614107883817	235	12	98	0	1	235	3233631	3233397	Microbacterium sp. str. 'China' chromosome, complete genome	blastn	2103	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. str. 'China'
25443235	25443235	PRJNA795983_S_NODE_10100_length_387_cov_2.000000_g9975_i0	PRJNA795983	10100	387	2	7.74	Micrococcales	85006	Bacteria	Bacteria	555	2.3099999999999993e-153	NTclustered	gi\|758182997\|gb\|CP007437.1\|	1270	g9975	i0	93.801	173.852713178295	371	19	99	4	3	372	1561998	1562365	Micrococcus luteus strain trpE16 genome	blastn	67281	560	0.991071428571429	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25443253	25443253	PRJNA795983_S_NODE_23700_length_290_cov_1.552995_g23575_i0	PRJNA795983	23700	290	1.552995	4.5036855	Mycobacteriales	85007	Bacteria	Bacteria	67.6	9.59e-7	NTclustered	gi\|1018275532\|gb\|CP015235.1\|	1051973	g23575	i0	84.848	0.403448275862069	66	10	23	0	55	120	2882499	2882434	Rhodococcus fascians D188, complete genome	blastn	117	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians

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