metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1074408" 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
1016442	1016442	PRJNA1074408_S_NODE_1201_length_410_cov_2.245232_g1071_i0	PRJNA1074408	1201	410	2.245232	9.2054512	Microbacterium	33882	Bacteria	Bacteria	555	2.4599999999999995e-153	NTclustered	gi\|2530242188\|gb\|CP103793.1\|	2033	g1071	i0	94.022	157.087804878049	368	18	89	4	1	366	1378791	1378426	Microbacterium testaceum strain D12 chromosome, complete genome	blastn	64406	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
1016450	1016450	PRJNA1074408_S_NODE_621_length_528_cov_5.086598_g496_i0	PRJNA1074408	621	528	5.086598	26.85723744	Microbacterium	33882	Bacteria	Bacteria	909	0	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g496	i0	97.727	179.267045454545	528	12	100	0	1	528	2452713	2452186	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	94653	909	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
1465588	1465588	PRJNA1074408_S_NODE_5322_length_200_cov_2.184713_g5192_i0	PRJNA1074408	5322	200	2.184713	4.369426	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	353	4.25e-93	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g5192	i0	98.5	436.725	200	3	100	0	1	200	553426	553227	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	87345	353	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2291834	2291834	PRJNA1074408_S_NODE_562_length_548_cov_12.257426_g438_i0	PRJNA1074408	562	548	12.257426	67.17069448	Microbacterium	33882	Bacteria	Bacteria	761	0	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g438	i0	93.282	236.713503649635	521	28	94	5	34	548	11	530	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	129719	767	0.992177314211212	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
4844605	4844605	PRJNA1074408_S_NODE_6184_length_187_cov_1.000000_g6054_i0	PRJNA1074408	6184	187	1	1.87	Corynebacterium	1716	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1710407388\|gb\|CP038157.1\|	2594913	g6054	i0	100	258.251336898396	187	0	100	0	1	187	914558	914744	Corynebacterium sanguinis strain CCUG 58655 chromosome, complete genome	blastn	48293	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sanguinis
6568927	6568927	PRJNA1074408_S_NODE_6986_length_177_cov_1.432836_g6856_i0	PRJNA1074408	6986	177	1.432836	2.53611972	Rubrobacter tropicus	2653851	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|1822171716\|gb\|CP045119.1\|	2653851	g6856	i0	99.435	1	177	1	100	0	1	177	1966487	1966311	Rubrobacter tropicus strain SCSIO 52909 chromosome, complete genome	blastn	177	322	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter tropicus
7394266	7394266	PRJNA1074408_S_NODE_7546_length_171_cov_1.125000_g7416_i0	PRJNA1074408	7546	171	1.125	1.92375	Nocardiaceae	85025	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g7416	i0	100	99.3567251461988	171	0	100	0	1	171	3351391	3351221	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	16990	316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
7843671	7843671	PRJNA1074408_S_NODE_4327_length_223_cov_1.333333_g4197_i0	PRJNA1074408	4327	223	1.333333	2.97333259	Brachybacterium sp. SGAir0954	2571029	Bacteria	Bacteria	401	1.7099999999999992e-107	NTclustered	gi\|1654137461\|gb\|CP027295.1\|	2571029	g4197	i0	99.103	230.708520179372	223	2	100	0	1	223	5705	5927	Brachybacterium sp. SGAir0954 chromosome, complete genome	blastn	51448	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. SGAir0954
16319044	16319044	PRJNA1074408_S_NODE_4573_length_216_cov_9.768786_g4443_i0	PRJNA1074408	4573	216	9.768786	21.10057776	Micrococcales	85006	Bacteria	Bacteria	399	5.909999999999999e-107	NTclustered	gi\|1233695344\|gb\|KY671173.1\|	2033	g4443	i0	100	100	216	0	100	0	1	216	99	314	Microbacterium testaceum strain Bu15_41 16S ribosomal RNA gene, partial sequence	blastn	21600	399	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
16319057	16319057	PRJNA1074408_S_NODE_7373_length_173_cov_0.976923_g7243_i0	PRJNA1074408	7373	173	0.976923	1.69007679	Cutibacterium	1912216	Bacteria	Bacteria	292	7.87e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7243	i0	100	251.658959537572	158	0	91	0	16	173	56587	56744	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	43537	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16319060	16319060	PRJNA1074408_S_NODE_93_length_1141_cov_6.029144_g47_i0	PRJNA1074408	93	1141	6.029144	68.79253304	Cutibacterium	1912216	Bacteria	Bacteria	2050	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g47	i0	99.821	249.36722173532	1116	2	98	0	1	1116	56465	55350	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	284528	2050	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18042729	18042729	PRJNA1074408_S_NODE_7915_length_167_cov_1.161290_g7785_i0	PRJNA1074408	7915	167	1.16129	1.9393543	Corynebacterium pyruviciproducens	598660	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2613058804\|gb\|CP136958.1\|	598660	g7785	i0	100	110.215568862275	167	0	100	0	1	167	379469	379635	Corynebacterium pyruviciproducens strain UMB0763 chromosome, complete genome	blastn	18406	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pyruviciproducens
20142908	20142908	PRJNA1074408_S_NODE_1676_length_351_cov_1.961039_g1546_i0	PRJNA1074408	1676	351	1.961039	6.88324689	Corynebacterium	1716	Bacteria	Bacteria	649	0	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g1546	i0	100	367.19943019943	351	0	100	0	1	351	1928	1578	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	128887	649	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
20142916	20142916	PRJNA1074408_S_NODE_5176_length_203_cov_1.800000_g5046_i0	PRJNA1074408	5176	203	1.8	3.654	Bacteria	2	Bacteria	Bacteria	270	4.49e-68	NTclustered	gi\|2800755081\|gb\|CP081300.1\|	2859784	g5046	i0	91.045	2.97044334975369	201	17	99	1	3	203	2571649	2571450	Streptomyces sp. II-2-2-2 strain Soil LB -1 chromosome, complete genome	blastn	603	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. II-2-2-2
21418574	21418574	PRJNA1074408_S_NODE_1277_length_399_cov_11.744382_g1147_i0	PRJNA1074408	1277	399	11.744382	46.86008418	Microbacterium	33882	Bacteria	Bacteria	732	0	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g1147	i0	99.749	186.977443609023	399	1	100	0	1	399	1177	779	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	74604	732	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
21867808	21867808	PRJNA1074408_S_NODE_9938_length_151_cov_0.888889_g9808_i0	PRJNA1074408	9938	151	0.888889	1.34222239	Blastococcus brunescens	1564165	Bacteria	Bacteria	230	5.299999999999999e-56	NTclustered	gi\|2645903955\|gb\|CP141261.1\|	1564165	g9808	i0	94.079	30.4900662251656	152	8	100	1	1	151	1981766	1981615	Blastococcus brunescens strain BMG 8361 chromosome, complete genome	blastn	4604	230	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus brunescens
25242794	25242794	PRJNA1074408_S_NODE_1700_length_349_cov_1.977124_g1570_i0	PRJNA1074408	1700	349	1.977124	6.90016276	Corynebacterium	1716	Bacteria	Bacteria	593	4.369999999999998e-165	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g1570	i0	99.691	338.521489971347	324	1	93	0	1	324	2685	2362	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	118144	593	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum

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