metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA314497" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA314497" 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
1655377	1655377	PRJNA314497_S_NODE_1402_length_188_cov_3.088050_g1379_i0	PRJNA314497	1402	188	3.08805	5.805534	Rubrobacter marinus	2653852	Bacteria	Bacteria	342	8.539999999999999e-90	NTclustered	gi\|1822167692\|gb\|CP045121.1\|	2653852	g1379	i0	99.468	87.4414893617021	188	1	100	0	1	188	2263201	2263388	Rubrobacter marinus strain SCSIO 52915 chromosome, complete genome	blastn	16439	342	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter marinus
1655378	1655378	PRJNA314497_S_NODE_1722_length_167_cov_5.688406_g1699_i0	PRJNA314497	1722	167	5.688406	9.49963802	Rubrobacter marinus	2653852	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1822167692\|gb\|CP045121.1\|	2653852	g1699	i0	100	408.532934131737	167	0	100	0	1	167	2262866	2263032	Rubrobacter marinus strain SCSIO 52915 chromosome, complete genome	blastn	68225	309	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter marinus
2931243	2931243	PRJNA314497_S_NODE_123_length_636_cov_5.619440_g108_i0	PRJNA314497	123	636	5.61944	35.7396384	Rothia dentocariosa	2047	Bacteria	Bacteria	1157	0	NTclustered	gi\|2894499433\|gb\|CP178330.1\|	2047	g108	i0	99.528	87.6116352201258	635	3	99	0	1	635	1443398	1442764	Rothia dentocariosa strain SOSUI028 chromosome, complete genome	blastn	55721	1157	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
2931244	2931244	PRJNA314497_S_NODE_163_length_569_cov_6.142593_g146_i0	PRJNA314497	163	569	6.142593	34.95135417	Microbacterium foliorum	104336	Bacteria	Bacteria	1051	0	NTclustered	gi\|1444845539\|gb\|CP031425.1\|	104336	g146	i0	100	176.288224956063	569	0	100	0	1	569	2319415	2318847	Microbacterium foliorum strain NRRL B-24224 chromosome, complete genome	blastn	100308	1051	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium foliorum
2931251	2931251	PRJNA314497_S_NODE_923_length_247_cov_4.334862_g900_i0	PRJNA314497	923	247	4.334862	10.70710914	Mycobacterium marinum	1781	Bacteria	Bacteria	453	5.2400000000000005e-123	NTclustered	gi\|183173361\|gb\|CP000854.1\|	216594	g900	i0	100	28.5060728744939	245	0	99	0	3	247	3943851	3944095	Mycobacterium marinum M, complete genome	blastn	7041	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
4207789	4207789	PRJNA314497_S_NODE_544_length_326_cov_7.656566_g521_i0	PRJNA314497	544	326	7.656566	24.96040516	Nocardioides sp. B-3	2895565	Bacteria	Bacteria	475	1.53e-129	NTclustered	gi\|2286662645\|gb\|CP087968.1\|	2895565	g521	i0	92.945	242.030674846626	326	23	100	0	1	326	3322954	3323279	Nocardioides sp. B-3 chromosome, complete genome	blastn	78902	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. B-3
4207790	4207790	PRJNA314497_S_NODE_584_length_317_cov_2.666667_g561_i0	PRJNA314497	584	317	2.666667	8.45333439	Cutibacterium acnes	1747	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|966537955\|gb\|CP012352.1\|	1747	g561	i0	100	52.211356466877	317	0	100	0	1	317	2435443	2435759	Cutibacterium acnes strain PA_15_2_L1 chromosome, complete genome	blastn	16551	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4893053	4893053	PRJNA314497_S_NODE_504_length_339_cov_4.632258_g481_i0	PRJNA314497	504	339	4.632258	15.70335462	Corynebacterium	1716	Bacteria	Bacteria	566	9.249999999999999e-157	NTclustered	gi\|1986028547\|gb\|CP069509.1\|	161879	g481	i0	96.755	10.3451327433628	339	11	100	0	1	339	668461	668123	Corynebacterium kroppenstedtii strain FDAARGOS_1192 chromosome, complete genome	blastn	3507	566	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
7443110	7443110	PRJNA314497_S_NODE_1126_length_215_cov_13.586022_g1103_i0	PRJNA314497	1126	215	13.586022	29.2099473	Mycobacterium	1763	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|1341111796\|dbj\|AP018496.1\|	1781	g1103	i0	100	108.693023255814	215	0	100	0	1	215	4846777	4846991	Mycobacterium marinum ATCC 927 DNA, complete genome	blastn	23369	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
7443112	7443112	PRJNA314497_S_NODE_1806_length_163_cov_3.253731_g1783_i0	PRJNA314497	1806	163	3.253731	5.30358153	Cutibacterium	1912216	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1783	i0	100	263.092024539877	163	0	100	0	1	163	57060	57222	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	42884	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7443113	7443113	PRJNA314497_S_NODE_226_length_501_cov_17.447034_g205_i0	PRJNA314497	226	501	17.447034	87.40964034	Mycobacterium	1763	Bacteria	Bacteria	926	0	NTclustered	gi\|1341111796\|dbj\|AP018496.1\|	1781	g205	i0	100	109.139720558882	501	0	100	0	1	501	4846319	4846819	Mycobacterium marinum ATCC 927 DNA, complete genome	blastn	54679	926	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
7443115	7443115	PRJNA314497_S_NODE_66_length_830_cov_11.059925_g54_i0	PRJNA314497	66	830	11.059925	91.7973775	Mycobacterium	1763	Bacteria	Bacteria	1533	0	NTclustered	gi\|196174919\|gb\|EU684009.1\|	1781	g54	i0	100	109.596385542169	830	0	100	0	1	830	418	1247	Mycobacterium marinum strain R106 23S ribosomal RNA gene, partial sequence	blastn	90965	1533	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
9993349	9993349	PRJNA314497_P_NODE_3868_length_219_cov_4.736842_g3716_i0	PRJNA314497	3868	219	4.736842	10.37368398	Mycobacterium	1763	Bacteria	Bacteria	315	2.2399999999999993e-81	NTclustered	gi\|2155044973\|dbj\|AP025179.1\|	2871094	g3716	i0	92.727	110.168949771689	220	13	99	3	1	218	4344374	4344156	Mycobacterium sp. IWGMT90018-18076 DNA, complete genome	blastn	24127	315	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium kiyosense
16367740	16367740	PRJNA314497_S_NODE_1413_length_187_cov_2.050633_g1390_i0	PRJNA314497	1413	187	2.050633	3.83468371	Corynebacterium	1716	Bacteria	Bacteria	324	3.07e-84	NTclustered	gi\|1986028547\|gb\|CP069509.1\|	161879	g1390	i0	97.861	4.95187165775401	187	4	100	0	1	187	1405553	1405739	Corynebacterium kroppenstedtii strain FDAARGOS_1192 chromosome, complete genome	blastn	926	324	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
17642846	17642846	PRJNA314497_P_NODE_3754_length_229_cov_6.765000_g3602_i0	PRJNA314497	3754	229	6.765	15.49185	Corynebacterium	1716	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2550478735\|gb\|CP100378.1\|	38284	g3602	i0	100	363.868995633188	229	0	100	0	1	229	2380386	2380614	Corynebacterium accolens strain CA5 chromosome	blastn	83326	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
17642848	17642848	PRJNA314497_S_NODE_194_length_532_cov_7.642147_g177_i0	PRJNA314497	194	532	7.642147	40.65622204	Mycobacterium	1763	Bacteria	Bacteria	798	0	NTclustered	gi\|1341111796\|dbj\|AP018496.1\|	1781	g177	i0	97.046	97.109022556391	474	14	89	0	1	474	4845558	4845085	Mycobacterium marinum ATCC 927 DNA, complete genome	blastn	51662	798	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
18232260	18232260	PRJNA314497_S_NODE_1235_length_204_cov_5.634286_g1212_i0	PRJNA314497	1235	204	5.634286	11.49394344	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	335	1.5799999999999993e-87	NTclustered	gi\|2869826682\|gb\|CP175779.1\|	38304	g1212	i0	97.462	355.392156862745	197	3	97	1	8	204	4658	4464	Corynebacterium tuberculostearicum strain YSMAA3_1_A4 chromosome, complete genome	blastn	72500	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
18916664	18916664	PRJNA314497_S_NODE_755_length_271_cov_9.421488_g732_i0	PRJNA314497	755	271	9.421488	25.53223248	Rothia	32207	Bacteria	Bacteria	431	2.729999999999999e-116	NTclustered	gi\|470475611\|ref\|NR_076290.1\|	43675	g732	i0	95.572	202.918819188192	271	9	100	2	1	271	399	666	Rothia mucilaginosa strain DY-18 23S ribosomal RNA gene, complete sequence	blastn	54991	431	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
22057092	22057092	PRJNA314497_S_NODE_2098_length_151_cov_3.221311_g2075_i0	PRJNA314497	2098	151	3.221311	4.86417961	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	226	6.859999999999999e-55	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g2075	i0	93.96	362.377483443709	149	9	99	0	3	151	552398	552250	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	54719	226	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
22742037	22742037	PRJNA314497_S_NODE_1518_length_179_cov_3.013333_g1495_i0	PRJNA314497	1518	179	3.013333	5.39386607	Mycobacterium	1763	Bacteria	Bacteria	257	2.99e-64	NTclustered	gi\|1341111796\|dbj\|AP018496.1\|	1781	g1495	i0	98.621	19.391061452514	145	2	81	0	35	179	3736007	3736151	Mycobacterium marinum ATCC 927 DNA, complete genome	blastn	3471	257	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
22742038	22742038	PRJNA314497_S_NODE_178_length_548_cov_9.736031_g161_i0	PRJNA314497	178	548	9.736031	53.35344988	Corynebacterium	1716	Bacteria	Bacteria	1013	0	NTclustered	gi\|2879419909\|gb\|CP176025.1\|	3050202	g161	i0	100	126.406934306569	548	0	100	0	1	548	1724664	1724117	Corynebacterium sp. MSK084 chromosome, complete genome	blastn	69271	1013	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. MSK084
22742039	22742039	PRJNA314497_S_NODE_1938_length_158_cov_2.302326_g1915_i0	PRJNA314497	1938	158	2.302326	3.63767508	Coriobacteriales	84999	Bacteria	Bacteria	126	7.59e-25	NTclustered	gi\|2028894723\|gb\|CP072380.1\|	712157	g1915	i0	93.023	135.430379746835	86	6	54	0	73	158	1091249	1091164	Atopobium sp. oral taxon 416 strain W9116 chromosome, complete genome	blastn	21398	126	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae	Atopobium	Atopobium sp. oral taxon 416
24606677	24606677	PRJNA314497_S_NODE_2120_length_150_cov_4.702479_g2097_i0	PRJNA314497	2120	150	4.702479	7.0537185	Corynebacterium propinquum	43769	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2550427480\|gb\|CP100364.1\|	43769	g2097	i0	100	290.16	150	0	100	0	1	150	2500325	2500176	Corynebacterium propinquum strain CP8 chromosome	blastn	43524	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium propinquum
24606678	24606678	PRJNA314497_S_NODE_760_length_271_cov_2.958678_g737_i0	PRJNA314497	760	271	2.958678	8.01801738	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g737	i0	100	373.479704797048	271	0	100	0	1	271	1213829	1214099	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	101213	501	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
25291342	25291342	PRJNA314497_S_NODE_260_length_470_cov_5.086168_g239_i0	PRJNA314497	260	470	5.086168	23.9049896	Corynebacterium	1716	Bacteria	Bacteria	346	1.87e-90	NTclustered	gi\|2550468567\|gb\|CP100375.1\|	38284	g239	i0	82.759	347.51914893617	406	53	85	15	70	470	2491615	2491222	Corynebacterium accolens strain CA8 chromosome	blastn	163334	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens

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