metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA348537" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA348537" 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
393546	393546	PRJNA348537_S_NODE_4301_length_155_cov_1.241667_g4255_i0	PRJNA348537	4301	155	1.241667	1.92458385	Fusobacteria bacterium ZRK30	2970471	Bacteria	Bacteria	281	1.49e-71	NTclustered	gi\|2284594148\|gb\|CP102404.1\|	2970471	g4255	i0	99.355	67.7806451612903	155	1	100	0	1	155	204782	204936	Fusobacteria bacterium ZRK30 chromosome 1, complete sequence	blastn	10506	281	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteria bacterium ZRK30
6173318	6173318	PRJNA348537_S_NODE_225_length_548_cov_69.906433_g181_i0	PRJNA348537	225	548	69.906433	383.08725284	Cetobacterium	180162	Bacteria	Bacteria	970	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g181	i0	98.897	523.169708029197	544	5	99	1	1	544	420464	419922	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	286697	970	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11273644	11273644	PRJNA348537_S_NODE_989_length_290_cov_14.364706_g943_i0	PRJNA348537	989	290	14.364706	41.6576474	Cetobacterium	180162	Bacteria	Bacteria	494	3.71e-135	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g943	i0	100	493.206896551724	267	0	92	0	1	267	280504	280770	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	143030	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19519297	19519297	PRJNA348537_S_NODE_4196_length_156_cov_3.066116_g4150_i0	PRJNA348537	4196	156	3.066116	4.78314096	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	248	1.5299999999999998e-61	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4150	i0	95.513	5	156	6	100	1	1	156	52011	51857	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	780	248	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22747355	22747355	PRJNA348537_S_NODE_3178_length_174_cov_4.410072_g3132_i0	PRJNA348537	3178	174	4.410072	7.67352528	Leptotrichia	32067	Bacteria	Bacteria	239	1.05e-58	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g3132	i0	94.231	414.32183908046	156	9	90	0	9	164	178185	178030	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	72092	239	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
24022220	24022220	PRJNA348537_S_NODE_399_length_427_cov_171.905612_g353_i0	PRJNA348537	399	427	171.905612	734.03696324	Cetobacterium	180162	Bacteria	Bacteria	555	2.569999999999999e-153	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g353	i0	92.152	492.384074941452	395	27	100	4	1	393	279052	278660	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	210248	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25296640	25296640	PRJNA348537_S_NODE_1240_length_261_cov_3.619469_g1194_i0	PRJNA348537	1240	261	3.619469	9.44681409	Leptotrichia	32067	Bacteria	Bacteria	444	3.36e-120	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g1194	i0	97.318	226.628352490421	261	7	100	0	1	261	71484	71744	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	59150	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis

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