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

8 rows where analysis = "blastn", bioproject = "PRJNA657343" 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
5726279	5726279	PRJNA657343_P_NODE_15965_length_225_cov_4.096591_g15941_i0	PRJNA657343	15965	225	4.096591	9.21732975	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g15941	i0	100	0.128888888888889	29	0	13	0	47	75	88070	88098	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
5727108	5727108	PRJNA657343_S_NODE_19105_length_206_cov_53.082803_g19080_i0	PRJNA657343	19105	206	53.082803	109.35057418	Cetobacterium somerae	188913	Bacteria	Bacteria	335	1.5999999999999997e-87	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g19080	i0	98.421	439.825242718447	190	3	92	0	3	192	1318971	1318782	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	90604	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6264213	6264213	PRJNA657343_S_NODE_15445_length_230_cov_27.944751_g15420_i0	PRJNA657343	15445	230	27.944751	64.2729273	Cetobacterium	180162	Bacteria	Bacteria	394	2.959999999999999e-105	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g15420	i0	99.537	489.752173913043	216	1	94	0	15	230	279210	278995	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	112643	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10088996	10088996	PRJNA657343_P_NODE_1988_length_484_cov_2.903448_g1965_i0	PRJNA657343	1988	484	2.903448	14.05268832	Cetobacterium	180162	Bacteria	Bacteria	490	8.44e-134	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1965	i0	100	539.074380165289	265	0	99	0	8	272	280778	280514	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	260912	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12639535	12639535	PRJNA657343_P_NODE_18750_length_212_cov_3.018405_g18726_i0	PRJNA657343	18750	212	3.018405	6.3990186	Fusobacterium	848	Bacteria	Bacteria	294	2.8e-75	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g18726	i0	93.627	459.801886792453	204	1	96	1	3	206	299096	299287	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	97478	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13378066	13378066	PRJNA657343_S_NODE_26351_length_174_cov_1.488000_g26326_i0	PRJNA657343	26351	174	1.488	2.58912	Leptotrichia wadei	157687	Bacteria	Bacteria	313	6.079999999999998e-81	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g26326	i0	100	183.35632183908	169	0	97	0	5	173	1756672	1756504	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	31904	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15926149	15926149	PRJNA657343_P_NODE_46353_length_156_cov_3.065421_g46329_i0	PRJNA657343	46353	156	3.065421	4.78205676	Leptotrichia wadei	157687	Bacteria	Bacteria	274	2.52e-69	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g46329	i0	98.701	317.653846153846	154	2	99	0	3	156	220973	220820	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	49554	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21562379	21562379	PRJNA657343_P_NODE_1337_length_554_cov_6.760396_g1315_i0	PRJNA657343	1337	554	6.760396	37.45259384	Cetobacterium	180162	Bacteria	Bacteria	856	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g1315	i0	94.909	500.001805054152	550	23	99	4	4	551	421799	421253	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	277001	856	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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