metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA798905" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA798905" 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
2068062	2068062	PRJNA798905_S_NODE_36542_length_249_cov_1.750000_g36093_i0	PRJNA798905	36542	249	1.75	4.3575	Kribbella sp. CA-293567	3002436	Bacteria	Bacteria	62.1	3.74e-5	NTclustered	gi\|2425436797\|gb\|CP114065.1\|	3002436	g36093	i0	100	22.8072289156627	33	0	13	0	163	195	3580468	3580500	Kribbella sp. CA-293567 chromosome, complete genome	blastn	5679	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Kribbellaceae	Kribbella	Kribbella sp. CA-293567
4620892	4620892	PRJNA798905_S_NODE_7584_length_488_cov_5.125301_g7135_i0	PRJNA798905	7584	488	5.125301	25.01146888	Tsukamurella tyrosinosolvens	57704	Bacteria	Bacteria	701	0	NTclustered	gi\|2459075662\|gb\|CP119372.1\|	57704	g7135	i0	92.638	8.99180327868852	489	32	99	4	1	487	1448357	1447871	Tsukamurella tyrosinosolvens strain NAN1 chromosome	blastn	4388	701	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella tyrosinosolvens
11422192	11422192	PRJNA798905_S_NODE_40629_length_237_cov_5.853659_g40180_i0	PRJNA798905	40629	237	5.853659	13.87317183	Bacteria	2	Bacteria	Bacteria	250	7.0299999999999995e-62	NTclustered	gi\|1418363025\|gb\|CP030287.1\|	2099583	g40180	i0	85.654	2	237	34	100	0	1	237	8618876	8619112	Streptomyces sp. ICC1 chromosome	blastn	474	250	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. ICC1
17370792	17370792	PRJNA798905_S_NODE_42154_length_230_cov_2.286624_g41705_i0	PRJNA798905	42154	230	2.286624	5.2592352	Micrococcus luteus	1270	Bacteria	Bacteria	303	5.13e-78	NTclustered	gi\|1875928653\|gb\|CP059046.1\|	1270	g41705	i0	90.476	2.5304347826087	231	20	100	2	1	230	75270	75499	Micrococcus luteus strain R17 chromosome, complete genome	blastn	582	303	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
22468881	22468881	PRJNA798905_S_NODE_17218_length_354_cov_1.900356_g16769_i0	PRJNA798905	17218	354	1.900356	6.72726024	Corynebacterium minutissimum	38301	Bacteria	Bacteria	597	3.43e-166	NTclustered	gi\|1986087704\|gb\|CP069533.1\|	38301	g16769	i0	97.708	360.579096045198	349	4	98	2	1	347	1163920	1163574	Corynebacterium minutissimum strain FDAARGOS_1196 chromosome, complete genome	blastn	127645	597	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum
22469670	22469670	PRJNA798905_S_NODE_9358_length_447_cov_11.160428_g8909_i0	PRJNA798905	9358	447	11.160428	49.88711316	Nocardioides terrisoli	3388267	Bacteria	Bacteria	669	0	NTclustered	gi\|2579173395\|gb\|CP134227.1\|	3388267	g8909	i0	96.333	215.391498881432	409	11	91	4	1	407	390947	390541	Nocardioides terrisoli strain YR1 chromosome, complete genome	blastn	96280	669	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides terrisoli
22895751	22895751	PRJNA798905_S_NODE_26898_length_291_cov_4.458716_g26449_i0	PRJNA798905	26898	291	4.458716	12.97486356	Bacteria	2	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|1418363025\|gb\|CP030287.1\|	2099583	g26449	i0	100	5.28178694158076	291	0	100	0	1	291	8619339	8619629	Streptomyces sp. ICC1 chromosome	blastn	1537	538	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. ICC1
24169965	24169965	PRJNA798905_S_NODE_40579_length_238_cov_2.296970_g40130_i0	PRJNA798905	40579	238	2.29697	5.4667886	Corynebacterium	1716	Bacteria	Bacteria	359	1.12e-94	NTclustered	gi\|2099489108\|gb\|CP083646.1\|	108486	g40130	i0	94.068	2.96218487394958	236	14	99	0	3	238	2650745	2650980	Corynebacterium falsenii strain FDAARGOS_1494 chromosome, complete genome	blastn	705	359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium falsenii

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