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

9 rows where analysis = "blastn", bioproject = "PRJNA1101048" 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
1019771	1019771	PRJNA1101048_P_NODE_4361_length_302_cov_2.720524_g4305_i0	PRJNA1101048	4361	302	2.720524	8.21598248	Cutibacterium	1912216	Bacteria	Bacteria	525	1.3799999999999995e-144	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4305	i0	98.976	258.470198675497	293	3	97	0	2	294	55937	55645	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	78058	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3570375	3570375	PRJNA1101048_P_NODE_4723_length_293_cov_2.200000_g4667_i0	PRJNA1101048	4723	293	2.2	6.446	Cutibacterium	1912216	Bacteria	Bacteria	298	3.16e-76	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4667	i0	99.39	53.1638225255973	164	1	100	0	130	293	515893	515730	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15577	298	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9948021	9948021	PRJNA1101048_P_NODE_3168_length_340_cov_1.397004_g3112_i0	PRJNA1101048	3168	340	1.397004	4.7498136	Streptomyces	1883	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2173784915\|gb\|CP085300.1\|	2605730	g3112	i0	100	0.164705882352941	28	0	8	0	223	250	6500038	6500065	Streptomyces sp. BSE6.1 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. BSE6.1
9948024	9948024	PRJNA1101048_P_NODE_5608_length_275_cov_2.767327_g5552_i0	PRJNA1101048	5608	275	2.767327	7.61014925	Cutibacterium	1912216	Bacteria	Bacteria	466	7.62e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5552	i0	98.855	243.043636363636	262	2	95	1	10	270	56848	57109	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	66837	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10414607	10414607	PRJNA1101048_P_NODE_7629_length_250_cov_0.881356_g7573_i0	PRJNA1101048	7629	250	0.881356	2.20339	Corynebacterium pseudokroppenstedtii	2804917	Bacteria	Bacteria	436	5.349999999999999e-118	NTclustered	gi\|2659438818\|gb\|CP137757.1\|	2804917	g7573	i0	99.582	6.276	239	1	96	0	1	239	780984	780746	Corynebacterium pseudokroppenstedtii strain P15_C1 chromosome, complete genome	blastn	1569	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudokroppenstedtii
13773210	13773210	PRJNA1101048_P_NODE_7451_length_251_cov_0.876404_g7395_i0	PRJNA1101048	7451	251	0.876404	2.19977404	Corynebacterium	1716	Bacteria	Bacteria	340	4.33e-89	NTclustered	gi\|1986028547\|gb\|CP069509.1\|	161879	g7395	i0	97.487	4	199	5	79	0	28	226	1378458	1378260	Corynebacterium kroppenstedtii strain FDAARGOS_1192 chromosome, complete genome	blastn	1004	340	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
16322324	16322324	PRJNA1101048_P_NODE_6373_length_262_cov_1.507937_g6317_i0	PRJNA1101048	6373	262	1.507937	3.95079494	Cutibacterium	1912216	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g6317	i0	100	52.1374045801527	259	0	99	0	1	259	1768822	1768564	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13660	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18062895	18062895	PRJNA1101048_P_NODE_5195_length_284_cov_1.194313_g5139_i0	PRJNA1101048	5195	284	1.194313	3.39184892	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	444	3.6999999999999986e-120	NTclustered	gi\|2694275225\|gb\|CP140010.1\|	1528099	g5139	i0	99.588	4.01056338028169	243	1	99	0	3	245	345818	346060	MAG: Lawsonella clevelandensis isolate TECA_312545_bc_10 chromosome	blastn	1139	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
18062903	18062903	PRJNA1101048_P_NODE_8115_length_248_cov_0.885714_g8059_i0	PRJNA1101048	8115	248	0.885714	2.19657072	Corynebacterium kroppenstedtii	161879	Bacteria	Bacteria	374	4.2099999999999995e-99	NTclustered	gi\|2809007534\|gb\|CP119163.1\|	2736648	g8059	i0	94.606	80.9193548387097	241	13	97	0	3	243	2337002	2337242	Corynebacterium kroppenstedtii subsp. demodicis strain Df-1 chromosome, complete genome	blastn	20068	374	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii

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