metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA663960" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA663960" 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
1904694	1904694	PRJNA663960_S_NODE_14022_length_301_cov_3.165354_g13786_i0	PRJNA663960	14022	301	3.165354	9.52771554	Rothia aeria	172042	Bacteria	Bacteria	457	5.08e-124	NTclustered	gi\|2072522805\|gb\|CP079819.1\|	172042	g13786	i0	94.059	355.249169435216	303	14	100	3	1	301	521971	521671	Rothia aeria strain LPB0401 chromosome, complete genome	blastn	106930	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
1904823	1904823	PRJNA663960_S_NODE_32322_length_214_cov_1.155689_g32086_i0	PRJNA663960	32322	214	1.155689	2.47317446	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	368	1.65e-97	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g32086	i0	97.664	265.766355140187	214	5	100	0	1	214	553494	553281	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	56874	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2437206	2437206	PRJNA663960_S_NODE_13302_length_306_cov_3.416988_g13066_i0	PRJNA663960	13302	306	3.416988	10.45598328	Microbacterium	33882	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g13066	i0	99.346	171.254901960784	306	2	100	0	1	306	230901	230596	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	52404	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
2437297	2437297	PRJNA663960_S_NODE_362_length_959_cov_25.968202_g271_i0	PRJNA663960	362	959	25.968202	249.03505718	Cutibacterium	1912216	Bacteria	Bacteria	1720	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g271	i0	99.893	273.196037539103	934	1	97	0	1	934	56283	55350	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	261995	1720	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3179587	3179587	PRJNA663960_S_NODE_283_length_1056_cov_27.734390_g206_i0	PRJNA663960	283	1056	27.73439	292.8751584	Brevibacterium casei	33889	Bacteria	Bacteria	1951	0	NTclustered	gi\|1958263390\|gb\|CP068173.1\|	33889	g206	i0	100	299.283143939394	1056	0	100	0	1	1056	2220329	2219274	Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome	blastn	316043	1951	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
3179732	3179732	PRJNA663960_S_NODE_48463_length_174_cov_1.614173_g48227_i0	PRJNA663960	48463	174	1.614173	2.80866102	Cutibacterium granulosum	33011	Bacteria	Bacteria	311	2.19e-80	NTclustered	gi\|1231673337\|emb\|LT906441.1\|	33011	g48227	i0	98.851	15.0804597701149	174	2	100	0	1	174	1036205	1036032	Cutibacterium granulosum strain NCTC11865 genome assembly, chromosome: 1	blastn	2624	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
3713826	3713826	PRJNA663960_S_NODE_48363_length_174_cov_2.409449_g48127_i0	PRJNA663960	48363	174	2.409449	4.19244126	Rothia	32207	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2894499433\|gb\|CP178330.1\|	2047	g48127	i0	100	230.086206896552	174	0	100	0	1	174	901490	901317	Rothia dentocariosa strain SOSUI028 chromosome, complete genome	blastn	40035	322	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
4990386	4990386	PRJNA663960_S_NODE_3784_length_450_cov_16.575682_g3549_i0	PRJNA663960	3784	450	16.575682	74.590569	Corynebacterium	1716	Bacteria	Bacteria	732	0	NTclustered	gi\|470484386\|ref\|NR_076645.1\|	161879	g3549	i0	96	354.688888888889	450	18	100	0	1	450	2773	2324	Corynebacterium kroppenstedtii strain DSM 44385 23S ribosomal RNA gene, complete sequence	blastn	159610	732	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
6265926	6265926	PRJNA663960_S_NODE_38285_length_197_cov_1.240000_g38049_i0	PRJNA663960	38285	197	1.24	2.4428	Cutibacterium	1912216	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g38049	i0	100	53.1167512690355	197	0	100	0	1	197	370282	370478	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10464	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7007219	7007219	PRJNA663960_S_NODE_15586_length_291_cov_3.475410_g15350_i0	PRJNA663960	15586	291	3.47541	10.1134431	Brevibacterium casei	33889	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g15350	i0	100	21.6013745704467	291	0	100	0	1	291	3625870	3625580	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	6286	538	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
7007512	7007512	PRJNA663960_S_NODE_55946_length_163_cov_1.318966_g55710_i0	PRJNA663960	55946	163	1.318966	2.14991458	Corynebacterium pseudodiphtheriticum	37637	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2550423345\|gb\|CP100362.1\|	37637	g55710	i0	100	398.79754601227	163	0	100	0	1	163	2290990	2291152	Corynebacterium pseudodiphtheriticum strain CP10 chromosome	blastn	65004	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum
8815163	8815163	PRJNA663960_S_NODE_8587_length_349_cov_2.748344_g8351_i0	PRJNA663960	8587	349	2.748344	9.59172056	Cutibacterium	1912216	Bacteria	Bacteria	645	1.1899999999999993e-180	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g8351	i0	100	60.621776504298	349	0	100	0	1	349	2254328	2254676	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	21157	645	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9557351	9557351	PRJNA663960_S_NODE_5248_length_404_cov_4.882353_g5012_i0	PRJNA663960	5248	404	4.882353	19.72470612	Corynebacterium pseudodiphtheriticum	37637	Bacteria	Bacteria	732	0	NTclustered	gi\|2212856580\|gb\|CP051667.1\|	37637	g5012	i0	99.263	314.873762376238	407	0	100	1	1	404	1104107	1103701	Corynebacterium pseudodiphtheriticum strain 10700 chromosome	blastn	127209	732	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum
10832670	10832670	PRJNA663960_S_NODE_12249_length_314_cov_9.228464_g12013_i0	PRJNA663960	12249	314	9.228464	28.97737696	Corynebacterium kroppenstedtii	161879	Bacteria	Bacteria	575	1.4099999999999994e-159	NTclustered	gi\|2809007534\|gb\|CP119163.1\|	2736648	g12013	i0	99.682	462.694267515924	314	1	100	0	1	314	187612	187299	Corynebacterium kroppenstedtii subsp. demodicis strain Df-1 chromosome, complete genome	blastn	145286	575	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
12108065	12108065	PRJNA663960_S_NODE_3330_length_469_cov_3.218009_g3098_i0	PRJNA663960	3330	469	3.218009	15.09246221	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	852	0	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g3098	i0	99.363	370.053304904051	471	1	100	1	1	469	621893	622363	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	173555	852	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
13382612	13382612	PRJNA663960_S_NODE_12571_length_312_cov_2.592453_g12335_i0	PRJNA663960	12571	312	2.592453	8.08845336	Brevibacterium casei	33889	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g12335	i0	100	5.58974358974359	312	0	100	0	1	312	2881339	2881650	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	1744	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
13382830	13382830	PRJNA663960_S_NODE_41571_length_189_cov_1.077465_g41335_i0	PRJNA663960	41571	189	1.077465	2.03640885	Brevibacterium casei	33889	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g41335	i0	100	13.9047619047619	189	0	100	0	1	189	1024851	1024663	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	2628	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
13382946	13382946	PRJNA663960_S_NODE_57051_length_162_cov_1.330435_g56815_i0	PRJNA663960	57051	162	1.330435	2.1553047	Brevibacterium casei	33889	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g56815	i0	99.383	30.0432098765432	162	1	100	0	1	162	565979	565818	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	4867	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
13916039	13916039	PRJNA663960_S_NODE_2831_length_494_cov_7.595078_g2605_i0	PRJNA663960	2831	494	7.595078	37.51968532	Corynebacterium	1716	Bacteria	Bacteria	813	0	NTclustered	gi\|470484386\|ref\|NR_076645.1\|	161879	g2605	i0	96.378	407.192307692308	497	13	100	5	1	494	158	652	Corynebacterium kroppenstedtii strain DSM 44385 23S ribosomal RNA gene, complete sequence	blastn	201153	815	0.997546012269939	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
14657910	14657910	PRJNA663960_S_NODE_8792_length_347_cov_1.493333_g8556_i0	PRJNA663960	8792	347	1.493333	5.18186551	Schaalia odontolytica	1660	Bacteria	Bacteria	460	4.609999999999999e-125	NTclustered	gi\|2283191586\|gb\|CP102197.1\|	1660	g8556	i0	90.652	109.904899135447	353	24	100	7	1	347	8595	8246	Schaalia odontolytica strain KHUD_008 chromosome, complete genome	blastn	38137	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
15190609	15190609	PRJNA663960_S_NODE_2092_length_544_cov_1.949698_g1875_i0	PRJNA663960	2092	544	1.949698	10.60635712	Rothia	32207	Bacteria	Bacteria	922	0	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g1875	i0	97.253	381.430147058824	546	12	100	3	1	544	652799	652255	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	207498	922	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
18481295	18481295	PRJNA663960_S_NODE_58975_length_160_cov_2.247788_g58739_i0	PRJNA663960	58975	160	2.247788	3.5964608	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	279	5.59e-71	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g58739	i0	98.125	364.41875	160	3	100	0	1	160	552829	552988	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	58307	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
21564048	21564048	PRJNA663960_S_NODE_24937_length_241_cov_4.716495_g24701_i0	PRJNA663960	24937	241	4.716495	11.36675295	Corynebacterium	1716	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|2550482033\|gb\|CP100379.1\|	38284	g24701	i0	97.872	367.298755186722	235	5	98	0	1	235	2461433	2461667	Corynebacterium accolens strain CA4 chromosome	blastn	88519	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
24114094	24114094	PRJNA663960_S_NODE_59079_length_160_cov_1.805310_g58843_i0	PRJNA663960	59079	160	1.80531	2.888496	Rothia	32207	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|2894499433\|gb\|CP178330.1\|	2047	g58843	i0	100	372.225	160	0	100	0	1	160	902391	902232	Rothia dentocariosa strain SOSUI028 chromosome, complete genome	blastn	59556	296	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
24854862	24854862	PRJNA663960_S_NODE_1800_length_575_cov_1.405303_g1590_i0	PRJNA663960	1800	575	1.405303	8.08049225	Corynebacterium pseudodiphtheriticum	37637	Bacteria	Bacteria	998	0	NTclustered	gi\|2240706176\|gb\|CP091863.1\|	37637	g1590	i0	99.277	313.038260869565	553	3	96	1	1	552	720412	719860	Corynebacterium pseudodiphtheriticum strain PC1145 chromosome, complete genome	blastn	179997	998	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum

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