metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA798511" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA798511" 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
789611	789611	PRJNA798511_P_NODE_102981_length_241_cov_0.916667_g98715_i0	PRJNA798511	102981	241	0.916667	2.20916747	Mycobacteroides salmoniphilum	404941	Bacteria	Bacteria	390	4.05e-104	NTclustered	gi\|1626698579\|gb\|CP024633.1\|	404941	g98715	i0	95.851	14.7966804979253	241	10	100	0	1	241	3054817	3055057	Mycobacteroides salmoniphilum strain DSM 43276 chromosome	blastn	3566	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides salmoniphilum
3342342	3342342	PRJNA798511_P_NODE_97323_length_245_cov_0.895349_g93057_i0	PRJNA798511	97323	245	0.895349	2.19360505	Corynebacterium accolens	38284	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g93057	i0	89.431	25.0530612244898	246	21	99	4	1	243	1386880	1387123	Corynebacterium accolens strain CA3 chromosome	blastn	6138	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
10994553	10994553	PRJNA798511_P_NODE_47229_length_371_cov_2.902685_g42963_i0	PRJNA798511	47229	371	2.902685	10.76896135	Rothia dentocariosa	2047	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2894503601\|gb\|CP178332.1\|	2047	g42963	i0	96.875	0.0862533692722372	32	0	9	1	138	169	1169337	1169367	Rothia dentocariosa strain SOSUI018 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
17369667	17369667	PRJNA798511_P_NODE_95594_length_246_cov_0.890173_g91328_i0	PRJNA798511	95594	246	0.890173	2.18982558	Schaalia sp. HMT-877	3059029	Bacteria	Bacteria	117	7.77e-22	NTclustered	gi\|2557565758\|gb\|CP130059.1\|	3059029	g91328	i0	85.088	0.463414634146341	114	17	46	0	133	246	327598	327711	Schaalia sp. HMT-877 strain F0543 chromosome, complete genome	blastn	114	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia sp. HMT-877
17795416	17795416	PRJNA798511_P_NODE_103234_length_241_cov_0.916667_g98968_i0	PRJNA798511	103234	241	0.916667	2.20916747	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g98968	i0	100	56.7344398340249	241	0	100	0	1	241	1553996	1554236	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13673	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22895300	22895300	PRJNA798511_P_NODE_36238_length_457_cov_1.375000_g31979_i0	PRJNA798511	36238	457	1.375	6.28375	Gardnerella	2701	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2769796964\|gb\|CP160093.1\|	2702	g31979	i0	100	0.12253829321663	28	0	6	0	159	186	1116982	1116955	Gardnerella vaginalis strain 1683_1263_1_CBA4 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis

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