metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA493234" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA493234" 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
2375019	2375019	PRJNA493234_S_NODE_10062_length_310_cov_3.594937_g9969_i0	PRJNA493234	10062	310	3.594937	11.1443047	Dermacoccus	57495	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|1730271953\|gb\|CP043031.1\|	322596	g9969	i0	100	243.987096774194	310	0	100	0	1	310	2215794	2215485	Dermacoccus abyssi strain HZAU 226 chromosome, complete genome	blastn	75636	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus abyssi
3650682	3650682	PRJNA493234_S_NODE_3683_length_395_cov_5.369565_g3590_i0	PRJNA493234	3683	395	5.369565	21.20978175	Cutibacterium	1912216	Bacteria	Bacteria	725	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3590	i0	99.747	266.506329113924	395	1	100	0	1	395	55458	55852	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	105270	725	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15756916	15756916	PRJNA493234_S_NODE_15773_length_266_cov_3.580311_g15680_i0	PRJNA493234	15773	266	3.580311	9.52362726	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g15680	i0	97.744	145.830827067669	266	6	100	0	1	266	553490	553225	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	38791	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
18951075	18951075	PRJNA493234_S_NODE_3055_length_412_cov_8.516224_g2962_i0	PRJNA493234	3055	412	8.516224	35.08684288	Corynebacterium	1716	Bacteria	Bacteria	756	0	NTclustered	gi\|2531251647\|gb\|CP046606.1\|	144183	g2962	i0	99.757	380.211165048544	412	1	100	0	1	412	649072	649483	Corynebacterium afermentans subsp. afermentans strain DSM 44280 chromosome, complete genome	blastn	156647	756	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
24680271	24680271	PRJNA493234_S_NODE_16000_length_265_cov_1.213542_g15907_i0	PRJNA493234	16000	265	1.213542	3.2158863	Actinomyces viscosus	1656	Bacteria	Bacteria	451	2.04e-122	NTclustered	gi\|168485113\|gb\|EU306593.1\|	1656	g15907	i0	97.368	219.720754716981	266	5	100	2	1	265	565	829	Actinomyces viscosus 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	58226	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces viscosus

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