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

22 rows where analysis = "blastn", bioproject = "PRJNA715461" 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
705123	705123	PRJNA715461_S_NODE_41_length_1018_cov_1760.673016_g15_i1	PRJNA715461	41	1018	1760.673016	17923.65130288	Mycolicibacterium neoaurum	1795	Bacteria	Bacteria	1116	0	NTclustered	gi\|2039848366\|gb\|CP074376.1\|	1795	g15	i1	94.958	219.225933202358	714	33	88	3	229	940	2326267	2326979	Mycolicibacterium neoaurum strain MN2019 chromosome, complete genome	blastn	223172	1116	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium neoaurum
1192218	1192218	PRJNA715461_S_NODE_861_length_271_cov_1.348485_g787_i0	PRJNA715461	861	271	1.348485	3.65439435	root	1	Root_unresolved	Root_unresolved	350	7.87e-92	NTclustered	gi\|1241781168\|gb\|MF948908.1\|	2033	g787	i0	100	96.5424354243542	189	0	92	0	22	210	748	560	Microbacterium testaceum strain PSB215 16S ribosomal RNA gene, partial sequence	blastn	26163	351	0.997150997150997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
1981149	1981149	PRJNA715461_S_NODE_902_length_264_cov_3.256545_g828_i0	PRJNA715461	902	264	3.256545	8.5972788	Mycolicibacterium litorale	758802	Bacteria	Bacteria	442	1.2199999999999994e-119	NTclustered	gi\|1150429307\|gb\|CP019882.1\|	758802	g828	i0	99.587	172.768939393939	242	1	92	0	4	245	1686288	1686529	Mycolicibacterium litorale strain F4 chromosome, complete genome	blastn	45611	442	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium litorale
2467553	2467553	PRJNA715461_S_NODE_102_length_837_cov_3235.918848_g15_i2	PRJNA715461	102	837	3235.918848	27084.64075776	Blastococcus	38501	Bacteria	Bacteria	1175	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g15	i2	94.862	312.765830346476	759	28	90	10	82	834	1833	1080	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	261785	1175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
5020490	5020490	PRJNA715461_S_NODE_324_length_484_cov_3.238443_g257_i0	PRJNA715461	324	484	3.238443	15.67406412	Cutibacterium	1912216	Bacteria	Bacteria	883	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g257	i0	99.792	286.787190082645	481	1	99	0	4	484	55796	56276	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	138805	883	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6296248	6296248	PRJNA715461_S_NODE_285_length_523_cov_4.831111_g222_i0	PRJNA715461	285	523	4.831111	25.26671053	Mycobacteriaceae	1762	Bacteria	Bacteria	915	0	NTclustered	gi\|1214880407\|emb\|LT899394.1\|	1791	g222	i0	99.405	173.495219885277	504	3	96	0	17	520	1544467	1543964	Mycobacterium aurum isolate liquid genome assembly, chromosome: I	blastn	90738	920	0.994565217391304	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aurum
7570063	7570063	PRJNA715461_S_NODE_26_length_1170_cov_2155.505014_g15_i0	PRJNA715461	26	1170	2155.505014	25219.4086638	Blastococcus	38501	Bacteria	Bacteria	1716	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g15	i0	95.247	392.176068376068	1094	34	93	15	82	1167	2163	1080	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	458846	1716	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
8845186	8845186	PRJNA715461_S_NODE_547_length_367_cov_2.721088_g473_i0	PRJNA715461	547	367	2.721088	9.98639296	Cutibacterium	1912216	Bacteria	Bacteria	627	4.5499999999999997e-175	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g473	i0	100	248.839237057221	339	0	93	0	26	364	56555	56217	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	91324	627	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9633674	9633674	PRJNA715461_S_NODE_588_length_352_cov_2.874552_g514_i0	PRJNA715461	588	352	2.874552	10.11842304	Mycolicibacterium aurum	1791	Bacteria	Bacteria	549	9.679999999999996e-152	NTclustered	gi\|1539986808\|emb\|LR134356.1\|	1791	g514	i0	97.799	184.707386363636	318	7	90	0	32	349	3325037	3325354	Mycolicibacterium aurum strain NCTC10437 genome assembly, chromosome: 1	blastn	65017	549	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aurum
9633680	9633680	PRJNA715461_S_NODE_88_length_883_cov_2921.350617_g51_i0	PRJNA715461	88	883	2921.350617	25795.52594811	Mycolicibacterium neoaurum	1795	Bacteria	Bacteria	1478	0	NTclustered	gi\|2039848366\|gb\|CP074376.1\|	1795	g51	i0	99.875	171.509626274066	803	1	91	0	1	803	2325317	2326119	Mycolicibacterium neoaurum strain MN2019 chromosome, complete genome	blastn	151443	1478	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium neoaurum
11395787	11395787	PRJNA715461_S_NODE_1309_length_222_cov_7.536913_g1235_i0	PRJNA715461	1309	222	7.536913	16.73194686	Gordonia	2053	Bacteria	Bacteria	279	8.300000000000001e-71	NTclustered	gi\|254656127\|gb\|FJ536302.1\|	2054	g1235	i0	100	70.7387387387387	151	0	68	0	1	151	848	998	Gordonia bronchialis strain IFM 0974 16S ribosomal RNA gene, partial sequence	blastn	15704	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia bronchialis
11395800	11395800	PRJNA715461_S_NODE_909_length_263_cov_2.978947_g835_i0	PRJNA715461	909	263	2.978947	7.83463061	Gordonia	2053	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|470485342\|ref\|NR_076696.1\|	2054	g835	i0	99.615	340.152091254753	260	1	99	0	1	260	2457	2198	Gordonia bronchialis strain Tsukamura 3410 23S ribosomal RNA gene, complete sequence	blastn	89460	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia bronchialis
12184446	12184446	PRJNA715461_S_NODE_1050_length_245_cov_1.401163_g976_i0	PRJNA715461	1050	245	1.401163	3.43284935	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	418	1.8899999999999995e-112	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g976	i0	98.723	331.938775510204	235	3	96	0	8	242	1298282	1298516	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	81325	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
12184455	12184455	PRJNA715461_S_NODE_250_length_553_cov_4960.310417_g194_i0	PRJNA715461	250	553	4960.310417	27430.51660601	Blastococcus sp. PRF04-17	2933797	Bacteria	Bacteria	691	0	NTclustered	gi\|2224896457\|gb\|CP095412.1\|	2933797	g194	i0	93.249	207.461121157324	474	24	85	8	82	552	930386	930854	Blastococcus sp. PRF04-17 chromosome, complete genome	blastn	114726	691	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus sp. PRF04-17
15220737	15220737	PRJNA715461_S_NODE_152_length_673_cov_3995.118333_g93_i1	PRJNA715461	152	673	3995.118333	26887.14638109	Blastococcus	38501	Bacteria	Bacteria	992	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93	i1	96.97	238.84249628529	594	13	88	4	81	670	1126	534	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	160741	992	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
15220747	15220747	PRJNA715461_S_NODE_772_length_289_cov_2.180556_g698_i0	PRJNA715461	772	289	2.180556	6.30180684	Cutibacterium	1912216	Bacteria	Bacteria	424	4.9199999999999996e-114	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g698	i0	100	207.162629757785	229	0	79	0	58	286	57075	56847	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	59870	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17769913	17769913	PRJNA715461_S_NODE_154_length_666_cov_4141.639123_g93_i2	PRJNA715461	154	666	4141.639123	27583.31655918	Blastococcus	38501	Bacteria	Bacteria	972	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93	i2	96.913	242.837837837838	583	13	87	4	4	582	534	1115	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	161730	972	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
18556978	18556978	PRJNA715461_S_NODE_955_length_255_cov_11.054945_g881_i0	PRJNA715461	955	255	11.054945	28.19010975	Mycolicibacterium neoaurum	1795	Bacteria	Bacteria	370	5.63e-98	NTclustered	gi\|2039848366\|gb\|CP074376.1\|	1795	g881	i0	100	134.976470588235	200	0	78	0	53	252	2325341	2325142	Mycolicibacterium neoaurum strain MN2019 chromosome, complete genome	blastn	34419	370	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium neoaurum
20318613	20318613	PRJNA715461_S_NODE_136_length_717_cov_208.880435_g93_i0	PRJNA715461	136	717	208.880435	1497.67271895	Blastococcus	38501	Bacteria	Bacteria	992	0	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93	i0	96.97	224.18549511855	594	13	82	4	4	593	534	1126	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	160741	992	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
21594444	21594444	PRJNA715461_S_NODE_337_length_471_cov_527.469849_g268_i0	PRJNA715461	337	471	527.469849	2484.38298879	Mycobacteriaceae	1762	Bacteria	Bacteria	645	1.6499999999999993e-180	NTclustered	gi\|1511893315\|gb\|MK156797.1\|	1785	g268	i0	100	91.0828025477707	349	0	74	0	13	361	16	364	Mycobacterium sp. strain B5-4 16S ribosomal RNA gene, partial sequence	blastn	42900	651	0.990783410138249	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
22382696	22382696	PRJNA715461_S_NODE_138_length_706_cov_13.699842_g15_i3	PRJNA715461	138	706	13.699842	96.72088452	Blastococcus brunescens	1564165	Bacteria	Bacteria	787	0	NTclustered	gi\|2645903955\|gb\|CP141261.1\|	1564165	g15	i3	90.713	294.742209631728	603	39	84	12	4	599	3153685	3153093	Blastococcus brunescens strain BMG 8361 chromosome, complete genome	blastn	208088	787	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus brunescens
24931695	24931695	PRJNA715461_S_NODE_1340_length_220_cov_15.857143_g1266_i0	PRJNA715461	1340	220	15.857143	34.8857146	Mycolicibacterium neoaurum	1795	Bacteria	Bacteria	401	1.6799999999999993e-107	NTclustered	gi\|2039848366\|gb\|CP074376.1\|	1795	g1266	i0	100	127.304545454545	217	0	99	0	4	220	2324980	2325196	Mycolicibacterium neoaurum strain MN2019 chromosome, complete genome	blastn	28007	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium neoaurum

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