metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA758087" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA758087" 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
2009104	2009104	PRJNA758087_P_NODE_15422_length_751_cov_61.423304_g14180_i0	PRJNA758087	15422	751	61.423304	461.28901304	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	1314	0	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g14180	i0	99.447	96.2929427430093	723	4	96	0	29	751	1205943	1205221	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	72316	1314	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
2009223	2009223	PRJNA758087_P_NODE_19302_length_631_cov_11.528674_g18003_i0	PRJNA758087	19302	631	11.528674	72.74593294	Leptotrichia wadei	157687	Bacteria	Bacteria	942	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g18003	i0	95.387	3.82725832012678	607	3	96	3	25	631	2366887	2366306	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	2415	942	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2009472	2009472	PRJNA758087_P_NODE_28422_length_438_cov_6.824658_g27102_i0	PRJNA758087	28422	438	6.824658	29.89200204	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	726	0	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g27102	i0	98.309	93.9109589041096	414	7	95	0	1	414	1395097	1394684	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	41133	726	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
2478176	2478176	PRJNA758087_P_NODE_36702_length_313_cov_1.283333_g35382_i0	PRJNA758087	36702	313	1.283333	4.01683229	Fusobacterium	848	Bacteria	Bacteria	536	6.629999999999999e-148	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g35382	i0	100	324.549520766773	290	0	93	0	24	313	187726	188015	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	101584	536	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
5837329	5837329	PRJNA758087_P_NODE_42785_length_246_cov_0.890173_g41465_i0	PRJNA758087	42785	246	0.890173	2.18982558	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	398	2.4799999999999997e-106	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g41465	i0	100	1.84552845528455	215	0	87	0	1	215	1543495	1543709	Leptotrichia sp. SK-5 DNA, complete genome	blastn	454	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
7111985	7111985	PRJNA758087_P_NODE_21706_length_573_cov_3.730000_g20392_i0	PRJNA758087	21706	573	3.73	21.3729	Sneathia vaginalis	187101	Bacteria	Bacteria	551	4.5699999999999985e-152	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g20392	i0	85.246	477.713787085515	549	66	95	14	3	544	160419	159879	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	273730	551	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
7112412	7112412	PRJNA758087_P_NODE_37366_length_304_cov_2.532468_g36046_i0	PRJNA758087	37366	304	2.532468	7.69870272	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	499	8.419999999999998e-137	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g36046	i0	99.635	199.611842105263	274	0	90	1	31	304	71908	71636	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	60682	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
8386501	8386501	PRJNA758087_P_NODE_19507_length_626_cov_3.743219_g18206_i0	PRJNA758087	19507	626	3.743219	23.43255094	Fusobacterium polymorphum	76857	Bacteria	Bacteria	1107	0	NTclustered	gi\|2704950824\|gb\|CP056007.1\|	76857	g18206	i0	99.834	96.1373801916933	602	1	96	0	1	602	572174	572775	Fusobacterium polymorphum strain SB013 chromosome, complete genome	blastn	60182	1107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13956741	13956741	PRJNA758087_P_NODE_39031_length_284_cov_2.189573_g37711_i0	PRJNA758087	39031	284	2.189573	6.21838732	Fusobacterium	848	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g37711	i0	100	100.915492957746	284	0	100	0	1	284	679496	679213	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	28660	525	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
21136165	21136165	PRJNA758087_P_NODE_35217_length_333_cov_2.396154_g33897_i0	PRJNA758087	35217	333	2.396154	7.97919282	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	440	5.729999999999999e-119	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g33897	i0	92.283	0.933933933933934	311	22	93	2	24	333	601351	601660	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	311	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22411012	22411012	PRJNA758087_P_NODE_36358_length_317_cov_4.028689_g35038_i0	PRJNA758087	36358	317	4.028689	12.77094413	Fusobacterium polymorphum	76857	Bacteria	Bacteria	538	1.87e-148	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g35038	i0	99.66	93.2271293375394	294	1	93	0	24	317	2229737	2229444	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	29553	538	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23686641	23686641	PRJNA758087_P_NODE_34719_length_340_cov_3.382022_g33399_i0	PRJNA758087	34719	340	3.382022	11.4988748	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	479	1.2399999999999999e-130	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g33399	i0	94.044	11.7264705882353	319	14	94	4	22	340	144584	144897	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	3987	479	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24959629	24959629	PRJNA758087_P_NODE_15520_length_748_cov_17.534815_g14276_i0	PRJNA758087	15520	748	17.534815	131.1604162	Fusobacterium animalis	76859	Bacteria	Bacteria	455	4.8900000000000005e-123	NTclustered	gi\|2704881042\|gb\|CP056003.1\|	76859	g14276	i0	78.442	95.557486631016	719	140	96	10	32	747	943080	943786	Fusobacterium animalis strain SB018 chromosome, complete genome	blastn	71477	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
24960280	24960280	PRJNA758087_P_NODE_40620_length_264_cov_2.649215_g39300_i0	PRJNA758087	40620	264	2.649215	6.9939276	Leptotrichia wadei	157687	Bacteria	Bacteria	427	3.43e-115	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g39300	i0	99.573	3.64772727272727	234	1	89	0	1	234	307110	306877	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	963	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei

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