metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA889065" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA889065" 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	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
4691792	4691792	PRJNA889065_S_NODE_30844_length_173_cov_1.961538_g30606_i0	PRJNA889065	30844	173	1.961538	3.39346074	Brachybacterium faecium	43669	Bacteria	Bacteria	274	2.85e-69	NTclustered	gi\|256558041\|gb\|CP001643.1\|	446465	g30606	i0	95.858	3.71098265895954	169	7	98	4	172	133705	133537	Brachybacterium faecium DSM 4810 strain 6-10, complete genome	blastn	642	274	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium faecium
9791295	9791295	PRJNA889065_S_NODE_27048_length_186_cov_2.573427_g26810_i0	PRJNA889065	27048	186	2.573427	4.78657422	Micrococcus yunnanensis	566027	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|2506638323\|gb\|CP125290.1\|	566027	g26810	i0	100	199.236559139785	186	0	100	1	186	248032	247847	Micrococcus yunnanensis strain TJPT4 chromosome, complete genome	blastn	37058	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus yunnanensis
10170714	10170714	PRJNA889065_S_NODE_12108_length_276_cov_4.068670_g11870_i0	PRJNA889065	12108	276	4.06867	11.2295292	Cutibacterium	1912216	Bacteria	Bacteria	505	1.62e-138	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11870	i0	99.638	271.463768115942	276	1	100	1	276	57819	58094	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	74924	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11066809	11066809	PRJNA889065_S_NODE_12689_length_270_cov_2.814978_g12451_i0	PRJNA889065	12689	270	2.814978	7.6004406	Corynebacterium afermentans	38286	Bacteria	Bacteria	475	1.2399999999999999e-129	NTclustered	gi\|2531253808\|gb\|CP046530.1\|	144184	g12451	i0	100	433.462962962963	257	0	95	14	270	640207	640463	Corynebacterium afermentans subsp. lipophilum strain DSM 44282 chromosome, complete genome	blastn	117035	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
12721703	12721703	PRJNA889065_S_NODE_29910_length_176_cov_2.075188_g29672_i0	PRJNA889065	29910	176	2.075188	3.65233088	Dietzia	37914	Bacteria	Bacteria	281	1.74e-71	NTclustered	gi\|2708443468\|gb\|CP143297.1\|	322509	g29672	i0	95.455	335.159090909091	176	8	100	1	176	716471	716296	Dietzia kunjamensis strain IITR165 chromosome, complete genome	blastn	58988	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia kunjamensis
13996082	13996082	PRJNA889065_S_NODE_20511_length_215_cov_1.575581_g20273_i0	PRJNA889065	20511	215	1.575581	3.38749915	Cutibacterium	1912216	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g20273	i0	100	259.544186046512	215	0	100	1	215	55817	55603	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	55802	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17819731	17819731	PRJNA889065_S_NODE_21434_length_210_cov_2.449102_g21196_i0	PRJNA889065	21434	210	2.449102	5.1431142	Corynebacterium	1716	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|2547417233\|gb\|CP073096.1\|	38304	g21196	i0	100	367.37619047619	210	0	100	1	210	790013	789804	Corynebacterium tuberculostearicum strain CTNIH20 chromosome, complete genome	blastn	77149	388	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
19093696	19093696	PRJNA889065_S_NODE_30295_length_175_cov_1.393939_g30057_i0	PRJNA889065	30295	175	1.393939	2.43939325	Cutibacterium	1912216	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g30057	i0	100	299.291428571429	175	0	100	1	175	55823	55997	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	52376	324	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24193756	24193756	PRJNA889065_S_NODE_36659_length_157_cov_2.008772_g36421_i0	PRJNA889065	36659	157	2.008772	3.15377204	Streptosporangium	2000	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2651931882\|gb\|CP109068.1\|	106412	g36421	i0	100	2.88535031847134	29	0	18	22	50	8175848	8175820	Streptosporangium subroseum strain NBC 01811 chromosome, complete genome	blastn	453	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium	Streptosporangium subroseum

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