metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA698538" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA698538" 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
681512	681512	PRJNA698538_S_NODE_26121_length_253_cov_2.994444_g25955_i0	PRJNA698538	26121	253	2.994444	7.57594332	Actinomycetospora sp. NBC_00405	2975952	Bacteria	Bacteria	307	4.44e-79	NTclustered	gi\|2658591327\|gb\|CP107938.1\|	2975952	g25955	i0	88.538	62.5691699604743	253	29	100	0	1	253	1350259	1350511	Actinomycetospora sp. NBC_00405 chromosome, complete genome	blastn	15830	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinomycetospora	Actinomycetospora sp. NBC_00405
4509263	4509263	PRJNA698538_S_NODE_12364_length_330_cov_4.400778_g12198_i0	PRJNA698538	12364	330	4.400778	14.5225674	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	577	4.15e-160	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g12198	i0	98.182	346.987878787879	330	6	100	0	1	330	553488	553159	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	114506	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
5012336	5012336	PRJNA698538_S_NODE_17824_length_295_cov_3.918919_g17658_i0	PRJNA698538	17824	295	3.918919	11.56081105	Corynebacterium	1716	Bacteria	Bacteria	534	2.23e-147	NTclustered	gi\|507148198\|ref\|NR_103005.1\|	1727	g17658	i0	99.324	367.898305084746	296	1	100	1	1	295	527	232	Corynebacterium variabile strain DSM 44702 23S ribosomal RNA gene, complete sequence	blastn	108530	534	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium variabile
5012372	5012372	PRJNA698538_S_NODE_8864_length_360_cov_2.222997_g8698_i0	PRJNA698538	8864	360	2.222997	8.0027892	Microbacterium	33882	Bacteria	Bacteria	643	4.429999999999998e-180	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g8698	i0	98.889	172	360	4	100	0	1	360	230625	230984	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	61920	643	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
9609864	9609864	PRJNA698538_S_NODE_24848_length_259_cov_1.795699_g24682_i0	PRJNA698538	24848	259	1.795699	4.65086041	Neoactinobaculum massilliense	2364794	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2363082511\|ref\|NR_179502.1\|	2364794	g24682	i0	100	111.397683397683	259	0	100	0	1	259	1420	1162	Neoactinobaculum massilliense strain Marseille-P6182 16S ribosomal RNA, partial sequence	blastn	28852	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Neoactinobaculum	Neoactinobaculum massilliense
9609953	9609953	PRJNA698538_S_NODE_30568_length_237_cov_2.304878_g30402_i0	PRJNA698538	30568	237	2.304878	5.46256086	Corynebacterium macginleyi	38290	Bacteria	Bacteria	424	3.91e-114	NTclustered	gi\|1980278327\|gb\|CP068292.1\|	38290	g30402	i0	98.745	363.658227848101	239	1	100	2	1	237	1287242	1287004	Corynebacterium macginleyi strain 160811 chromosome, complete genome	blastn	86187	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium macginleyi
10112678	10112678	PRJNA698538_S_NODE_31628_length_226_cov_3.921569_g31462_i0	PRJNA698538	31628	226	3.921569	8.86274594	Micrococcus	1269	Bacteria	Bacteria	412	8.01e-111	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g31462	i0	99.558	344.787610619469	226	1	100	0	1	226	346132	346357	Micrococcus luteus strain V017 chromosome, complete genome	blastn	77922	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
10885517	10885517	PRJNA698538_S_NODE_26129_length_253_cov_2.844444_g25963_i0	PRJNA698538	26129	253	2.844444	7.19644332	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	451	1.94e-122	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g25963	i0	98.814	460.150197628458	253	3	100	0	1	253	553461	553209	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	116418	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
11387625	11387625	PRJNA698538_S_NODE_19389_length_286_cov_4.211268_g19223_i0	PRJNA698538	19389	286	4.211268	12.04422648	Cutibacterium	1912216	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g19223	i0	100	55.2937062937063	286	0	100	0	1	286	2511690	2511405	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15814	529	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12663550	12663550	PRJNA698538_S_NODE_150_length_1299_cov_15.435563_g80_i0	PRJNA698538	150	1299	15.435563	200.50796337	Cutibacterium	1912216	Bacteria	Bacteria	2316	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g80	i0	99.92	246.390300230947	1257	1	98	0	21	1277	55349	56605	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	320061	2316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12663553	12663553	PRJNA698538_S_NODE_17590_length_297_cov_1.718750_g17424_i0	PRJNA698538	17590	297	1.71875	5.1046875	Cutibacterium	1912216	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g17424	i0	100	51.03367003367	297	0	100	0	1	297	1350667	1350963	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	15157	549	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13435075	13435075	PRJNA698538_S_NODE_12131_length_332_cov_3.343629_g11965_i0	PRJNA698538	12131	332	3.343629	11.10084828	Microbacterium sp. RG1	2489212	Bacteria	Bacteria	86.1	3.08e-12	NTclustered	gi\|1646963381\|gb\|CP034121.1\|	2489212	g11965	i0	90.769	13.7620481927711	65	4	20	2	1	65	1675576	1675638	Microbacterium sp. RG1 chromosome, complete genome	blastn	4569	86.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. RG1
13435137	13435137	PRJNA698538_S_NODE_16651_length_302_cov_5.043668_g16485_i0	PRJNA698538	16651	302	5.043668	15.23187736	Nocardioides sp. NBC_00850	2976001	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2655527585\|gb\|CP108845.1\|	2976001	g16485	i0	100	0.0927152317880795	28	0	9	0	171	198	3242163	3242136	Nocardioides sp. NBC_00850 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. NBC_00850
13938001	13938001	PRJNA698538_S_NODE_23791_length_264_cov_1.785340_g23625_i0	PRJNA698538	23791	264	1.78534	4.7132976	Cutibacterium	1912216	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g23625	i0	100	49.3295454545455	264	0	100	0	1	264	1642542	1642279	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13023	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17259283	17259283	PRJNA698538_S_NODE_23934_length_263_cov_2.836842_g23768_i0	PRJNA698538	23934	263	2.836842	7.46089446	Kocuria palustris	71999	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g23768	i0	99.62	258.665399239544	263	1	100	0	1	263	218746	218484	Kocuria palustris strain MU14/1, complete genome	blastn	68029	481	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
20310376	20310376	PRJNA698538_S_NODE_10556_length_345_cov_0.875000_g10390_i0	PRJNA698538	10556	345	0.875	3.01875	Cutibacterium	1912216	Bacteria	Bacteria	638	1.97e-178	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10390	i0	100	60.0289855072464	345	0	100	0	1	345	2552978	2552634	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	20710	638	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21083933	21083933	PRJNA698538_S_NODE_4437_length_424_cov_1.410256_g4271_i0	PRJNA698538	4437	424	1.410256	5.97948544	Streptomyces vietnamensis	362257	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|751387084\|gb\|CP010407.1\|	362257	g4271	i0	100	0.0660377358490566	28	0	7	0	40	67	997583	997610	Streptomyces vietnamensis strain GIM4.0001, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces vietnamensis
21586329	21586329	PRJNA698538_S_NODE_6037_length_394_cov_2.457944_g5871_i0	PRJNA698538	6037	394	2.457944	9.68429936	Cutibacterium	1912216	Bacteria	Bacteria	667	0	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g5871	i0	100	82.1167512690355	361	0	92	0	34	394	2130915	2130555	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	32354	667	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22861575	22861575	PRJNA698538_S_NODE_8178_length_367_cov_3.115646_g8012_i0	PRJNA698538	8178	367	3.115646	11.43442082	Cutibacterium	1912216	Bacteria	Bacteria	673	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8012	i0	99.728	51.0108991825613	367	1	100	0	1	367	896950	897316	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	18721	673	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23634559	23634559	PRJNA698538_S_NODE_999_length_650_cov_5.755633_g843_i0	PRJNA698538	999	650	5.7556330000000004	37.4116145	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	1162	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g843	i0	98.923	363.069230769231	650	7	100	0	1	650	553189	552540	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	235995	1162	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
24135779	24135779	PRJNA698538_S_NODE_13239_length_324_cov_2.844622_g13073_i0	PRJNA698538	13239	324	2.844622	9.21657528	Cutibacterium	1912216	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g13073	i0	100	31.7098765432099	324	0	100	0	1	324	421358	421681	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	10274	599	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24907713	24907713	PRJNA698538_S_NODE_22940_length_268_cov_2.682051_g22774_i0	PRJNA698538	22940	268	2.682051	7.18789668	Mycobacterium branderi	43348	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1806425038\|dbj\|AP022607.1\|	43348	g22774	i0	100	0.104477611940299	28	0	10	0	212	239	311638	311611	Mycobacterium branderi JCM 12687 plasmid pJCM12687 DNA, nearly complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium branderi

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