metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
895045	895045	PRJNA915212_P_NODE_12901_length_165_cov_0.879310_g12863_i0	PRJNA915212	12901	165	0.87931	1.4508615	Actinomadura sp. NAK00032	2742128	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1860167784\|gb\|CP054932.1\|	2742128	g12863	i0	100	0.16969696969697	28	0	17	0	44	71	2541788	2541761	Actinomadura sp. NAK00032 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp. NAK00032
895123	895123	PRJNA915212_P_NODE_8481_length_200_cov_1.013245_g8443_i0	PRJNA915212	8481	200	1.013245	2.02649	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	359	9.14e-95	NTclustered	gi\|1806463312\|dbj\|AP022616.1\|	319706	g8443	i0	99.005	172.17	201	1	100	1	1	200	418430	418630	Mycolicibacterium phocaicum JCM 15301 DNA, nearly complete genome	blastn	34434	359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
2526669	2526669	PRJNA915212_P_NODE_14062_length_163_cov_0.894737_g14024_i0	PRJNA915212	14062	163	0.894737	1.45842131	Microbacteriaceae	85023	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|2230249747\|gb\|CP078077.1\|	2851646	g14024	i0	93.023	5.14110429447853	43	0	25	3	65	105	528179	528138	Microbacterium galbinum strain SSW1-36 chromosome	blastn	838	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium galbinum
5998347	5998347	PRJNA915212_P_NODE_13005_length_165_cov_0.879310_g12967_i0	PRJNA915212	13005	165	0.87931	1.4508615	Streptomyces sp. R39	3238631	Bacteria	Bacteria	93.5	8.13e-15	NTclustered	gi\|2783507500\|gb\|CP163442.1\|	3238631	g12967	i0	80.833	29.5151515151515	120	21	72	2	3	121	256120	256002	Streptomyces sp. R39 plasmid unnamed1, complete sequence	blastn	4870	93.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. R39
6355116	6355116	PRJNA915212_P_NODE_545_length_901_cov_1.816901_g523_i0	PRJNA915212	545	901	1.816901	16.37027801	Mycobacteriaceae	1762	Bacteria	Bacteria	1447	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g523	i0	95.686	187.638179800222	904	31	100	4	1	901	1312776	1313674	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	169062	1447	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
7273332	7273332	PRJNA915212_P_NODE_13686_length_163_cov_0.894737_g13648_i0	PRJNA915212	13686	163	0.894737	1.45842131	Mycolicibacterium goodii	134601	Bacteria	Bacteria	261	2.07e-65	NTclustered	gi\|2289144095\|gb\|CP092364.2\|	134601	g13648	i0	95.706	165.263803680982	163	6	100	1	1	163	1003765	1003926	Mycolicibacterium goodii strain ATCC 700504 chromosome, complete genome	blastn	26938	261	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium goodii
8548075	8548075	PRJNA915212_P_NODE_1787_length_497_cov_2.008929_g1752_i0	PRJNA915212	1787	497	2.008929	9.98437713	Streptomyces virginiae	1961	Bacteria	Bacteria	303	1.21e-77	NTclustered	gi\|2687121656\|gb\|CP145515.1\|	1961	g1752	i0	78.511	80.0603621730382	470	95	94	5	3	469	3199931	3200397	Streptomyces virginiae strain THA-960 chromosome, complete genome	blastn	39790	303	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
9823064	9823064	PRJNA915212_P_NODE_6908_length_222_cov_2.271676_g6870_i0	PRJNA915212	6908	222	2.271676	5.04312072	Tsukamurella pulmonis	47312	Bacteria	Bacteria	86.1	1.94e-12	NTclustered	gi\|2174344570\|dbj\|AP025457.1\|	47312	g6870	i0	86.076	40.4279279279279	79	11	36	0	48	126	1608458	1608380	Tsukamurella pulmonis TP-B0596 DNA, complete genome	blastn	8975	86.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella pulmonis
9823083	9823083	PRJNA915212_P_NODE_8988_length_194_cov_1.055172_g8950_i0	PRJNA915212	8988	194	1.055172	2.04703368	Streptomyces sp. NBC_01276	2903808	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2661462342\|gb\|CP108442.1\|	2903808	g8950	i0	100	0.438144329896907	29	0	15	0	78	106	7536489	7536461	Streptomyces sp. NBC_01276 chromosome, complete genome	blastn	85	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01276
10179610	10179610	PRJNA915212_P_NODE_10868_length_174_cov_1.400000_g10830_i0	PRJNA915212	10868	174	1.4	2.436	Streptomyces	1883	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2657704044\|gb\|CP109044.1\|	1944	g10830	i0	100	0.32183908045977	28	0	16	0	122	149	3015218	3015191	Streptomyces halstedii strain NBC 00641 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces halstedii
11098615	11098615	PRJNA915212_P_NODE_11489_length_168_cov_2.117647_g11451_i0	PRJNA915212	11489	168	2.117647	3.55764696	Rhodococcus opacus	37919	Bacteria	Bacteria	63.9	6.52e-6	NTclustered	gi\|2921205402\|gb\|CP134707.1\|	37919	g11451	i0	100	4.76190476190476	34	0	20	0	135	168	3965997	3966030	Rhodococcus opacus strain DSM 43205 chromosome, complete genome	blastn	800	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
12374251	12374251	PRJNA915212_P_NODE_12930_length_165_cov_0.879310_g12892_i0	PRJNA915212	12930	165	0.87931	1.4508615	Ilumatobacter coccineus	467094	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|464097432\|dbj\|AP012057.1\|	1313172	g12892	i0	92.683	0.248484848484848	41	3	25	0	112	152	692553	692513	Ilumatobacter coccineus YM16-304 DNA, complete genome	blastn	41	60.2	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae	Ilumatobacter	Ilumatobacter coccineus
13648768	13648768	PRJNA915212_P_NODE_4491_length_286_cov_1.232068_g4453_i0	PRJNA915212	4491	286	1.232068	3.52371448	Yimella sp. cx-51	2770551	Bacteria	Bacteria	122	1.99e-23	NTclustered	gi\|2019559805\|gb\|CP072113.1\|	2770551	g4453	i0	91.111	31.3216783216783	90	8	31	0	61	150	2085599	2085510	Yimella sp. cx-51 chromosome, complete genome	blastn	8958	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Yimella	Yimella sp. cx-51
13648777	13648777	PRJNA915212_P_NODE_5471_length_253_cov_2.122549_g5433_i0	PRJNA915212	5471	253	2.122549	5.37004897	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	420	5.46e-113	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g5433	i0	97.551	129.328063241107	245	6	97	0	9	253	1312827	1312583	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	32720	420	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
14923105	14923105	PRJNA915212_P_NODE_4052_length_304_cov_2.125490_g4014_i0	PRJNA915212	4052	304	2.12549	6.4614896	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2697500286\|gb\|CP146988.1\|	68042	g4014	i0	100	0.1875	29	0	10	0	224	252	9087023	9087051	Streptomyces hygroscopicus subsp. hygroscopicus strain DSM 41954 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
15278996	15278996	PRJNA915212_P_NODE_3492_length_335_cov_1.783217_g3455_i0	PRJNA915212	3492	335	1.783217	5.97377695	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g3455	i0	86.538	0.952238805970149	52	4	15	3	71	120	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
16197992	16197992	PRJNA915212_P_NODE_11753_length_167_cov_0.864407_g11715_i0	PRJNA915212	11753	167	0.864407	1.44355969	Microbacterium sp. JZ31	1906274	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1972867151\|gb\|CP017661.1\|	1906274	g11715	i0	94.118	0.203592814371257	34	2	20	0	107	140	3083320	3083287	Microbacterium sp. JZ31, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. JZ31
16198032	16198032	PRJNA915212_P_NODE_2533_length_408_cov_2.359331_g2497_i0	PRJNA915212	2533	408	2.359331	9.62607048	Blastococcus saxobsidens	138336	Bacteria	Bacteria	75	8.36e-9	NTclustered	gi\|378781357\|emb\|FO117623.1\|	1146883	g2497	i0	92.308	0.379901960784314	52	4	13	0	73	124	4765870	4765921	Blastococcus saxobsidens DD2 complete genome	blastn	155	75	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
16553529	16553529	PRJNA915212_P_NODE_3193_length_354_cov_2.003279_g3156_i0	PRJNA915212	3193	354	2.003279	7.09160766	Actinomycetes	1760	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|610391492\|gb\|CP006842.1\|	1404245	g3156	i0	96.875	0.172316384180791	32	1	9	0	88	119	1711868	1711837	Corynebacterium glyciniphilum AJ 3170, complete genome	blastn	61	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glyciniphilum
17828551	17828551	PRJNA915212_P_NODE_12174_length_166_cov_1.179487_g12136_i0	PRJNA915212	12174	166	1.179487	1.95794842	Mycobacteriaceae	1762	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g12136	i0	100	112.530120481928	166	0	100	0	1	166	1312468	1312303	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	18680	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum

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