metadata: contig_metadata: 22 rows where bioproject = "PRJEB65329" and tax

22 rows where bioproject = "PRJEB65329" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2269156	2269156	PRJEB65329_S_NODE_8962_length_235_cov_3.383495_g8800_i0	PRJEB65329	8962	235	3.383495	7.95121325	Streptomycetaceae	2062	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1399240079\|gb\|CP029788.1\|	1885	g8800	i0	100	4.40851063829787	28	0	12	0	70	97	5092073	5092046	Streptomyces actuosus strain ATCC 25421 chromosome, complete genome	blastn	1036	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces actuosus
4821986	4821986	PRJEB65329_S_NODE_9604_length_224_cov_5.876923_g9442_i0	PRJEB65329	9604	224	5.876923	13.16430752	Corynebacterium	1716	Bacteria	Bacteria	364	2.2499999999999993e-96	NTclustered	gi\|2443264930\|gb\|CP063195.1\|	38289	g9442	i0	95.982	431.620535714286	224	9	100	0	1	224	110827	111050	Corynebacterium jeikeium strain DSM 7171 chromosome, complete genome	blastn	96683	364	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium jeikeium
5232609	5232609	PRJEB65329_S_NODE_16845_length_158_cov_2.689922_g16683_i0	PRJEB65329	16845	158	2.689922	4.25007676	Protaetiibacter larvae	2592654	Bacteria	Bacteria	122	9.809999999999999e-24	NTclustered	gi\|1736209585\|gb\|CP043504.1\|	2592654	g16683	i0	84.553	68.2025316455696	123	19	78	0	28	150	544062	543940	Protaetiibacter larvae strain KACC 19322 chromosome, complete genome	blastn	10776	122	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Protaetiibacter	Protaetiibacter larvae
6097075	6097075	PRJEB65329_S_NODE_17805_length_153_cov_4.733871_g17643_i0	PRJEB65329	17805	153	4.733871	7.24282263	root	1	Root_unresolved	Root_unresolved	283	4.0799999999999995e-72	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g17643	i0	100	55.5751633986928	153	0	100	0	1	153	2681137	2681289	Staphylococcus aureus strain WH3018 chromosome	blastn	8503	283	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8647006	8647006	PRJEB65329_S_NODE_4767_length_383_cov_7.228814_g4605_i0	PRJEB65329	4767	383	7.228814	27.68635762	Cutibacterium	1912216	Bacteria	Bacteria	520	8.33e-143	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4605	i0	96.519	212.997389033943	316	7	82	4	1	314	55360	55673	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	81578	520	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10333106	10333106	PRJEB65329_S_NODE_17729_length_154_cov_2.072000_g17567_i0	PRJEB65329	17729	154	2.072	3.19088	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2209700036\|dbj\|AP025668.1\|	1912	g17567	i0	100	0.181818181818182	28	0	18	0	120	147	5180060	5180033	Streptomyces hygroscopicus HOK021 DNA, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus
11197244	11197244	PRJEB65329_S_NODE_1849_length_740_cov_5.890295_g536_i2	PRJEB65329	1849	740	5.890295	43.588183	Cutibacterium	1912216	Bacteria	Bacteria	1245	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g536	i2	97.027	281.868918918919	740	22	100	0	1	740	608304	609043	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	208583	1245	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11197265	11197265	PRJEB65329_S_NODE_569_length_1251_cov_6.440262_g536_i0	PRJEB65329	569	1251	6.440262	80.56767762	Cutibacterium	1912216	Bacteria	Bacteria	2296	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g536	i0	99.84	276.338129496403	1249	2	99	0	1	1249	609043	607795	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	345699	2296	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13747367	13747367	PRJEB65329_S_NODE_811_length_1082_cov_6.650522_g536_i1	PRJEB65329	811	1082	6.650522	71.95864804	Cutibacterium	1912216	Bacteria	Bacteria	1840	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g536	i1	97.415	277.462107208872	1083	22	99	6	1	1081	57410	56332	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	300214	1840	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14158447	14158447	PRJEB65329_S_NODE_14772_length_170_cov_4.787234_g14610_i0	PRJEB65329	14772	170	4.787234	8.1382978	Actinomadura madurae	1993	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2893341638\|gb\|CP083237.1\|	1993	g14610	i0	96.97	0.547058823529412	33	1	19	0	1	33	9641251	9641219	Actinomadura madurae strain ATCC 19425 chromosome, complete genome	blastn	93	56.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura madurae
15432637	15432637	PRJEB65329_S_NODE_7133_length_276_cov_4.562753_g6971_i0	PRJEB65329	7133	276	4.562753	12.59319828	root	1	Root_unresolved	Root_unresolved	174	1.16e-52	NR	WP_321130271.1	1496	g6971	i0	92.4	2	92	7	100	0	276	1	99	190	WP_321130271.1 GTP-binding protein, partial [Clostridioides difficile]	diamond	552	174	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
17571766	17571766	PRJEB65329_S_NODE_12554_length_188_cov_8.930818_g12392_i0	PRJEB65329	12554	188	8.930818	16.78993784	Corynebacterium	1716	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2182362215\|gb\|CP040520.1\|	1717	g12392	i0	100	125	188	0	100	0	1	188	2405045	2404858	Corynebacterium diphtheriae strain CD1040 chromosome, complete genome	blastn	23500	348	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
17981828	17981828	PRJEB65329_S_NODE_9055_length_233_cov_8.794118_g8893_i0	PRJEB65329	9055	233	8.794118	20.49029494	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|407954676\|dbj\|AB587853.1\|	159447	g8893	i0	100	100	233	0	100	0	1	233	305	73	Uncultured Corynebacterium sp. gene for 16S ribosomal RNA, partial sequence, clone: PT-E1	blastn	23300	431	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
20120487	20120487	PRJEB65329_S_NODE_6796_length_286_cov_3.587549_g6634_i0	PRJEB65329	6796	286	3.587549	10.26039014	Corynebacterium	1716	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|2443264930\|gb\|CP063195.1\|	38289	g6634	i0	97.902	435.636363636364	286	6	100	0	1	286	110192	110477	Corynebacterium jeikeium strain DSM 7171 chromosome, complete genome	blastn	124592	496	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium jeikeium
23946356	23946356	PRJEB65329_S_NODE_5559_length_336_cov_3.726384_g5397_i0	PRJEB65329	5559	336	3.726384	12.52065024	Cutibacterium	1912216	Bacteria	Bacteria	475	1.5899999999999995e-129	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g5397	i0	92.492	318.03869047619	333	23	99	2	1	331	609043	608711	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	106861	475	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25220019	25220019	PRJEB65329_S_NODE_17240_length_156_cov_2.700787_g17078_i0	PRJEB65329	17240	156	2.700787	4.21322772	Streptomyces	1883	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2655774549\|gb\|CP109243.1\|	1886	g17078	i0	100	10.0384615384615	29	0	19	0	74	102	5996893	5996921	Streptomyces albidoflavus strain NBC 01661 chromosome, complete genome	blastn	1566	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
27058514	27058514	PRJEB65329_S_NODE_18302_length_151_cov_2.934426_g18140_i0	PRJEB65329	18302	151	2.934426	4.43098326	root	1	Root_unresolved	Root_unresolved	90.1	8.480000000000001e-21	NR	MCJ0157548.1	1496	g18140	i0	76	13.8675496688742	50	12	99.3	0	150	1	99	148	MCJ0157548.1 40S ribosomal protein S3a/S1 [Clostridioides difficile]	diamond	2094	90.9	0.991199119911991	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
27508117	27508117	PRJEB65329_S_NODE_17743_length_154_cov_2.016000_g17581_i0	PRJEB65329	17743	154	2.016	3.10464	Cyanobium sp. ELA507	3064509	Bacteria	Bacteria	38.5	0.0448	NR	MEI6617027.1	3064509	g17581	i0	50	0.701298701298701	36	15	64.3	1	123	25	1	36	MEI6617027.1 MBL fold metallo-hydrolase [Cyanobium sp. ELA507]	diamond	108	38.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ELA507
28613012	28613012	PRJEB65329_S_NODE_13247_length_182_cov_2.784314_g13085_i0	PRJEB65329	13247	182	2.784314	5.06745148	Thermogemmatispora sp.	1968838	Bacteria	Bacteria	41.6	0.0419	NR	WP_376797019.1	1968838	g13085	i0	38.2	0.906593406593407	55	18	87.4	2	24	182	82	122	WP_376797019.1 zinc-binding alcohol dehydrogenase family protein [Thermogemmatispora sp.]	diamond	165	41.6	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Thermogemmatisporales	Thermogemmatisporaceae	Thermogemmatispora	Thermogemmatispora sp.
29654525	29654525	PRJEB65329_S_NODE_12650_length_188_cov_1.886792_g12488_i0	PRJEB65329	12650	188	1.886792	3.54716896	Streptomyces caniscabiei	2746961	Bacteria	Bacteria	41.2	0.0372	NR	WP_319106296.1	2746961	g12488	i0	47.2	0.574468085106383	36	19	57.4	0	171	64	37	72	WP_319106296.1 peptidase inhibitor family I36 protein [Streptomyces caniscabiei]	diamond	108	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces caniscabiei
30855383	30855383	PRJEB65329_S_NODE_9034_length_234_cov_2.702439_g8872_i0	PRJEB65329	9034	234	2.702439	6.32370726	Streptomyces sp. KM77-8	3074435	Bacteria	Bacteria	44.3	0.00927	NR	BFO18157.1	3074435	g8872	i0	40	0.897435897435897	70	39	89.7	1	211	2	421	487	BFO18157.1 hypothetical protein SHKM778_45450 [Streptomyces sp. KM77-8]	diamond	210	44.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces haneummycinicus
32846572	32846572	PRJEB65329_S_NODE_12060_length_193_cov_4.310976_g11898_i0	PRJEB65329	12060	193	4.310976	8.32018368	Paenibacillus woosongensis	307580	Bacteria	Bacteria	40	0.0299	NR	WP_306422036.1	307580	g11898	i0	44.2	0.808290155440414	52	26	77.7	2	26	175	1	51	WP_306422036.1 hypothetical protein [Paenibacillus woosongensis]	diamond	156	40	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus woosongensis

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