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

13 rows where analysis = "blastn", bioproject = "PRJEB43370" 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
2610161	2610161	PRJEB43370_P_NODE_7643_length_169_cov_0.866667_g7600_i0	PRJEB43370	7643	169	0.866667	1.46466723	Actinomyces qiguomingii	2057800	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1560770216\|gb\|CP025228.1\|	2057800	g7600	i0	90	23.0532544378698	90	9	53	0	71	160	2813612	2813701	Actinomyces qiguomingii strain 410 chromosome, complete genome	blastn	3896	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces qiguomingii
3540446	3540446	PRJEB43370_P_NODE_1883_length_316_cov_1.625468_g1840_i0	PRJEB43370	1883	316	1.625468	5.13647888	Mycobacteriaceae	1762	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1806304829\|dbj\|AP022581.1\|	169765	g1840	i0	96.97	3.15189873417722	33	1	10	0	254	286	27572	27540	Mycobacterium lacus JCM 15657 DNA, complete genome	blastn	996	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium lacus
3886359	3886359	PRJEB43370_P_NODE_9264_length_165_cov_0.896552_g9221_i0	PRJEB43370	9264	165	0.896552	1.4793108	Streptomyces sp. NBC_00448	2903652	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2658430807\|gb\|CP107913.1\|	2903652	g9221	i0	100	0.16969696969697	28	0	17	0	30	57	8489766	8489793	Streptomyces sp. NBC_00448 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00448
6093064	6093064	PRJEB43370_P_NODE_6465_length_180_cov_1.786260_g6422_i0	PRJEB43370	6465	180	1.78626	3.215268	Mycobacteriaceae	1762	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|1806225195\|dbj\|AP022563.1\|	39688	g6422	i0	100	129.927777777778	171	0	95	0	10	180	1558638	1558468	Mycolicibacterium duvalii JCM 6396 DNA, complete genome	blastn	23387	316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium duvalii
6093069	6093069	PRJEB43370_P_NODE_9305_length_165_cov_0.896552_g9262_i0	PRJEB43370	9305	165	0.896552	1.4793108	Nocardiopsis	2013	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|1540223313\|emb\|LR134501.1\|	2014	g9262	i0	97.143	1.83636363636364	35	1	21	0	20	54	3001746	3001780	Nocardiopsis dassonvillei strain NCTC10488 genome assembly, chromosome: 1	blastn	303	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis dassonvillei
11193296	11193296	PRJEB43370_P_NODE_10809_length_162_cov_0.920354_g10766_i0	PRJEB43370	10809	162	0.920354	1.49097348	Streptomyces	1883	Bacteria	Bacteria	139	1.01e-28	NTclustered	gi\|1863100227\|gb\|CP056041.1\|	1969	g10766	i0	87.603	35.1296296296296	121	13	74	2	43	162	10896460	10896341	Streptomyces chartreusis strain NA02069 chromosome, complete genome	blastn	5691	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces chartreusis
11193310	11193310	PRJEB43370_P_NODE_9429_length_165_cov_0.896552_g9386_i0	PRJEB43370	9429	165	0.896552	1.4793108	Streptomyces	1883	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1688905926\|gb\|CP040467.1\|	1886	g9386	i0	100	0.509090909090909	28	0	17	0	94	121	25820	25847	Streptomyces albidoflavus strain UYFA156 plasmid unnamed, complete sequence	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
12469015	12469015	PRJEB43370_P_NODE_8870_length_166_cov_0.888889_g8827_i0	PRJEB43370	8870	166	0.888889	1.47555574	Winkia	2692118	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2435992455\|gb\|CP116394.1\|	29318	g8827	i0	100	4	166	0	100	0	1	166	200931	201096	Winkia neuii subsp. anitrata strain NY0527 chromosome, complete genome	blastn	664	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Winkia	Winkia neuii
13743405	13743405	PRJEB43370_P_NODE_11071_length_159_cov_2.836364_g11028_i0	PRJEB43370	11071	159	2.836364	4.50981876	Mycobacteriaceae	1762	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1806215240\|dbj\|AP022561.1\|	1799	g11028	i0	100	168.918238993711	159	0	100	0	1	159	3182899	3182741	Mycolicibacterium aichiense JCM 6376 DNA, complete genome	blastn	26858	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aichiense
17567755	17567755	PRJEB43370_P_NODE_9394_length_165_cov_0.896552_g9351_i0	PRJEB43370	9394	165	0.896552	1.4793108	Actinomycetes	1760	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1907669513\|gb\|CP031142.1\|	333966	g9351	i0	77.711	49.5818181818182	166	30	98	5	5	165	7301066	7301229	Saccharopolyspora pogona strain NRRL30141 chromosome, complete genome	blastn	8181	95.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora pogona
20461075	20461075	PRJEB43370_P_NODE_8657_length_167_cov_0.881356_g8614_i0	PRJEB43370	8657	167	0.881356	1.47186452	Janibacter terrae	103817	Bacteria	Bacteria	243	7.739999999999999e-60	NTclustered	gi\|2732501705\|gb\|CP144167.1\|	103817	g8614	i0	92.857	192.760479041916	168	11	100	1	1	167	2460941	2461108	Janibacter terrae strain Sec5.9 chromosome, complete genome	blastn	32191	243	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter terrae
21392020	21392020	PRJEB43370_P_NODE_3917_length_224_cov_1.011429_g3874_i0	PRJEB43370	3917	224	1.011429	2.26560096	Bacteria	2	Bacteria	Bacteria	82.4	2.54e-11	NTclustered	gi\|2285394500\|gb\|CP097984.1\|	2045	g3874	i0	77.273	26.1741071428571	154	26	69	9	10	163	3701549	3701405	Pimelobacter simplex strain N39 chromosome, complete genome	blastn	5863	82.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Pimelobacter	Pimelobacter simplex
23012126	23012126	PRJEB43370_P_NODE_10019_length_164_cov_0.904348_g9976_i0	PRJEB43370	10019	164	0.904348	1.48313072	Mycolicibacterium rufum	318424	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2294186521\|gb\|CP092427.2\|	318424	g9976	i0	98.78	166.536585365854	164	2	100	0	1	164	209585	209422	Mycolicibacterium rufum strain JCM 16372 chromosome, complete genome	blastn	27312	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rufum

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