metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA512103" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA512103" 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
486194	486194	PRJNA512103_P_NODE_31741_length_167_cov_0.881356_g31329_i0	PRJNA512103	31741	167	0.881356	1.47186452	Micrococcus luteus	1270	Bacteria	Bacteria	278	2.12e-70	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g31329	i0	100	18.502994011976	150	0	90	0	10	159	902916	903065	Micrococcus luteus strain ML chromosome, complete genome	blastn	3090	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
486231	486231	PRJNA512103_P_NODE_32941_length_165_cov_0.896552_g32529_i0	PRJNA512103	32941	165	0.896552	1.4793108	Gordonia sp. 135	2676309	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|1779023796\|gb\|CP046257.1\|	2676309	g32529	i0	98.529	94.0242424242424	136	0	82	2	21	156	4580504	4580637	Gordonia sp. 135 chromosome, complete genome	blastn	15514	239	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia sp. 135
1761069	1761069	PRJNA512103_P_NODE_21102_length_208_cov_0.867925_g20690_i0	PRJNA512103	21102	208	0.867925	1.8052840000000001	Gordonia sp. MP11Mi	3022769	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2592691643\|gb\|CP128986.1\|	3022769	g20690	i0	96.875	0.153846153846154	32	1	15	0	123	154	1291122	1291153	Gordonia sp. MP11Mi chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia sp. MP11Mi
5589608	5589608	PRJNA512103_P_NODE_20545_length_211_cov_1.024691_g20133_i0	PRJNA512103	20545	211	1.024691	2.16209801	Brevibacterium sp. BRM-1	2999062	Bacteria	Bacteria	294	2.79e-75	NTclustered	gi\|2407432046\|gb\|CP113788.1\|	2999062	g20133	i0	94.301	222.265402843602	193	9	91	2	10	202	1090972	1090782	Brevibacterium sp. BRM-1 chromosome, complete genome	blastn	46898	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium sp. BRM-1
7488944	7488944	PRJNA512103_P_NODE_32926_length_165_cov_0.896552_g32514_i0	PRJNA512103	32926	165	0.896552	1.4793108	Actinomycetota	201174	Bacteria	Bacteria	110	8.07e-20	NTclustered	gi\|1865334670\|gb\|CP058322.1\|	47853	g32514	i0	80.822	72.230303030303	146	22	87	5	10	152	3450549	3450691	Micromonospora carbonacea strain aurantiaca chromosome, complete genome	blastn	11918	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora carbonacea
8763856	8763856	PRJNA512103_P_NODE_21907_length_203_cov_0.954545_g21495_i0	PRJNA512103	21907	203	0.954545	1.93772635	Corynebacterium	1716	Bacteria	Bacteria	342	9.369999999999999e-90	NTclustered	gi\|1954924873\|gb\|CP067012.1\|	1979527	g21495	i0	100	345.07881773399	185	0	91	0	10	194	597848	598032	Corynebacterium kefirresidentii strain FDAARGOS_1055 chromosome, complete genome	blastn	70051	342	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
10039392	10039392	PRJNA512103_P_NODE_18108_length_230_cov_1.016575_g17696_i0	PRJNA512103	18108	230	1.016575	2.3381225	Micrococcus	1269	Bacteria	Bacteria	387	4.96e-103	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g17696	i0	99.07	263.108695652174	215	2	93	0	16	230	2260514	2260728	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	60515	387	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11964511	11964511	PRJNA512103_P_NODE_19530_length_218_cov_1.224852_g19118_i0	PRJNA512103	19530	218	1.224852	2.67017736	Actinokineospora sp. UTMC 2448	2268449	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2290867056\|gb\|CP031087.1\|	2268449	g19118	i0	100	0.334862385321101	29	0	13	0	78	106	5593237	5593209	Actinokineospora sp. UTMC 2448 chromosome, complete genome	blastn	73	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora sp. UTMC 2448
11964646	11964646	PRJNA512103_P_NODE_23030_length_197_cov_1.114865_g22618_i0	PRJNA512103	23030	197	1.114865	2.19628405	Rothia mucilaginosa	43675	Bacteria	Bacteria	344	2.51e-90	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g22618	i0	99.471	295.543147208122	189	1	96	0	1	189	1093748	1093560	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	58222	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
12589816	12589816	PRJNA512103_P_NODE_8330_length_438_cov_2.128535_g7919_i0	PRJNA512103	8330	438	2.128535	9.3229833	Brachybacterium	43668	Bacteria	Bacteria	573	7.309999999999997e-159	NTclustered	gi\|1654137461\|gb\|CP027295.1\|	2571029	g7919	i0	90.455	247.869863013699	440	35	99	6	1	436	5712	6148	Brachybacterium sp. SGAir0954 chromosome, complete genome	blastn	108567	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. SGAir0954
13864638	13864638	PRJNA512103_P_NODE_29391_length_172_cov_1.617886_g28979_i0	PRJNA512103	29391	172	1.617886	2.78276392	Rhodococcus	1827	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g28979	i0	100	45.3372093023256	154	0	90	0	10	163	2878167	2878320	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	7798	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
15138922	15138922	PRJNA512103_P_NODE_9452_length_394_cov_1.530435_g9040_i0	PRJNA512103	9452	394	1.530435	6.0299139	Micrococcus	1269	Bacteria	Bacteria	728	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g9040	i0	100	239.616751269036	394	0	100	0	1	394	403269	402876	Micrococcus luteus strain ML chromosome, complete genome	blastn	94409	728	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15788165	15788165	PRJNA512103_P_NODE_11493_length_335_cov_1.234266_g11081_i0	PRJNA512103	11493	335	1.234266	4.1347911	Corynebacterium anserum	2684406	Bacteria	Bacteria	383	9.86e-102	NTclustered	gi\|1894829214\|gb\|CP046883.1\|	2684406	g11081	i0	93.462	308.597014925373	260	13	77	2	77	333	115053	115311	Corynebacterium anserum strain 23H37-10 chromosome, complete genome	blastn	103380	383	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium anserum
20237286	20237286	PRJNA512103_P_NODE_16736_length_243_cov_0.958763_g16324_i0	PRJNA512103	16736	243	0.958763	2.32979409	Micrococcus	1269	Bacteria	Bacteria	431	2.4099999999999995e-116	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g16324	i0	99.163	356.958847736626	239	2	98	0	5	243	346129	346367	Micrococcus luteus strain V017 chromosome, complete genome	blastn	86741	431	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20888112	20888112	PRJNA512103_P_NODE_26197_length_184_cov_0.903704_g25785_i0	PRJNA512103	26197	184	0.903704	1.66281536	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	315	1.81e-81	NTclustered	gi\|2874253711\|emb\|OY969553.1\|	3039803	g25785	i0	98.864	512.934782608696	176	2	96	0	9	184	463098	463273	MAG: uncultured Actinomycetota bacterium isolate MFD04212.bin.1.1 genome assembly, chromosome: 1	blastn	94380	315	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
22787894	22787894	PRJNA512103_P_NODE_15238_length_262_cov_1.164319_g14826_i0	PRJNA512103	15238	262	1.164319	3.05051578	Brachybacterium	43668	Bacteria	Bacteria	457	4.34e-124	NTclustered	gi\|1442783620\|gb\|CP031356.1\|	556288	g14826	i0	99.209	265.370229007634	253	2	97	0	10	262	909190	909442	Brachybacterium saurashtrense strain DSM 23186 chromosome, complete genome	blastn	69527	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium saurashtrense

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