metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA610520" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA610520" 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
588511	588511	PRJNA610520_S_NODE_56941_length_258_cov_2.837838_g56851_i0	PRJNA610520	56941	258	2.837838	7.32162204	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	451	1.98e-122	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g56851	i0	98.438	364.56976744186	256	4	99	0	1	256	552752	553007	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	94059	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2422664	2422664	PRJNA610520_S_NODE_11042_length_410_cov_12.884273_g10952_i0	PRJNA610520	11042	410	12.884273	52.8255193	Cutibacterium	1912216	Bacteria	Bacteria	736	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10952	i0	100	258.034146341463	398	0	97	0	13	410	56605	56208	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	105794	736	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5692068	5692068	PRJNA610520_S_NODE_49645_length_273_cov_1.540000_g49555_i0	PRJNA610520	49645	273	1.54	4.2042	Mycobacterium sp. SMC-16	3385967	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|2872563150\|gb\|CP176427.1\|	3385967	g49555	i0	97.802	26.7216117216117	273	6	100	0	1	273	3200715	3200443	Mycobacterium sp. SMC-16 chromosome, complete genome	blastn	7295	472	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SMC-16
11350863	11350863	PRJNA610520_S_NODE_39849_length_295_cov_3.382883_g39759_i0	PRJNA610520	39849	295	3.382883	9.97950485	Mycetocola	76634	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1380445227\|gb\|CP026949.1\|	2079792	g39759	i0	100	192.010169491525	295	0	100	0	1	295	189404	189110	Mycetocola zhujimingii strain 449 = CGMCC 1.16372 chromosome, complete genome	blastn	56643	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Mycetocola	Mycetocola zhujimingii
12067827	12067827	PRJNA610520_S_NODE_43250_length_287_cov_1.822430_g43160_i0	PRJNA610520	43250	287	1.82243	5.2303741	Modestobacter italicus	2732864	Bacteria	Bacteria	470	6.18e-128	NTclustered	gi\|388483940\|emb\|FO203431.1\|	2732864	g43160	i0	96.491	360.989547038328	285	8	99	2	4	287	4339690	4339973	Modestobacter marinus str. BC501 chromosome, complete genome	blastn	103604	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter italicus
13901386	13901386	PRJNA610520_S_NODE_12791_length_398_cov_2.261538_g12701_i0	PRJNA610520	12791	398	2.261538	9.00092124	Corynebacterium	1716	Bacteria	Bacteria	676	0	NTclustered	gi\|2869858840\|gb\|CP175793.1\|	3383589	g12701	i0	98.942	336.675879396985	378	4	95	0	21	398	724814	724437	Corynebacterium sp. YSMAA1_1_D6 chromosome, complete genome	blastn	133997	676	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_D6
15175729	15175729	PRJNA610520_S_NODE_39852_length_295_cov_3.243243_g39762_i0	PRJNA610520	39852	295	3.243243	9.56756685	Cutibacterium	1912216	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g39762	i0	100	263.545762711864	295	0	100	0	1	295	55825	55531	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	77746	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17166219	17166219	PRJNA610520_S_NODE_35034_length_308_cov_2.625532_g34944_i0	PRJNA610520	35034	308	2.625532	8.08663856	Streptacidiphilus sp. PB12-B1b	2705012	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1886146638\|gb\|CP048405.1\|	2705012	g34944	i0	100	0.0941558441558442	29	0	9	0	256	284	2578194	2578222	Streptacidiphilus sp. PB12-B1b chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptacidiphilus	Streptacidiphilus sp. PB12-B1b
18998845	18998845	PRJNA610520_S_NODE_22155_length_350_cov_4.620939_g22065_i0	PRJNA610520	22155	350	4.620939	16.1732865	Streptomyces	1883	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2034371340\|gb\|CP074102.1\|	68239	g22065	i0	100	0.24	28	0	8	0	292	319	3071847	3071874	Streptomyces mirabilis strain P16B-1 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces mirabilis
25373718	25373718	PRJNA610520_S_NODE_42600_length_288_cov_6.148837_g42510_i0	PRJNA610520	42600	288	6.148837	17.70865056	Streptomyces	1883	Bacteria	Bacteria	108	5.61e-19	NTclustered	gi\|924539656\|gb\|CP011522.1\|	1649184	g42510	i0	81.618	6.70486111111111	136	19	46	6	78	210	1295435	1295567	Streptomyces sp. CFMR 7 strain CFMR-7, complete genome	blastn	1931	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CFMR 7

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