metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA591127" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA591127" 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
564996	564996	PRJNA591127_P_NODE_1021_length_644_cov_7.268534_g889_i0	PRJNA591127	1021	644	7.268534	46.80935896	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	974	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g889	i0	93.963	397.453416149068	646	35	99	4	2	644	52467	51823	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	255960	974	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4392535	4392535	PRJNA591127_P_NODE_2024_length_487_cov_9.280000_g1866_i0	PRJNA591127	2024	487	9.28	45.193600000000004	Sneathia vaginalis	187101	Bacteria	Bacteria	837	0	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g1866	i0	97.737	487.722792607803	486	11	99	0	1	486	161812	162297	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	237521	837	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
4392544	4392544	PRJNA591127_P_NODE_21624_length_191_cov_1.675325_g21455_i0	PRJNA591127	21624	191	1.675325	3.19987075	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	326	8.77e-85	NTclustered	gi\|1139272625\|emb\|LT686821.1\|	159271	g21455	i0	97.382	112.041884816754	191	5	100	0	1	191	57	247	Uncultured Leptotrichia sp. partial 16S rRNA gene, isolate V2T_12236	blastn	21400	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
6943254	6943254	PRJNA591127_P_NODE_23506_length_178_cov_1.297872_g23337_i0	PRJNA591127	23506	178	1.297872	2.31021216	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	294	2.27e-75	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g23337	i0	96.629	20	178	5	100	1	1	178	593982	593806	Leptotrichia sp. oral taxon 498, complete genome	blastn	3560	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
13319062	13319062	PRJNA591127_P_NODE_271_length_1054_cov_10.946903_g79_i1	PRJNA591127	271	1054	10.946903	115.38035762	Leptotrichia wadei	157687	Bacteria	Bacteria	1644	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g79	i1	94.877	446.265654648956	1054	51	100	3	1	1054	1757307	1756257	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	470364	1644	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18416952	18416952	PRJNA591127_P_NODE_275_length_1051_cov_14.052268_g79_i2	PRJNA591127	275	1051	14.052268	147.68933668	Leptotrichia wadei	157687	Bacteria	Bacteria	1781	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g79	i2	97.241	445.315889628925	1051	29	100	0	1	1051	1756257	1757307	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	468027	1781	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18417020	18417020	PRJNA591127_P_NODE_4535_length_341_cov_9.835526_g4367_i0	PRJNA591127	4535	341	9.835526	33.53914366	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	542	1.57e-149	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4367	i0	95.562	453.114369501466	338	15	100	0	1	338	52260	52597	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	154512	542	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19691391	19691391	PRJNA591127_P_NODE_1456_length_560_cov_9.437859_g1307_i0	PRJNA591127	1456	560	9.437859	52.8520104	Leptotrichia wadei	157687	Bacteria	Bacteria	889	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g1307	i0	95.374	425.321428571429	562	21	100	4	1	560	2298439	2298997	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	238180	889	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
20967344	20967344	PRJNA591127_P_NODE_4057_length_359_cov_4.273292_g3889_i0	PRJNA591127	4057	359	4.273292	15.34111828	Leptotrichia hofstadii	157688	Bacteria	Bacteria	619	7.429999999999999e-173	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g3889	i0	97.772	185.16991643454	359	8	100	0	1	359	498041	497683	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	66476	619	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
22815877	22815877	PRJNA591127_P_NODE_13258_length_202_cov_1.327273_g13089_i0	PRJNA591127	13258	202	1.327273	2.68109146	Leptotrichia	32067	Bacteria	Bacteria	340	3.35e-89	NTclustered	gi\|1139273538\|emb\|LT687730.1\|	159271	g13089	i0	97.03	99.9653465346535	202	6	100	0	1	202	269	68	Uncultured Leptotrichia sp. partial 16S rRNA gene, isolate 188T_13145	blastn	20193	340	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
24791151	24791151	PRJNA591127_P_NODE_12980_length_204_cov_1.976048_g12811_i0	PRJNA591127	12980	204	1.976048	4.03113792	Sneathia vaginalis	187101	Bacteria	Bacteria	355	1.21e-93	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g12811	i0	98.039	203.186274509804	204	4	100	0	1	204	161360	161157	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	41450	355	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis

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