metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA515078" 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
1110913	1110913	PRJNA515078_P_NODE_1141_length_905_cov_10.034562_g20_i3	PRJNA515078	1141	905	10.034562	90.8127861	Cutibacterium	1912216	Bacteria	Bacteria	1550	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g20	i3	97.682	276.035359116022	906	14	99	6	3	905	56217	55316	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	249812	1550	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
1110979	1110979	PRJNA515078_P_NODE_33281_length_152_cov_2.034783_g33048_i0	PRJNA515078	33281	152	2.034783	3.09287016	Streptomyces	1883	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1851830967\|gb\|CP050522.1\|	1902	g33048	i0	100	540.703947368421	152	0	100	0	1	152	1447099	1447250	Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome	blastn	82187	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
3662236	3662236	PRJNA515078_P_NODE_323_length_1494_cov_9.533288_g20_i2	PRJNA515078	323	1494	9.533288	142.42732272	Cutibacterium	1912216	Bacteria	Bacteria	2359	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g20	i2	95.461	351.564926372155	1498	35	100	19	4	1494	56787	55316	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	525238	2359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4313747	4313747	PRJNA515078_P_NODE_22004_length_185_cov_1.054054_g21771_i0	PRJNA515078	22004	185	1.054054	1.9499999	uncultured Solirubrobacteraceae bacterium	1162706	Bacteria	Bacteria	110	9.24e-20	NTclustered	gi\|2874254080\|emb\|OY970163.1\|	1162706	g21771	i0	81.295	17.4324324324324	139	22	74	4	49	185	2294390	2294526	MAG: uncultured Solirubrobacteraceae bacterium isolate MFD04580.bin.c.4 genome assembly, chromosome: 1	blastn	3225	110	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		uncultured Solirubrobacteraceae bacterium
4313904	4313904	PRJNA515078_P_NODE_924_length_992_cov_5.861780_g803_i0	PRJNA515078	924	992	5.86178	58.1488576	Corynebacterium singulare	161899	Bacteria	Bacteria	54.7	0.028	NTclustered	gi\|754339082\|gb\|CP010827.1\|	161899	g803	i0	100	0.0292338709677419	29	0	3	0	918	946	2521264	2521236	Corynebacterium singulare strain IBS B52218, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium singulare
5590564	5590564	PRJNA515078_P_NODE_11545_length_263_cov_1.433628_g11312_i0	PRJNA515078	11545	263	1.433628	3.77044164	Streptomyces durmitorensis	319947	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2240236031\|gb\|CP097289.1\|	319947	g11312	i0	100	0.939163498098859	30	0	11	0	38	67	7289576	7289605	Streptomyces durmitorensis strain MS405 chromosome, complete genome	blastn	247	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces durmitorensis
6214430	6214430	PRJNA515078_P_NODE_22625_length_182_cov_2.468966_g22392_i0	PRJNA515078	22625	182	2.468966	4.49351812	Streptomyces	1883	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1399240079\|gb\|CP029788.1\|	1885	g22392	i0	100	553.648351648352	182	0	100	0	1	182	1248598	1248417	Streptomyces actuosus strain ATCC 25421 chromosome, complete genome	blastn	100764	337	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces actuosus
6214476	6214476	PRJNA515078_P_NODE_6325_length_373_cov_3.291667_g6092_i0	PRJNA515078	6325	373	3.291667	12.27791791	Saccharopolyspora	1835	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2029976357\|gb\|CP054839.1\|	1836	g6092	i0	100	0.225201072386059	28	0	8	0	330	357	3859008	3858981	Saccharopolyspora erythraea strain SCSIO 07745 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora erythraea
6864666	6864666	PRJNA515078_P_NODE_31506_length_156_cov_1.495798_g31273_i0	PRJNA515078	31506	156	1.495798	2.33344488	Rothia aeria	172042	Bacteria	Bacteria	270	3.2599999999999996e-68	NTclustered	gi\|2072522805\|gb\|CP079819.1\|	172042	g31273	i0	98.684	244.461538461538	152	2	97	0	1	152	524469	524620	Rothia aeria strain LPB0401 chromosome, complete genome	blastn	38136	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia aeria
7489047	7489047	PRJNA515078_P_NODE_26566_length_169_cov_1.098485_g26333_i0	PRJNA515078	26566	169	1.098485	1.85643965	Streptomyces	1883	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2655662105\|gb\|CP109226.1\|	1886	g26333	i0	99.408	594.952662721893	169	1	100	0	1	169	993995	993827	Streptomyces albidoflavus strain NBC 01671 chromosome, complete genome	blastn	100547	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
8763918	8763918	PRJNA515078_P_NODE_17127_length_211_cov_1.063218_g16894_i0	PRJNA515078	17127	211	1.063218	2.24338998	Micrococcus	1269	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|2873038046\|gb\|CP176570.1\|	1270	g16894	i0	100	285.473933649289	211	0	100	0	1	211	1554548	1554758	Micrococcus luteus strain SZ.RS01 chromosome, complete genome	blastn	60235	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
8763979	8763979	PRJNA515078_P_NODE_8147_length_321_cov_7.355634_g7914_i0	PRJNA515078	8147	321	7.355634	23.61158514	Actinomycetes	1760	Bacteria	Bacteria	540	5.27e-149	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g7914	i0	96.914	103.376947040498	324	7	100	2	1	321	485332	485009	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	33184	540	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
10039506	10039506	PRJNA515078_P_NODE_2888_length_572_cov_8.485981_g2670_i0	PRJNA515078	2888	572	8.485981	48.53981132	PVC group	1783257	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|2129715290\|gb\|CP086102.1\|	1892	g2670	i0	100	0.131118881118881	29	0	5	0	504	532	4470972	4470944	Streptomyces anulatus strain YINM00001 chromosome, complete genome	blastn	75	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces anulatus
13240756	13240756	PRJNA515078_P_NODE_25751_length_171_cov_1.574627_g25518_i0	PRJNA515078	25751	171	1.574627	2.69261217	Humibacillus xanthopallidus	412689	Bacteria	Bacteria	283	4.67e-72	NTclustered	gi\|2851121488\|gb\|CP084995.1\|	412689	g25518	i0	97.024	282.795321637427	168	5	98	0	1	168	1632761	1632928	Humibacillus xanthopallidus strain SLM-627 chromosome, complete genome	blastn	48358	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Humibacillus	Humibacillus xanthopallidus
13240806	13240806	PRJNA515078_P_NODE_3351_length_530_cov_1.409736_g3123_i0	PRJNA515078	3351	530	1.409736	7.4716008	Streptomyces sp. NBC_00582	2975783	Bacteria	Bacteria	285	4.71e-72	NTclustered	gi\|2667469075\|gb\|CP107772.1\|	2975783	g3123	i0	77.336	63.2622641509434	503	100	93	8	1	493	6485910	6486408	Streptomyces sp. NBC_00582 chromosome, complete genome	blastn	33529	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00582
14515754	14515754	PRJNA515078_P_NODE_20712_length_191_cov_0.948052_g20479_i0	PRJNA515078	20712	191	0.948052	1.81077932	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	274	3.2199999999999997e-69	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g20479	i0	92.386	475.146596858639	197	7	100	7	1	191	80926	81120	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	90753	274	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
15138980	15138980	PRJNA515078_P_NODE_11972_length_257_cov_3.404545_g11739_i0	PRJNA515078	11972	257	3.404545	8.74968065	Streptomyces	1883	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|2657564105\|gb\|CP108341.1\|	1924	g11739	i0	100	577.190661478599	257	0	100	0	1	257	3709309	3709565	Streptomyces purpurascens strain NBC_00017 chromosome, complete genome	blastn	148338	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces purpurascens
18338572	18338572	PRJNA515078_P_NODE_31435_length_156_cov_1.806723_g31202_i0	PRJNA515078	31435	156	1.806723	2.81848788	Streptomyces sp. SCUT-3	2684469	Bacteria	Bacteria	60.2	7.68e-5	NTclustered	gi\|1886128761\|gb\|CP046907.1\|	2684469	g31202	i0	94.737	1	38	2	24	0	117	154	4714215	4714178	Streptomyces sp. SCUT-3 chromosome, complete genome	blastn	156	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. SCUT-3
24062890	24062890	PRJNA515078_P_NODE_25019_length_174_cov_1.014599_g24786_i0	PRJNA515078	25019	174	1.014599	1.76540226	Corynebacterium	1716	Bacteria	Bacteria	309	7.87e-80	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g24786	i0	98.851	375.689655172414	174	1	100	1	1	174	623984	624156	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	65370	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24712887	24712887	PRJNA515078_P_NODE_19400_length_197_cov_1.462500_g19167_i0	PRJNA515078	19400	197	1.4625	2.881125	Streptomyces sp. NBC_00631	2975793	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2656789620\|gb\|CP107734.1\|	2975793	g19167	i0	100	0.568527918781726	28	0	14	0	16	43	9934252	9934279	Streptomyces sp. NBC_00631 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00631
24713017	24713017	PRJNA515078_P_NODE_5020_length_425_cov_12.621134_g4787_i0	PRJNA515078	5020	425	12.621134	53.6398195	Streptomyces hygroscopicus	1912	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2697500286\|gb\|CP146988.1\|	68042	g4787	i0	100	0.134117647058824	29	0	7	0	338	366	9087023	9087051	Streptomyces hygroscopicus subsp. hygroscopicus strain DSM 41954 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces hygroscopicus

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