metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA608660" 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
1860426	1860426	PRJNA608660_P_NODE_11922_length_430_cov_2.230971_g11575_i0	PRJNA608660	11922	430	2.230971	9.5931753	Leptotrichia wadei	157687	Bacteria	Bacteria	763	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g11575	i0	99.289	198.476744186047	422	3	98	0	1	422	2298807	2299228	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	85345	763	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
3135748	3135748	PRJNA608660_P_NODE_51063_length_152_cov_2.553398_g50706_i0	PRJNA608660	51063	152	2.553398	3.88116496	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	244	1.91e-60	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g50706	i0	99.259	335.315789473684	135	1	89	0	7	141	2873	2739	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	50968	244	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
4412223	4412223	PRJNA608660_P_NODE_22184_length_294_cov_2.510204_g21828_i0	PRJNA608660	22184	294	2.510204	7.37999976	Leptotrichia wadei	157687	Bacteria	Bacteria	460	3.82e-125	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g21828	i0	99.216	343.792517006803	255	2	88	0	7	261	2202765	2203019	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	101075	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4975085	4975085	PRJNA608660_P_NODE_37704_length_197_cov_1.837838_g37348_i0	PRJNA608660	37704	197	1.837838	3.62054086	Streptobacillus	34104	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g37348	i0	94.444	337.324873096447	198	9	100	2	1	197	2260	2064	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	66453	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
5688352	5688352	PRJNA608660_P_NODE_26365_length_259_cov_1.423810_g26009_i0	PRJNA608660	26365	259	1.42381	3.6876679	Leptotrichia shahii	157691	Bacteria	Bacteria	438	1.5499999999999996e-118	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g26009	i0	100	418.783783783784	237	0	93	0	13	249	95255	95019	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	108465	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
8799872	8799872	PRJNA608660_P_NODE_727_length_1231_cov_12.404399_g241_i1	PRJNA608660	727	1231	12.404399	152.69815169	Fusobacterium	848	Bacteria	Bacteria	2202	0	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g241	i1	99.182	493.93582453290003	1222	10	99	0	1	1222	2399235	2398014	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	608035	2218	0.992786293958521	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9513079	9513079	PRJNA608660_P_NODE_28408_length_245_cov_2.051020_g28052_i0	PRJNA608660	28408	245	2.05102	5.024999	uncultured Fusobacterium sp.	159267	Bacteria	Bacteria	416	6.809999999999998e-112	NTclustered	gi\|295646929\|gb\|GU902727.1\|	159267	g28052	i0	99.561	93.0612244897959	228	1	93	0	12	239	63	290	Uncultured Fusobacterium sp. clone PP209-b08 16S ribosomal RNA gene, partial sequence	blastn	22800	416	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	uncultured Fusobacterium sp.
9513299	9513299	PRJNA608660_P_NODE_7448_length_546_cov_3.786720_g7117_i0	PRJNA608660	7448	546	3.78672	20.6754912	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	833	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g7117	i0	94.934	433.981684981685	533	25	97	2	15	546	52172	51641	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	236954	833	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
12625894	12625894	PRJNA608660_P_NODE_18710_length_330_cov_2.302491_g18354_i0	PRJNA608660	18710	330	2.302491	7.5982203	Fusobacterium	848	Bacteria	Bacteria	544	4.1999999999999997e-150	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g18354	i0	99.01	434.375757575758	303	3	99	0	3	305	105963	105661	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	143344	544	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20987225	20987225	PRJNA608660_P_NODE_49397_length_162_cov_7.955752_g49040_i0	PRJNA608660	49397	162	7.955752	12.88831824	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	209	7.56e-50	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g49040	i0	91.503	419.314814814815	153	12	94	1	11	162	53730	53882	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	67929	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21548895	21548895	PRJNA608660_P_NODE_50237_length_159_cov_4.500000_g49880_i0	PRJNA608660	50237	159	4.5	7.155	Fusobacterium	848	Bacteria	Bacteria	248	1.5599999999999998e-61	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g49880	i0	100	447.522012578616	134	0	84	0	13	146	3422613	3422480	Fusobacterium varium strain SB069 chromosome	blastn	71156	248	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
22261829	22261829	PRJNA608660_P_NODE_32818_length_220_cov_1.216374_g32462_i0	PRJNA608660	32818	220	1.216374	2.6760228	Fusobacterium polymorphum	76857	Bacteria	Bacteria	285	1.7599999999999998e-72	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g32462	i0	94.565	84.5272727272727	184	10	84	0	37	220	898342	898525	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	18596	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23537108	23537108	PRJNA608660_P_NODE_2279_length_867_cov_19.953545_g2076_i0	PRJNA608660	2279	867	19.953545	172.99723515	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	824	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2076	i0	96.579	468.617070357555	497	17	98	0	361	857	52429	52925	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	406291	824	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23537248	23537248	PRJNA608660_P_NODE_38879_length_192_cov_2.622378_g38523_i0	PRJNA608660	38879	192	2.622378	5.03496576	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	309	8.890000000000001e-80	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g38523	i0	95.812	369.880208333333	191	8	99	0	2	192	53486	53296	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	71017	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24811085	24811085	PRJNA608660_P_NODE_39340_length_191_cov_1.098592_g38983_i0	PRJNA608660	39340	191	1.098592	2.09831072	Fusobacterium polymorphum	76857	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g38983	i0	100	99.8272251308901	191	0	100	0	1	191	174340	174530	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	19067	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
25373214	25373214	PRJNA608660_P_NODE_300_length_1592_cov_17.362929_g241_i0	PRJNA608660	300	1592	17.362929	276.41782968	Fusobacterium	848	Bacteria	Bacteria	2591	0	NTclustered	gi\|2705038125\|gb\|CP084158.1\|	851	g241	i0	98.7	449.277010050251	1462	15	92	3	133	1592	1990892	1992351	Fusobacterium nucleatum strain KCOM2312 chromosome, complete genome	blastn	715249	2608	0.993481595092024	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);;