metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1101946" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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
1485934	1485934	PRJNA1101946_S_NODE_22822_length_168_cov_7.596639_g22723_i0	PRJNA1101946	22822	168	7.596639	12.76235352	Mycobacterium intracellulare	1767	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1950639805\|dbj\|AP024248.1\|	1767	g22723	i0	97.059	0.202380952380952	34	0	20	1	71	103	1921768	1921735	Mycobacterium intracellulare strain M008	blastn	34	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium intracellulare
2761932	2761932	PRJNA1101946_S_NODE_1103_length_470_cov_9.377672_g1007_i0	PRJNA1101946	1103	470	9.377672	44.0750584	Streptomyces sp. Je 1-332	3231270	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2770570345\|gb\|CP160402.1\|	3231270	g1007	i0	92.105	0.0808510638297872	38	1	8	2	375	412	2923495	2923460	Streptomyces sp. Je 1-332 chromosome, complete genome	blastn	38	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Je 1-332
6589389	6589389	PRJNA1101946_S_NODE_3586_length_339_cov_3.455172_g3487_i0	PRJNA1101946	3586	339	3.455172	11.71303308	Corynebacterium lizhenjunii	2709394	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1939561086\|gb\|CP064954.1\|	2709394	g3487	i0	100	0.0825958702064897	28	0	8	0	253	280	793889	793862	Corynebacterium lizhenjunii strain ZJ-599 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lizhenjunii
7397676	7397676	PRJNA1101946_S_NODE_10586_length_242_cov_2.595855_g10487_i0	PRJNA1101946	10586	242	2.595855	6.2819691	Cutibacterium	1912216	Bacteria	Bacteria	385	1.89e-102	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10487	i0	100	62.6570247933884	208	0	86	0	1	208	1180484	1180277	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15163	385	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13773278	13773278	PRJNA1101946_S_NODE_491_length_593_cov_13.454044_g409_i0	PRJNA1101946	491	593	13.454044	79.78248092	Cutibacterium	1912216	Bacteria	Bacteria	1014	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g409	i0	99.462	282.704890387858	558	3	94	0	21	578	608391	608948	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	167644	1014	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13773300	13773300	PRJNA1101946_S_NODE_951_length_489_cov_6.804545_g857_i0	PRJNA1101946	951	489	6.804545	33.27422505	Cutibacterium	1912216	Bacteria	Bacteria	893	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g857	i0	99.591	274.147239263804	489	2	100	0	1	489	56101	56589	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	134058	893	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14240055	14240055	PRJNA1101946_S_NODE_3992_length_330_cov_4.245552_g3893_i0	PRJNA1101946	3992	330	4.245552	14.0103216	Leucobacter aridicollis	283878	Bacteria	Bacteria	521	1.9699999999999998e-143	NTclustered	gi\|2276937852\|gb\|CP075339.1\|	283878	g3893	i0	95.195	224.80303030303	333	10	100	6	1	330	666971	667300	Leucobacter aridicollis strain J1 chromosome, complete genome	blastn	74185	521	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter aridicollis
16322398	16322398	PRJNA1101946_S_NODE_26033_length_158_cov_2.440367_g25934_i0	PRJNA1101946	26033	158	2.440367	3.85577986	Corynebacterium	1716	Bacteria	Bacteria	287	3.29e-73	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g25934	i0	99.367	383.424050632911	158	1	100	0	1	158	293981	294138	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	60581	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
18871507	18871507	PRJNA1101946_S_NODE_4475_length_320_cov_3.387454_g4376_i0	PRJNA1101946	4475	320	3.387454	10.8398528	Corynebacterium	1716	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g4376	i0	100	359.015625	320	0	100	0	1	320	2341320	2341001	Corynebacterium accolens strain CA7 chromosome	blastn	114885	592	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
19337091	19337091	PRJNA1101946_S_NODE_4036_length_329_cov_4.917857_g3937_i0	PRJNA1101946	4036	329	4.917857	16.17974953	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	608	1.4599999999999995e-169	NTclustered	gi\|1958382392\|gb\|CP068156.1\|	38304	g3937	i0	100	32.8905775075988	329	0	100	0	1	329	238647	238319	Corynebacterium tuberculostearicum strain FDAARGOS_1117 chromosome, complete genome	blastn	10821	608	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
20146320	20146320	PRJNA1101946_S_NODE_9916_length_248_cov_8.924623_g9817_i0	PRJNA1101946	9916	248	8.924623	22.13306504	Microbacterium	33882	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g9817	i0	99.597	164	248	1	100	0	1	248	231065	230818	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	40672	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
20612488	20612488	PRJNA1101946_S_NODE_5857_length_297_cov_4.318548_g5758_i0	PRJNA1101946	5857	297	4.318548	12.82608756	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	233	9.180000000000001e-57	NTclustered	gi\|2874253930\|emb\|OY970255.1\|	3039803	g5758	i0	81.311	124.767676767677	305	42	100	13	1	297	2179475	2179772	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.2.2 genome assembly, chromosome: 1	blastn	37056	233	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
22696885	22696885	PRJNA1101946_S_NODE_6738_length_284_cov_5.055319_g6639_i0	PRJNA1101946	6738	284	5.055319	14.35710596	Rathayibacter	33886	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|1004607163\|gb\|KT865871.1\|	1811327	g6639	i0	99.648	268.003521126761	284	1	100	0	1	284	239	522	Rathayibacter sp. ALBL_219 23S ribosomal RNA gene, partial sequence	blastn	76113	520	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter sp. ALBL_219
24437135	24437135	PRJNA1101946_S_NODE_11560_length_233_cov_22.652174_g11461_i0	PRJNA1101946	11560	233	22.652174	52.77956542	Corynebacterium lizhenjunii	2709394	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1939561086\|gb\|CP064954.1\|	2709394	g11461	i0	100	0.120171673819742	28	0	12	0	60	87	793862	793889	Corynebacterium lizhenjunii strain ZJ-599 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lizhenjunii
25246262	25246262	PRJNA1101946_S_NODE_340_length_672_cov_6.733547_g270_i0	PRJNA1101946	340	672	6.733547	45.24943584	Cutibacterium	1912216	Bacteria	Bacteria	1173	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g270	i0	99.382	258.188988095238	647	4	96	0	1	647	55997	55351	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	173503	1173	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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