metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA564810" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA564810" 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
1133600	1133600	PRJNA564810_S_NODE_921_length_412_cov_11.755043_g899_i0	PRJNA564810	921	412	11.755043	48.43077716	Rothia	32207	Bacteria	Bacteria	761	0	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g899	i0	100	427.966019417476	412	0	100	0	1	412	652866	653277	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	176322	761	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
1829651	1829651	PRJNA564810_S_NODE_4162_length_270_cov_1.321951_g4140_i0	PRJNA564810	4162	270	1.321951	3.5692677	Actinotignum schaalii	59505	Bacteria	Bacteria	246	1.06e-60	NTclustered	gi\|663076034\|gb\|CP008802.1\|	59505	g4140	i0	84.03	209.544444444444	263	35	96	7	11	270	390759	391017	Actinotignum schaalii strain CCUG 27420 chromosome, complete genome	blastn	56577	246	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinotignum	Actinotignum schaalii
3684979	3684979	PRJNA564810_S_NODE_823_length_427_cov_13.414365_g801_i0	PRJNA564810	823	427	13.414365	57.27933855	Cutibacterium	1912216	Bacteria	Bacteria	789	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g801	i0	100	248.526932084309	427	0	100	0	1	427	55798	55372	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	106121	789	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6237110	6237110	PRJNA564810_S_NODE_1925_length_341_cov_1.228261_g1903_i0	PRJNA564810	1925	341	1.228261	4.18837001	Cutibacterium	1912216	Bacteria	Bacteria	630	3.2499999999999986e-176	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1903	i0	100	272.117302052786	341	0	100	0	1	341	56721	57061	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	92792	630	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6932207	6932207	PRJNA564810_S_NODE_1366_length_371_cov_23.594771_g1344_i0	PRJNA564810	1366	371	23.594771	87.53660041	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	625	1.6599999999999994e-174	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g1344	i0	97.035	237.741239892183	371	11	100	0	1	371	553574	553204	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	88202	625	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
8786415	8786415	PRJNA564810_S_NODE_187_length_669_cov_5.882450_g171_i0	PRJNA564810	187	669	5.88245	39.3535905	Cutibacterium	1912216	Bacteria	Bacteria	1214	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g171	i0	99.402	276.372197309417	669	4	100	0	1	669	56565	55897	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	184893	1214	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8786420	8786420	PRJNA564810_S_NODE_7647_length_216_cov_2.622517_g7625_i0	PRJNA564810	7647	216	2.622517	5.66463672	Schaalia	2529408	Bacteria	Bacteria	374	3.5799999999999997e-99	NTclustered	gi\|2283191586\|gb\|CP102197.1\|	1660	g7625	i0	98.14	196.550925925926	215	3	99	1	1	214	6914	7128	Schaalia odontolytica strain KHUD_008 chromosome, complete genome	blastn	42455	377	0.992042440318302	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
10062081	10062081	PRJNA564810_S_NODE_4768_length_258_cov_0.901554_g4746_i0	PRJNA564810	4768	258	0.901554	2.32600932	Arthrobacter	1663	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1540577218\|dbj\|AP018697.1\|	1571833	g4746	i0	99.225	454.325581395349	258	2	100	0	1	258	573483	573740	Arthrobacter sp. MN05-02 DNA, complete genome	blastn	117216	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. MN05-02
13887478	13887478	PRJNA564810_S_NODE_1031_length_401_cov_4.431548_g1009_i0	PRJNA564810	1031	401	4.431548	17.77050748	Actinomycetes	1760	Bacteria	Bacteria	63.9	1.78e-5	NTclustered	gi\|2591784657\|gb\|CP133386.1\|	2035	g1009	i0	100	11.3291770573566	34	0	8	0	310	343	1993900	1993867	Curtobacterium flaccumfaciens strain W004 chromosome	blastn	4543	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium flaccumfaciens
13887481	13887481	PRJNA564810_S_NODE_3531_length_284_cov_1.575342_g3509_i0	PRJNA564810	3531	284	1.575342	4.47397128	Corynebacterium	1716	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|2548743884\|gb\|CP073092.1\|	38304	g3509	i0	100	368.728873239437	284	0	100	0	1	284	2287996	2288279	Corynebacterium tuberculostearicum strain CTNIH13 chromosome, complete genome	blastn	104719	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
15856856	15856856	PRJNA564810_S_NODE_5673_length_242_cov_1.932203_g5651_i0	PRJNA564810	5673	242	1.932203	4.67593126	Svornostia abyssi	2898438	Bacteria	Bacteria	224	4.369999999999999e-54	NTclustered	gi\|2285509232\|gb\|CP088295.1\|	2898438	g5651	i0	83.682	82.7933884297521	239	37	98	2	3	240	3324005	3323768	Svornostia abyssi strain J379 chromosome	blastn	20036	224	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Baekduiaceae	Svornostia	Svornostia abyssi
17711475	17711475	PRJNA564810_S_NODE_1854_length_343_cov_10.953237_g1832_i0	PRJNA564810	1854	343	10.953237	37.56960291	Corynebacterium	1716	Bacteria	Bacteria	634	2.5299999999999996e-177	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g1832	i0	100	364.125364431487	343	0	100	0	1	343	759914	760256	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	124895	634	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
18984861	18984861	PRJNA564810_S_NODE_1235_length_382_cov_2.883281_g1213_i0	PRJNA564810	1235	382	2.883281	11.01413342	Rothia	32207	Bacteria	Bacteria	701	0	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g1213	i0	99.738	348.431937172775	382	1	100	0	1	382	152	533	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	133101	701	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
22810724	22810724	PRJNA564810_S_NODE_8098_length_211_cov_2.205479_g8076_i0	PRJNA564810	8098	211	2.205479	4.65356069	Kineococcus	33981	Bacteria	Bacteria	237	4.77e-58	NTclustered	gi\|470482254\|ref\|NR_076522.1\|	131568	g8076	i0	88.5	193.293838862559	200	18	93	4	1	196	187	385	Kineococcus radiotolerans strain SRS30216 23S ribosomal RNA gene, complete sequence	blastn	40785	237	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kineosporiales	Kineosporiaceae	Kineococcus	Kineococcus radiotolerans
24085444	24085444	PRJNA564810_S_NODE_6959_length_223_cov_5.113924_g6937_i0	PRJNA564810	6959	223	5.113924	11.40405052	Micrococcus	1269	Bacteria	Bacteria	398	2.21e-106	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g6937	i0	99.541	184.587443946188	218	1	99	0	4	221	345895	345678	Micrococcus luteus strain V017 chromosome, complete genome	blastn	41163	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
24780405	24780405	PRJNA564810_S_NODE_4740_length_258_cov_2.766839_g4718_i0	PRJNA564810	4740	258	2.766839	7.13844462	uncultured Frankia sp.	181582	Bacteria	Bacteria	267	7.699999999999999e-67	NTclustered	gi\|48728170\|gb\|AY627742.1\|	181582	g4718	i0	86	153.263565891473	250	34	97	1	10	258	813	564	Uncultured Frankia sp. clone CEIN1307 16S-23S intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39542	267	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Frankia	uncultured Frankia sp.
25359969	25359969	PRJNA564810_S_NODE_3300_length_290_cov_2.417778_g3278_i0	PRJNA564810	3300	290	2.417778	7.0115562	Rothia	32207	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g3278	i0	100	280	290	0	100	0	1	290	651628	651339	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	81200	536	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa

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