metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1233317" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1233317" 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
3597716	3597716	PRJNA1233317_S_NODE_9263_length_255_cov_2.948980_g9227_i0	PRJNA1233317	9263	255	2.94898	7.519899	Micrococcus	1269	Bacteria	Bacteria	460	3.25e-125	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g9227	i0	99.216	338.470588235294	255	2	100	0	1	255	1013000	1012746	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	86310	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
4875234	4875234	PRJNA1233317_S_NODE_4004_length_337_cov_4.543165_g3968_i0	PRJNA1233317	4004	337	4.543165	15.31046605	Cutibacterium	1912216	Bacteria	Bacteria	606	5.409999999999998e-169	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3968	i0	99.11	271.403560830861	337	3	100	0	1	337	56157	56493	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	91463	606	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5438871	5438871	PRJNA1233317_S_NODE_16685_length_186_cov_3.362205_g16649_i0	PRJNA1233317	16685	186	3.362205	6.2537013	Micrococcus porci	2856555	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|2099415156\|gb\|CP083691.1\|	2856555	g16649	i0	100	289.720430107527	186	0	100	0	1	186	1563	1748	Micrococcus porci strain KD337-16 chromosome, complete genome	blastn	53888	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus porci
6150007	6150007	PRJNA1233317_S_NODE_7325_length_282_cov_2.659193_g7289_i0	PRJNA1233317	7325	282	2.659193	7.49892426	Cutibacterium	1912216	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7289	i0	100	51	282	0	100	0	1	282	1632038	1631757	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14382	521	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6150010	6150010	PRJNA1233317_S_NODE_9645_length_250_cov_2.225131_g9609_i0	PRJNA1233317	9645	250	2.225131	5.5628275	Corynebacterium	1716	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|57158193\|dbj\|AB193038.1\|	1718	g9609	i0	97.959	448.552	245	5	98	0	6	250	8128	8372	Corynebacterium glutamicum DNA, strain specific island 11, strain: R	blastn	112138	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glutamicum
7989044	7989044	PRJNA1233317_S_NODE_15167_length_197_cov_1.768116_g15131_i0	PRJNA1233317	15167	197	1.768116	3.48318852	Corynebacterium massiliense	441501	Bacteria	Bacteria	359	8.98e-95	NTclustered	gi\|2443256375\|gb\|CP063189.1\|	1121364	g15131	i0	99.492	4	197	1	100	0	1	197	629761	629957	Corynebacterium massiliense DSM 45435 chromosome, complete genome	blastn	788	359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium massiliense
11250483	11250483	PRJNA1233317_S_NODE_1669_length_406_cov_9.896254_g1633_i0	PRJNA1233317	1669	406	9.896254	40.17879124	Cutibacterium	1912216	Bacteria	Bacteria	750	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1633	i0	100	277.475369458128	406	0	100	0	1	406	57253	56848	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	112655	750	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11250515	11250515	PRJNA1233317_S_NODE_7329_length_282_cov_2.206278_g7293_i0	PRJNA1233317	7329	282	2.206278	6.22170396	Corynebacterium	1716	Bacteria	Bacteria	505	1.6599999999999995e-138	NTclustered	gi\|954623576\|gb\|CP012194.1\|	1718	g7293	i0	98.936	428.5	282	3	100	0	1	282	1007593	1007312	Corynebacterium glutamicum strain CP, complete genome	blastn	120837	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glutamicum
11814300	11814300	PRJNA1233317_S_NODE_7170_length_284_cov_4.515556_g7134_i0	PRJNA1233317	7170	284	4.515556	12.82417904	Microbacterium sp. PM5	2014534	Bacteria	Bacteria	398	2.9199999999999993e-106	NTclustered	gi\|1419380645\|gb\|CP022162.1\|	2014534	g7134	i0	91.901	14.9718309859155	284	23	100	0	1	284	2654402	2654685	Microbacterium sp. PM5 genome	blastn	4252	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. PM5
13089284	13089284	PRJNA1233317_S_NODE_15811_length_193_cov_2.276119_g15775_i0	PRJNA1233317	15811	193	2.276119	4.39290967	Actinomyces oris	544580	Bacteria	Bacteria	340	3.17e-89	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g15775	i0	98.446	454.870466321243	193	3	100	0	1	193	945982	946174	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	87790	340	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
13089290	13089290	PRJNA1233317_S_NODE_18511_length_167_cov_6.398148_g18475_i0	PRJNA1233317	18511	167	6.398148	10.68490716	Microbacterium sediminis	904291	Bacteria	Bacteria	100	4.93e-17	NTclustered	gi\|1605155173\|gb\|CP038256.1\|	904291	g18475	i0	78.235	1.98802395209581	170	28	99	6	2	167	1945537	1945373	Microbacterium sediminis strain YLB-01 chromosome, complete genome	blastn	332	100	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sediminis
13089323	13089323	PRJNA1233317_S_NODE_471_length_573_cov_6.642023_g436_i0	PRJNA1233317	471	573	6.642023	38.05879179	Cutibacterium granulosum	33011	Bacteria	Bacteria	859	0	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g436	i0	93.924	240.366492146597	576	24	100	9	1	573	485882	486449	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	137730	859	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
13800525	13800525	PRJNA1233317_S_NODE_7971_length_272_cov_5.769953_g7935_i0	PRJNA1233317	7971	272	5.769953	15.69427216	Microbacterium	33882	Bacteria	Bacteria	398	2.7799999999999997e-106	NTclustered	gi\|938161749\|gb\|CP012697.1\|	1714373	g7935	i0	93.015	100.658088235294	272	19	100	0	1	272	2414772	2414501	Microbacterium sp. No. 7 chromosome, complete genome	blastn	27379	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. No. 7
15074760	15074760	PRJNA1233317_S_NODE_5052_length_318_cov_2.590734_g5016_i0	PRJNA1233317	5052	318	2.590734	8.23853412	Microbacterium	33882	Bacteria	Bacteria	466	8.98e-127	NTclustered	gi\|2551333448\|gb\|CP130429.1\|	33918	g5016	i0	93.103	156.44025157232701	319	20	100	2	1	318	1434850	1434533	Microbacterium maritypicum strain MWF001 chromosome, complete genome	blastn	49748	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
15638609	15638609	PRJNA1233317_S_NODE_5613_length_308_cov_2.477912_g5577_i0	PRJNA1233317	5613	308	2.477912	7.63196896	Micrococcus porci	2856555	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|2099415156\|gb\|CP083691.1\|	2856555	g5577	i0	99.675	125.425324675325	308	1	100	0	1	308	5311	5618	Micrococcus porci strain KD337-16 chromosome, complete genome	blastn	38631	564	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus porci
17624902	17624902	PRJNA1233317_S_NODE_5594_length_308_cov_3.983936_g5558_i0	PRJNA1233317	5594	308	3.983936	12.27052288	Rhodococcus	1827	Bacteria	Bacteria	508	1.42e-139	NTclustered	gi\|2179868499\|gb\|CP032403.1\|	1833	g5558	i0	96.429	2	308	11	100	0	1	308	365164	365471	Rhodococcus erythropolis strain D310-1 chromosome, complete genome	blastn	616	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
18187215	18187215	PRJNA1233317_S_NODE_7095_length_285_cov_5.610619_g7059_i0	PRJNA1233317	7095	285	5.610619	15.99026415	Clavibacter michiganensis	28447	Bacteria	Bacteria	250	8.699999999999999e-62	NTclustered	gi\|772242489\|gb\|CP011043.1\|	33014	g7059	i0	82.927	49.645614035087704	287	39	99	9	1	282	2504574	2504855	Clavibacter michiganensis subsp. insidiosus strain R1-1, complete genome	blastn	14149	250	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
18898665	18898665	PRJNA1233317_S_NODE_455_length_581_cov_5.854406_g421_i0	PRJNA1233317	455	581	5.854406	34.01409886	Microbacterium	33882	Bacteria	Bacteria	946	0	NTclustered	gi\|1933612020\|gb\|CP064760.1\|	69362	g421	i0	96.062	167.726333907057	584	18	100	5	1	581	1100869	1100288	Microbacterium schleiferi strain A32-1 chromosome, complete genome	blastn	97449	955	0.990575916230366	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium schleiferi
20173480	20173480	PRJNA1233317_S_NODE_9716_length_249_cov_3.042105_g9680_i0	PRJNA1233317	9716	249	3.042105	7.57484145	Microbacterium	33882	Bacteria	Bacteria	307	4.3600000000000006e-79	NTclustered	gi\|1898671386\|emb\|LR880474.1\|	2766784	g9680	i0	94.472	83.7269076305221	199	11	80	0	51	249	1137797	1137599	Microbacterium sp. Nx66 genome assembly, chromosome: Nx66	blastn	20848	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. Nx66
20737091	20737091	PRJNA1233317_S_NODE_3597_length_346_cov_4.247387_g3561_i0	PRJNA1233317	3597	346	4.247387	14.69595902	Rothia aeria	172042	Bacteria	Bacteria	640	5.4999999999999996e-179	NTclustered	gi\|2072522805\|gb\|CP079819.1\|	172042	g3561	i0	100	329.682080924855	346	0	100	0	1	346	523623	523278	Rothia aeria strain LPB0401 chromosome, complete genome	blastn	114070	640	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
22012337	22012337	PRJNA1233317_S_NODE_2178_length_385_cov_7.653374_g2142_i0	PRJNA1233317	2178	385	7.653374	29.4654899	Cutibacterium granulosum	33011	Bacteria	Bacteria	712	0	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g2142	i0	100	275.041558441558	385	0	100	0	1	385	487178	487562	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	105891	712	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
23999230	23999230	PRJNA1233317_S_NODE_2339_length_380_cov_4.831776_g2303_i0	PRJNA1233317	2339	380	4.831776	18.3607488	Microbacterium	33882	Bacteria	Bacteria	691	0	NTclustered	gi\|1850196339\|gb\|CP054038.1\|	162426	g2303	i0	99.474	162.636842105263	380	2	100	0	1	380	2333274	2333653	Microbacterium hominis strain PA2F3 chromosome, complete genome	blastn	61802	691	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hominis
23999260	23999260	PRJNA1233317_S_NODE_8019_length_272_cov_2.136150_g7983_i0	PRJNA1233317	8019	272	2.13615	5.810328	Bifidobacterium	1678	Bacteria	Bacteria	481	2.69e-131	NTclustered	gi\|1721134177\|emb\|LR698979.1\|	33905	g7983	i0	98.529	292.867647058824	272	4	100	0	1	272	1370658	1370929	Bifidobacterium thermophilum isolate MGYG-HGUT-02334 genome assembly, chromosome: 1	blastn	79660	481	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium thermophilum
24561890	24561890	PRJNA1233317_S_NODE_9840_length_247_cov_4.792553_g9804_i0	PRJNA1233317	9840	247	4.792553	11.83760591	Rothia dentocariosa	2047	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2894499433\|gb\|CP178330.1\|	2047	g9804	i0	100	250.425101214575	247	0	100	0	1	247	902042	902288	Rothia dentocariosa strain SOSUI028 chromosome, complete genome	blastn	61855	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa

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