metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1249535" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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
1052456	1052456	PRJNA1249535_S_NODE_186221_length_314_cov_1.825726_g182838_i0	PRJNA1249535	186221	314	1.825726	5.73277964	Nocardiaceae	85025	Bacteria	Bacteria	564	3.05e-156	NTclustered	gi\|1927996901\|gb\|CP063662.1\|	37332	g182838	i0	99.048	409.315286624204	315	2	100	1	1	314	2161	1847	Nocardia seriolae strain NK201610020 chromosome	blastn	128525	569	0.991212653778559	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia seriolae
1632191	1632191	PRJNA1249535_S_NODE_283562_length_262_cov_1.238095_g280179_i0	PRJNA1249535	283562	262	1.238095	3.2438089	Streptomyces sp. NBC_01343	2903832	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2653094433\|gb\|CP108362.1\|	2903832	g280179	i0	100	0.106870229007634	28	0	11	0	113	140	929176	929203	Streptomyces sp. NBC_01343 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01343
3602920	3602920	PRJNA1249535_S_NODE_137103_length_344_cov_1.726937_g133720_i0	PRJNA1249535	137103	344	1.726937	5.94066328	Rhodococcus	1827	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|1995488816\|gb\|CP070609.1\|	99653	g133720	i0	100	0.162790697674419	28	0	8	0	285	312	2577657	2577630	Rhodococcus koreensis strain R85 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus koreensis
3602953	3602953	PRJNA1249535_S_NODE_238263_length_286_cov_2.723005_g234880_i0	PRJNA1249535	238263	286	2.723005	7.7877943	Gardnerella	2701	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2769796964\|gb\|CP160093.1\|	2702	g234880	i0	92.683	0.286713286713287	41	0	14	2	127	165	540014	540053	Gardnerella vaginalis strain 1683_1263_1_CBA4 chromosome, complete genome	blastn	82	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
4880509	4880509	PRJNA1249535_S_NODE_236664_length_287_cov_2.186916_g233281_i0	PRJNA1249535	236664	287	2.186916	6.27644892	Kocuria	57493	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g233281	i0	100	270.324041811847	287	0	100	0	1	287	898390	898104	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	77583	531	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
7430410	7430410	PRJNA1249535_S_NODE_61326_length_442_cov_3.002710_g57956_i0	PRJNA1249535	61326	442	3.00271	13.2719782	Micrococcus	1269	Bacteria	Bacteria	804	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g57956	i0	100	370.891402714932	435	0	98	0	8	442	346588	346154	Micrococcus luteus strain V017 chromosome, complete genome	blastn	163934	804	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
8009505	8009505	PRJNA1249535_S_NODE_177247_length_319_cov_1.686992_g173864_i0	PRJNA1249535	177247	319	1.686992	5.38150448	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	507	5.31e-139	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g173864	i0	95.298	285.401253918495	319	15	100	0	1	319	553326	553008	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	91043	507	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
8705248	8705248	PRJNA1249535_S_NODE_24787_length_613_cov_4.996296_g21615_i0	PRJNA1249535	24787	613	4.996296	30.62729448	Nocardiopsis	2013	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2034420761\|gb\|CP074133.1\|	2831969	g21615	i0	100	0.0946166394779772	29	0	5	0	384	412	6610304	6610332	Nocardiopsis changdeensis strain Mg02 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis changdeensis
11834925	11834925	PRJNA1249535_S_NODE_189350_length_312_cov_2.824268_g185967_i0	PRJNA1249535	189350	312	2.824268	8.81171616	Cutibacterium granulosum	33011	Bacteria	Bacteria	556	5.07e-154	NTclustered	gi\|1231673337\|emb\|LT906441.1\|	33011	g185967	i0	100	252.580128205128	301	0	96	0	12	312	1036368	1036068	Cutibacterium granulosum strain NCTC11865 genome assembly, chromosome: 1	blastn	78805	556	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
11835456	11835456	PRJNA1249535_S_NODE_229270_length_291_cov_1.944954_g225887_i0	PRJNA1249535	229270	291	1.944954	5.65981614	Paenarthrobacter ureafaciens	37931	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1957899728\|gb\|CP068013.1\|	37931	g225887	i0	100	0.0962199312714777	28	0	10	0	19	46	432612	432639	Paenarthrobacter ureafaciens strain CZY1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Paenarthrobacter	Paenarthrobacter ureafaciens
12531068	12531068	PRJNA1249535_S_NODE_225110_length_293_cov_2.400000_g221727_i0	PRJNA1249535	225110	293	2.4	7.032	Cutibacterium	1912216	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g221727	i0	100	279.464163822526	293	0	100	0	1	293	608944	608652	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	81883	542	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15660096	15660096	PRJNA1249535_S_NODE_265453_length_271_cov_6.065657_g262070_i0	PRJNA1249535	265453	271	6.065657	16.43793047	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g262070	i0	100	361.627306273063	271	0	100	0	1	271	3686	3416	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	98001	501	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
15661471	15661471	PRJNA1249535_S_NODE_58613_length_450_cov_1.904509_g55247_i0	PRJNA1249535	58613	450	1.904509	8.5702905	Micromonospora echinospora	1877	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|1052278845\|emb\|LT607413.1\|	1877	g55247	i0	100	0.0622222222222222	28	0	6	0	222	249	4072134	4072107	Micromonospora echinospora strain DSM 43816 genome assembly, chromosome: I	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora echinospora
18206816	18206816	PRJNA1249535_S_NODE_107135_length_367_cov_27.105442_g103752_i0	PRJNA1249535	107135	367	27.105442	99.47697214	Leucobacter coleopterorum	2714933	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|1821437501\|gb\|CP049933.1\|	2714933	g103752	i0	100	0.0762942779291553	28	0	8	0	41	68	3097563	3097536	Leucobacter coleopterorum strain HDW9A chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter coleopterorum
18904004	18904004	PRJNA1249535_S_NODE_344215_length_205_cov_5.787879_g340832_i0	PRJNA1249535	344215	205	5.787879	11.86515195	Kocuria	57493	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g340832	i0	100	380.907317073171	205	0	100	0	1	205	899611	899815	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	78086	379	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
19484867	19484867	PRJNA1249535_S_NODE_73216_length_413_cov_8.797059_g69835_i0	PRJNA1249535	73216	413	8.797059	36.33185367	Leucobacter coleopterorum	2714933	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1821437501\|gb\|CP049933.1\|	2714933	g69835	i0	100	0.0677966101694915	28	0	7	0	17	44	3097563	3097536	Leucobacter coleopterorum strain HDW9A chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter coleopterorum
20178540	20178540	PRJNA1249535_S_NODE_107456_length_367_cov_5.323129_g104073_i0	PRJNA1249535	107456	367	5.323129	19.53588343	Cutibacterium	1912216	Bacteria	Bacteria	678	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g104073	i0	100	294.839237057221	367	0	100	0	1	367	55732	56098	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	108206	678	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20178592	20178592	PRJNA1249535_S_NODE_274496_length_267_cov_1.103093_g271113_i0	PRJNA1249535	274496	267	1.103093	2.94525831	Corynebacterium	1716	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|582055084\|gb\|KF925936.1\|	53374	g271113	i0	100	108.977528089888	267	0	100	0	1	267	28	294	Corynebacterium coyleae strain V17 2011245 16S ribosomal RNA gene, partial sequence	blastn	29097	494	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium coyleae
20758291	20758291	PRJNA1249535_S_NODE_228877_length_291_cov_2.775229_g225494_i0	PRJNA1249535	228877	291	2.775229	8.07591639	Natronosporangium hydrolyticum	2811111	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1993651312\|gb\|CP070499.1\|	2811111	g225494	i0	100	0.0962199312714777	28	0	10	0	27	54	3766451	3766424	Natronosporangium hydrolyticum strain DSM 106523 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Natronosporangium	Natronosporangium hydrolyticum
22035638	22035638	PRJNA1249535_S_NODE_79718_length_402_cov_2.097264_g76337_i0	PRJNA1249535	79718	402	2.097264	8.43100128	Curtobacterium sp. Csp1	2495429	Bacteria	Bacteria	58.4	8.28e-4	NTclustered	gi\|1858289411\|gb\|CP054594.1\|	2495429	g76337	i0	100	0.0771144278606965	31	0	8	0	7	37	3901378	3901408	Curtobacterium sp. Csp1 chromosome	blastn	31	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium sp. Csp1
23309023	23309023	PRJNA1249535_S_NODE_222199_length_294_cov_5.416290_g218816_i0	PRJNA1249535	222199	294	5.41629	15.9238926	uncultured Microthrixaceae bacterium	1798915	Bacteria	Bacteria	377	3.96e-100	NTclustered	gi\|2874253917\|emb\|OY970242.1\|	1798915	g218816	i0	90.102	113.843537414966	293	25	99	3	5	294	1276664	1276373	MAG: uncultured Microthrixaceae bacterium isolate MFD03066.bin.2.142 genome assembly, chromosome: 1	blastn	33470	377	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Microthrixaceae		uncultured Microthrixaceae bacterium
23310614	23310614	PRJNA1249535_S_NODE_46299_length_492_cov_3.128878_g42963_i0	PRJNA1249535	46299	492	3.128878	15.39407976	Streptomyces sp. NBC_01511	2903889	Bacteria	Bacteria	62.1	7.98e-5	NTclustered	gi\|2656529163\|gb\|CP109417.1\|	2903889	g42963	i0	94.872	0.0792682926829268	39	2	8	0	52	90	1648580	1648542	Streptomyces sp. NBC_01511 chromosome, complete genome	blastn	39	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01511
24004412	24004412	PRJNA1249535_S_NODE_162619_length_327_cov_4.263780_g159236_i0	PRJNA1249535	162619	327	4.26378	13.9425606	Corynebacterium	1716	Bacteria	Bacteria	599	8.759999999999997e-167	NTclustered	gi\|470484386\|ref\|NR_076645.1\|	161879	g159236	i0	99.694	432.281345565749	327	1	100	0	1	327	419	93	Corynebacterium kroppenstedtii strain DSM 44385 23S ribosomal RNA gene, complete sequence	blastn	141356	599	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
25278597	25278597	PRJNA1249535_S_NODE_317360_length_244_cov_0.912281_g313977_i0	PRJNA1249535	317360	244	0.912281	2.22596564	Mycobacteroides	670516	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1951304461\|gb\|CP050223.1\|	1774	g313977	i0	100	99.8565573770492	244	0	100	0	1	244	1220500	1220743	Mycobacteroides chelonae strain Myco1 chromosome	blastn	24365	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides chelonae

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