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

7 rows where analysis = "blastn", bioproject = "PRJNA800053" 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
5047992	5047992	PRJNA800053_P_NODE_10504_length_302_cov_1.344978_g10340_i0	PRJNA800053	10504	302	1.344978	4.06183356	root	1	Root_unresolved	Root_unresolved	553	6.32e-153	NTclustered	gi\|645320556\|ref\|NR_117734.1\|	850	g10340	i0	99.669	106.894039735099	302	1	100	0	1	302	8	309	Fusobacterium mortiferum strain DSM 19809 16S ribosomal RNA, partial sequence	blastn	32282	553	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
11000021	11000021	PRJNA800053_P_NODE_11269_length_293_cov_2.472727_g11105_i0	PRJNA800053	11269	293	2.472727	7.24509011	Leptotrichia hofstadii	157688	Bacteria	Bacteria	503	6.24e-138	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g11105	i0	97.931	408.993174061433	290	6	99	0	1	290	2454471	2454760	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	119835	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
11000033	11000033	PRJNA800053_P_NODE_13309_length_277_cov_1.955882_g13145_i0	PRJNA800053	13309	277	1.955882	5.41779314	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	484	2.1199999999999996e-132	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g13145	i0	98.54	455.906137184116	274	4	99	0	4	277	1994516	1994789	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	126286	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
12275748	12275748	PRJNA800053_P_NODE_8850_length_323_cov_1.316000_g8686_i0	PRJNA800053	8850	323	1.316	4.25068	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	569	6.769999999999998e-158	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g8686	i0	98.457	134.489164086687	324	3	99	2	2	323	198305	197982	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	43440	569	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
17797483	17797483	PRJNA800053_P_NODE_15354_length_263_cov_1.389474_g15190_i0	PRJNA800053	15354	263	1.389474	3.65431662	Leptotrichia	32067	Bacteria	Bacteria	405	1.5999999999999996e-108	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g15190	i0	95.652	422.961977186312	253	10	96	1	1	252	71667	71415	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	111239	409	0.990220048899755	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
19923051	19923051	PRJNA800053_P_NODE_23936_length_241_cov_0.916667_g23772_i0	PRJNA800053	23936	241	0.916667	2.20916747	Fusobacterium perfoetens	852	Bacteria	Bacteria	414	2.3999999999999993e-111	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g23772	i0	97.917	463.157676348548	240	3	99	2	1	238	494	255	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	111621	414	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
24171528	24171528	PRJNA800053_P_NODE_6499_length_365_cov_2.458904_g6335_i0	PRJNA800053	6499	365	2.458904	8.9749996	Fusobacterium	848	Bacteria	Bacteria	669	0	NTclustered	gi\|2706069597\|gb\|CP077108.1\|	76857	g6335	i0	100	468.123287671233	362	0	99	0	1	362	1186032	1185671	Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome	blastn	170865	669	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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