metadata: contig_metadata: 8 rows where bioproject = "PRJNA1054617" and tax

8 rows where bioproject = "PRJNA1054617" 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
9104094	9104094	PRJNA1054617_S_NODE_11888_length_170_cov_2.062992_g11800_i0	PRJNA1054617	11888	170	2.062992	3.5070864	Mycolicibacterium rufum	318424	Bacteria	Bacteria	263	6.03e-66	NTclustered	gi\|2294186521\|gb\|CP092427.2\|	318424	g11800	i0	94.706	276.211764705882	170	8	100	1	1	170	209072	208904	Mycolicibacterium rufum strain JCM 16372 chromosome, complete genome	blastn	46956	263	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rufum
10379822	10379822	PRJNA1054617_S_NODE_6949_length_213_cov_1.352941_g6861_i0	PRJNA1054617	6949	213	1.352941	2.88176433	Mycolicibacterium mageritense	53462	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|1806240795\|dbj\|AP022567.1\|	53462	g6861	i0	100	164.774647887324	213	0	100	0	1	213	194040	194252	Mycolicibacterium mageritense JCM 12375 DNA, complete genome	blastn	35097	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mageritense
13764642	13764642	PRJNA1054617_S_NODE_851_length_472_cov_3.913753_g765_i0	PRJNA1054617	851	472	3.913753	18.47291416	Cutibacterium	1912216	Bacteria	Bacteria	859	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g765	i0	100	248.885593220339	465	0	99	0	1	465	55844	55380	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	117474	859	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16313711	16313711	PRJNA1054617_S_NODE_8793_length_193_cov_2.020000_g8705_i0	PRJNA1054617	8793	193	2.02	3.8986	Microbacterium	33882	Bacteria	Bacteria	346	6.82e-91	NTclustered	gi\|1314922424\|gb\|CP025299.1\|	162426	g8705	i0	98.964	159.844559585492	193	2	100	0	1	193	1540030	1540222	Microbacterium hominis strain SJTG1 chromosome, complete genome	blastn	30850	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hominis
20137677	20137677	PRJNA1054617_S_NODE_4296_length_258_cov_2.953488_g4208_i0	PRJNA1054617	4296	258	2.953488	7.61999904	Cutibacterium	1912216	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4208	i0	100	267.957364341085	258	0	100	0	1	258	56208	56465	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	69133	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24402462	24402462	PRJNA1054617_S_NODE_12880_length_164_cov_2.016529_g12792_i0	PRJNA1054617	12880	164	2.016529	3.30710756	Corynebacterium aurimucosum	169292	Bacteria	Bacteria	244	2.1e-60	NTclustered	gi\|2891546711\|gb\|CP160096.1\|	169292	g12792	i0	94.34	31.4634146341463	159	9	97	0	6	164	716930	717088	Corynebacterium aurimucosum strain C_04_car chromosome, complete genome	blastn	5160	244	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium aurimucosum
24402483	24402483	PRJNA1054617_S_NODE_3740_length_273_cov_2.221739_g3652_i0	PRJNA1054617	3740	273	2.221739	6.06534747	Mycolicibacterium rufum	318424	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|2294186521\|gb\|CP092427.2\|	318424	g3652	i0	100	178.736263736264	273	0	100	0	1	273	208090	207818	Mycolicibacterium rufum strain JCM 16372 chromosome, complete genome	blastn	48795	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rufum
32776916	32776916	PRJNA1054617_S_NODE_9540_length_187_cov_1.236111_g9452_i0	PRJNA1054617	9540	187	1.236111	2.31152757	Streptomyces	1883	Bacteria	Bacteria	41.6	0.0466	NR	WP_198549265.1	936756	g9452	i0	45.7	1.47593582887701	46	22	73.8	2	172	35	221	263	WP_198549265.1 hypothetical protein [Streptomyces kanasensis]	diamond	276	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces kanasensis

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