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

5 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_kingdom = "Fusobacteriati"

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
847302	847302	PRJNA864829_S_NODE_8261_length_216_cov_1.592814_g8175_i0	PRJNA864829	8261	216	1.592814	3.44047824	Cetobacterium somerae	188913	Bacteria	Bacteria	348	2.1700000000000002e-91	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g8175	i0	98.969	432.824074074074	194	2	90	0	23	216	941093	941286	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	93490	348	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2512383	2512383	PRJNA864829_S_NODE_262_length_811_cov_4.572178_g209_i0	PRJNA864829	262	811	4.572178	37.08036358	Cetobacterium	180162	Bacteria	Bacteria	1424	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g209	i0	99.364	499.117139334155	786	5	97	0	1	786	279648	278863	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	404784	1424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5950564	5950564	PRJNA864829_S_NODE_1405_length_420_cov_7.304582_g1319_i0	PRJNA864829	1405	420	7.304582	30.6792444	Cetobacterium somerae	188913	Bacteria	Bacteria	741	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1319	i0	98.571	506.916666666667	420	5	100	1	1	420	49427	49009	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	212905	741	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6340818	6340818	PRJNA864829_S_NODE_6745_length_235_cov_3.887097_g6659_i0	PRJNA864829	6745	235	3.887097	9.13467795	Cetobacterium	180162	Bacteria	Bacteria	412	8.39e-111	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g6659	i0	98.298	509.531914893617	235	4	100	0	1	235	278841	278607	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	119740	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10165414	10165414	PRJNA864829_S_NODE_15048_length_168_cov_0.865546_g14962_i0	PRJNA864829	15048	168	0.865546	1.45411728	Fusobacterium	848	Bacteria	Bacteria	200	4.76e-47	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g14962	i0	88.485	468.363095238095	165	19	98	0	1	165	3422540	3422704	Fusobacterium varium strain SB069 chromosome	blastn	78685	200	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium

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