metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1074407" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1074407" 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
1462599	1462599	PRJNA1074407_P_NODE_101802_length_342_cov_1.256506_g97964_i0	PRJNA1074407	101802	342	1.256506	4.29725052	Rothia nasimurium	85336	Bacteria	Bacteria	593	4.2799999999999986e-165	NTclustered	gi\|1890911746\|gb\|CP056080.1\|	85336	g97964	i0	97.959	345.476608187135	343	5	100	2	1	342	1713940	1713599	Rothia nasimurium strain E1706032 chromosome, complete genome	blastn	118153	593	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia nasimurium
1462777	1462777	PRJNA1074407_P_NODE_109962_length_316_cov_0.991770_g106124_i0	PRJNA1074407	109962	316	0.99177	3.1339932	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	568	2.3799999999999994e-157	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g106124	i0	99.051	359.164556962025	316	3	100	0	1	316	623536	623221	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	113496	568	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
4844374	4844374	PRJNA1074407_P_NODE_100444_length_346_cov_2.945055_g96606_i0	PRJNA1074407	100444	346	2.945055	10.1898903	Corynebacterium	1716	Bacteria	Bacteria	638	1.9799999999999997e-178	NTclustered	gi\|2500252091\|gb\|OQ919411.1\|	1720	g96606	i0	100	207.407514450867	345	0	99	0	1	345	12	356	Corynebacterium sp. strain c3Ub_189 16S ribosomal RNA gene, partial sequence	blastn	71763	638	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
6566436	6566436	PRJNA1074407_P_NODE_123026_length_279_cov_2.223301_g119188_i0	PRJNA1074407	123026	279	2.223301	6.20300979	Rothia nasimurium	85336	Bacteria	Bacteria	387	6.2e-103	NTclustered	gi\|1890911746\|gb\|CP056080.1\|	85336	g119188	i0	91.756	230.132616487455	279	22	100	1	1	279	1714425	1714148	Rothia nasimurium strain E1706032 chromosome, complete genome	blastn	64207	387	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia nasimurium
7394068	7394068	PRJNA1074407_P_NODE_118226_length_292_cov_1.255708_g114388_i0	PRJNA1074407	118226	292	1.255708	3.66666736	Bacteria	2	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2460939270\|dbj\|AP027452.1\|	53462	g114388	i0	100	1.34246575342466	28	0	10	0	152	179	1647822	1647795	Mycolicibacterium mageritense H4_3_1 DNA, complete genome	blastn	392	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mageritense
8669624	8669624	PRJNA1074407_P_NODE_38447_length_861_cov_1.640863_g34999_i0	PRJNA1074407	38447	861	1.640863	14.12783043	Intrasporangiaceae	85021	Bacteria	Bacteria	1314	0	NTclustered	gi\|2851167701\|gb\|CP085209.1\|	367299	g34999	i0	94.386	189.390243902439	855	48	100	0	1	855	2272240	2273094	Phycicoccus jejuensis strain QJJ-866 chromosome, complete genome	blastn	163065	1325	0.991698113207547	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Phycicoccus	Phycicoccus jejuensis
9944597	9944597	PRJNA1074407_P_NODE_46388_length_731_cov_1.594225_g42708_i0	PRJNA1074407	46388	731	1.594225	11.65378475	Cutibacterium	1912216	Bacteria	Bacteria	1351	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g42708	i0	100	278.127222982216	731	0	100	0	1	731	56130	55400	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	203311	1351	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10392017	10392017	PRJNA1074407_P_NODE_138009_length_247_cov_0.873563_g134171_i0	PRJNA1074407	138009	247	0.873563	2.15770061	uncultured Solirubrobacteraceae bacterium	1162706	Bacteria	Bacteria	383	6.97e-102	NTclustered	gi\|2874253663\|emb\|OY969097.1\|	1162706	g134171	i0	94.715	99.0283400809717	246	13	99	0	2	247	3205643	3205888	MAG: uncultured Solirubrobacteraceae bacterium isolate MFD05512.bin.c.13 genome assembly, chromosome: 1	blastn	24460	383	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		uncultured Solirubrobacteraceae bacterium
11667166	11667166	PRJNA1074407_P_NODE_124310_length_276_cov_1.123153_g120472_i0	PRJNA1074407	124310	276	1.123153	3.09990228	Blastococcus brunescens	1564165	Bacteria	Bacteria	403	6.08e-108	NTclustered	gi\|2645903955\|gb\|CP141261.1\|	1564165	g120472	i0	93.116	448.641304347826	276	18	100	1	1	276	1983128	1982854	Blastococcus brunescens strain BMG 8361 chromosome, complete genome	blastn	123825	403	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus brunescens
12942334	12942334	PRJNA1074407_P_NODE_130251_length_261_cov_0.797872_g126413_i0	PRJNA1074407	130251	261	0.797872	2.08244592	Propionimicrobium sp. PCR01-08-3	3052086	Bacteria	Bacteria	257	4.7e-64	NTclustered	gi\|2521516302\|gb\|CP127390.1\|	3052086	g126413	i0	86.752	142.226053639847	234	28	90	3	1	234	1750272	1750502	Propionimicrobium sp. PCR01-08-3 chromosome, complete genome	blastn	37121	257	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionimicrobium	Propionimicrobium sp. PCR01-08-3
14217235	14217235	PRJNA1074407_P_NODE_126572_length_270_cov_1.157360_g122734_i0	PRJNA1074407	126572	270	1.15736	3.124872	Pedococcus dokdonensis	443156	Bacteria	Bacteria	433	7.56e-117	NTclustered	gi\|1085742359\|emb\|LT629711.1\|	443156	g122734	i0	95.556	230.003703703704	270	12	100	0	1	270	1368075	1368344	Phycicoccus dokdonensis strain DSM 22329 genome assembly, chromosome: I	blastn	62101	433	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Pedococcus	Pedococcus dokdonensis
14217609	14217609	PRJNA1074407_P_NODE_146472_length_240_cov_0.910180_g142634_i0	PRJNA1074407	146472	240	0.91018	2.184432	Glutamicibacter mishrai	1775880	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|2744084060\|gb\|CP157880.1\|	1775880	g142634	i0	99.583	7.9625	240	1	100	0	1	240	1760398	1760159	Glutamicibacter mishrai strain ebst40 chromosome, complete genome	blastn	1911	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter mishrai
15492876	15492876	PRJNA1074407_P_NODE_64573_length_531_cov_1.342795_g60748_i0	PRJNA1074407	64573	531	1.342795	7.13024145	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	791	0	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g60748	i0	94.892	358	509	21	95	4	1	506	3802	3296	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	190098	791	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
17594069	17594069	PRJNA1074407_P_NODE_100674_length_346_cov_1.058608_g96836_i0	PRJNA1074407	100674	346	1.058608	3.66278368	Nocardioides	1839	Bacteria	Bacteria	573	5.65e-159	NTclustered	gi\|1821124102\|gb\|CP049867.1\|	2714939	g96836	i0	96.532	215.14161849711	346	12	100	0	1	346	2037844	2037499	Nocardioides sp. HDW12B chromosome, complete genome	blastn	74439	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. HDW12B
17594104	17594104	PRJNA1074407_P_NODE_125414_length_273_cov_1.165000_g121576_i0	PRJNA1074407	125414	273	1.165	3.18045	Cutibacterium	1912216	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g121576	i0	99.634	51	273	1	100	0	1	273	1550750	1550478	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	13923	499	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17594128	17594128	PRJNA1074407_P_NODE_142414_length_243_cov_0.894118_g138576_i0	PRJNA1074407	142414	243	0.894118	2.17270674	Cutibacterium	1912216	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g138576	i0	100	51.7942386831276	243	0	100	0	1	243	943692	943450	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12586	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18868000	18868000	PRJNA1074407_P_NODE_36835_length_893_cov_1.729268_g33441_i0	PRJNA1074407	36835	893	1.729268	15.44236324	Cutibacterium	1912216	Bacteria	Bacteria	1644	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g33441	i0	99.888	262.786114221725	893	1	100	0	1	893	56204	57096	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	234668	1644	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21865230	21865230	PRJNA1074407_P_NODE_120178_length_287_cov_1.065421_g116340_i0	PRJNA1074407	120178	287	1.065421	3.05775827	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	503	6.1e-138	NTclustered	gi\|2874253879\|emb\|OY969934.1\|	152507	g116340	i0	98.258	307.348432055749	287	5	100	0	1	287	2031056	2031342	MAG: uncultured Actinomycetes bacterium isolate MFD04944.bin.1.31 genome assembly, chromosome: 1	blastn	88209	503	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
21867373	21867373	PRJNA1074407_P_NODE_78898_length_438_cov_2.235616_g75062_i0	PRJNA1074407	78898	438	2.235616	9.79199808	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	737	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g75062	i0	97.032	331.002283105023	438	13	100	0	1	438	552426	551989	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	144979	737	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis

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