metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1253698" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1253698" 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
1052871	1052871	PRJNA1253698_S_NODE_4441_length_330_cov_2.925267_g4075_i0	PRJNA1253698	4441	330	2.925267	9.6533811	Leptotrichia	32067	Bacteria	Bacteria	549	9.039999999999996e-152	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g4075	i0	97.222	489.745454545455	324	9	98	0	7	330	2143	2466	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	161616	549	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
2910304	2910304	PRJNA1253698_S_NODE_12323_length_198_cov_2.228188_g11957_i0	PRJNA1253698	12323	198	2.228188	4.41181224	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	364	1.9399999999999995e-96	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g11957	i0	100	136.313131313131	197	0	99	0	2	198	397391	397195	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	26990	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
5462964	5462964	PRJNA1253698_S_NODE_11465_length_204_cov_4.367742_g11099_i0	PRJNA1253698	11465	204	4.367742	8.91019368	Leptotrichia trevisanii	109328	Bacteria	Bacteria	364	2.0099999999999998e-96	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g11099	i0	99.015	506.166666666667	203	2	99	0	2	204	159414	159212	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	103258	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
6737392	6737392	PRJNA1253698_S_NODE_1806_length_588_cov_2.981447_g1459_i0	PRJNA1253698	1806	588	2.981447	17.53090836	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	819	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1459	i0	93.333	445.755102040816	555	36	94	1	9	562	53358	52804	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	262104	819	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11838292	11838292	PRJNA1253698_S_NODE_23910_length_160_cov_3.162162_g23544_i0	PRJNA1253698	23910	160	3.162162	5.0594592	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	281	1.55e-71	NTclustered	gi\|571048574\|gb\|KF422121.1\|	159271	g23544	i0	99.355	34.95	155	1	97	0	1	155	239	85	Uncultured Leptotrichia sp. clone VostokV6_rep_c139 genomic sequence	blastn	5592	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
14388759	14388759	PRJNA1253698_S_NODE_15512_length_179_cov_2.015385_g15146_i0	PRJNA1253698	15512	179	2.015385	3.60753915	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	324	2.91e-84	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g15146	i0	99.438	297.08938547486	178	1	99	0	2	179	71290	71113	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	53179	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
18211353	18211353	PRJNA1253698_S_NODE_14235_length_186_cov_1.153285_g13869_i0	PRJNA1253698	14235	186	1.153285	2.1451101	Leptotrichia trevisanii	109328	Bacteria	Bacteria	331	1.82e-86	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g13869	i0	98.919	44.8225806451613	185	2	99	0	1	185	159958	160142	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	8337	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
19485709	19485709	PRJNA1253698_S_NODE_5096_length_306_cov_4.116732_g4730_i0	PRJNA1253698	5096	306	4.116732	12.59719992	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	499	8.4799999999999985e-137	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4730	i0	96.667	136.93137254902	300	10	98	0	1	300	51601	51900	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	41901	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19485716	19485716	PRJNA1253698_S_NODE_6376_length_272_cov_2.905830_g6010_i0	PRJNA1253698	6376	272	2.90583	7.9038576	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	492	1.24e-134	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g6010	i0	99.265	201.360294117647	272	2	100	0	1	272	1995259	1994988	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	54770	492	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
24004880	24004880	PRJNA1253698_S_NODE_8439_length_237_cov_1.914894_g8073_i0	PRJNA1253698	8439	237	1.914894	4.53829878	Fusobacterium	848	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2704996929\|gb\|CP077149.1\|	851	g8073	i0	100	0.472573839662447	28	0	12	0	209	236	581516	581543	Fusobacterium nucleatum strain KCOM2013 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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