metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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
1045797	1045797	PRJNA1215813_P_NODE_2141_length_507_cov_2.836406_g2061_i0	PRJNA1215813	2141	507	2.836406	14.38057842	Nocardiaceae	85025	Bacteria	Bacteria	937	0	NTclustered	gi\|2589057681\|gb\|CP135915.1\|	293050	g2061	i0	100	392.483234714004	507	0	100	0	1	507	436172	436678	Rhodococcoides kroppenstedtii strain K07-23T chromosome, complete genome	blastn	198989	937	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides kroppenstedtii
2321142	2321142	PRJNA1215813_P_NODE_10902_length_248_cov_0.891429_g10822_i0	PRJNA1215813	10902	248	0.891429	2.21074392	Cellulomonas	1707	Bacteria	Bacteria	80.5	1.03e-10	NTclustered	gi\|1540063786\|emb\|LR134387.1\|	1708	g10822	i0	87.143	7.20161290322581	70	9	28	0	171	240	1562157	1562226	Cellulomonas fimi strain NCTC7547 genome assembly, chromosome: 1	blastn	1786	80.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas fimi
2882713	2882713	PRJNA1215813_P_NODE_5643_length_327_cov_1.228346_g5563_i0	PRJNA1215813	5643	327	1.228346	4.01669142	Lentzea guizhouensis	1586287	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1050298341\|gb\|CP016793.1\|	1586287	g5563	i0	92.105	0.201834862385321	38	3	12	0	38	75	7713625	7713588	Lentzea guizhouensis strain DHS C013 chromosome, complete genome	blastn	66	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Lentzea	Lentzea guizhouensis
4158755	4158755	PRJNA1215813_P_NODE_2704_length_459_cov_1.098446_g2624_i0	PRJNA1215813	2704	459	1.098446	5.04186714	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	60.2	2.66e-4	NTclustered	gi\|2893356068\|emb\|OZ220491.1\|	2201156	g2624	i0	97.143	0.137254901960784	35	1	8	0	215	249	2527342	2527376	MAG: Acidimicrobiales bacterium isolate 383ba79e-94a5-4396-b72d-754c03a60d81 genome assembly, chromosome: 1	blastn	63	60.2	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
7985103	7985103	PRJNA1215813_P_NODE_12027_length_244_cov_0.912281_g11947_i0	PRJNA1215813	12027	244	0.912281	2.22596564	Lentzea sp. JNUCC 0626	3367513	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2837414742\|gb\|CP171635.1\|	3367513	g11947	i0	100	0.241803278688525	31	0	13	0	144	174	6040136	6040106	Lentzea sp. JNUCC 0626 strain JNUCC chromosome, complete genome	blastn	59	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Lentzea	Lentzea sp. JNUCC 0626
10535534	10535534	PRJNA1215813_P_NODE_10429_length_249_cov_0.886364_g10349_i0	PRJNA1215813	10429	249	0.886364	2.20704636	Streptomyces sp. NBC_00582	2975783	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|2667469075\|gb\|CP107772.1\|	2975783	g10349	i0	80.8	76.8714859437751	250	46	100	2	1	249	6486101	6485853	Streptomyces sp. NBC_00582 chromosome, complete genome	blastn	19141	195	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00582
11810375	11810375	PRJNA1215813_P_NODE_11890_length_244_cov_0.912281_g11810_i0	PRJNA1215813	11890	244	0.912281	2.22596564	Streptomyces sp. Je 1-369	2966192	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2410828879\|gb\|CP101750.1\|	2966192	g11810	i0	100	0.114754098360656	28	0	11	0	162	189	2438542	2438515	Streptomyces sp. Je 1-369 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Je 1-369
15073430	15073430	PRJNA1215813_P_NODE_7412_length_288_cov_1.451163_g7332_i0	PRJNA1215813	7412	288	1.451163	4.17934944	Nocardiaceae	85025	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2589057681\|gb\|CP135915.1\|	293050	g7332	i0	100	398.6875	288	0	100	0	1	288	435542	435829	Rhodococcoides kroppenstedtii strain K07-23T chromosome, complete genome	blastn	114822	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides kroppenstedtii
18897336	18897336	PRJNA1215813_P_NODE_7895_length_279_cov_3.053398_g7815_i0	PRJNA1215813	7895	279	3.053398	8.51898042	Streptomyces	1883	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2028478505\|gb\|CP073042.1\|	371608	g7815	i0	100	0.211469534050179	28	0	10	0	78	105	4017220	4017247	Streptomyces philanthi bv. triangulum 23Af2, complete genome sequence	blastn	59	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Candidatus Streptomyces philanthi
19457725	19457725	PRJNA1215813_P_NODE_11216_length_247_cov_0.896552_g11136_i0	PRJNA1215813	11216	247	0.896552	2.21448344	Streptacidiphilus sp. P02-A3a	2704468	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1886153837\|gb\|CP048289.1\|	2704468	g11136	i0	96.774	0.125506072874494	31	1	13	0	135	165	8541783	8541753	Streptacidiphilus sp. P02-A3a chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptacidiphilus	Streptacidiphilus sp. P02-A3a
20733148	20733148	PRJNA1215813_P_NODE_12057_length_243_cov_1.823529_g11977_i0	PRJNA1215813	12057	243	1.823529	4.43117547	uncultured Thermoleophilaceae bacterium	349283	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253973\|emb\|OY970298.1\|	349283	g11977	i0	100	0.11522633744856	28	0	12	0	178	205	915212	915239	MAG: uncultured Thermoleophilaceae bacterium isolate MFD04935.bin.1.10 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales	Thermoleophilaceae		uncultured Thermoleophilaceae bacterium
22008385	22008385	PRJNA1215813_P_NODE_11018_length_247_cov_0.896552_g10938_i0	PRJNA1215813	11018	247	0.896552	2.21448344	Arthrobacter sp. NicSoilC5	2831000	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2089593438\|dbj\|AP024660.1\|	2831000	g10938	i0	94.118	0.137651821862348	34	2	14	0	76	109	1894775	1894742	Arthrobacter sp. NicSoilC5 DNA, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. NicSoilC5
24557868	24557868	PRJNA1215813_P_NODE_1000_length_719_cov_4.168731_g927_i0	PRJNA1215813	1000	719	4.168731	29.97317589	Clavibacter seminis	2860285	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2187984480\|gb\|CP083439.1\|	2860285	g927	i0	100	0.0848400556328234	31	0	4	0	571	601	2714627	2714657	Clavibacter sp. A6099 chromosome, complete genome	blastn	61	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter seminis

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