metadata: contig_metadata: 18 rows where bioproject = "PRJNA600413" and tax

18 rows where bioproject = "PRJNA600413" 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
572717	572717	PRJNA600413_P_NODE_101041_length_167_cov_2.576271_g100340_i0	PRJNA600413	101041	167	2.576271	4.30237257	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	235	1.3e-57	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g100340	i0	97.794	1.1497005988024	136	3	81	0	32	167	1354755	1354890	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	192	235	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
573315	573315	PRJNA600413_P_NODE_142941_length_162_cov_0.902655_g142240_i0	PRJNA600413	142941	162	0.902655	1.4623011	Leptotrichia buccalis	40542	Bacteria	Bacteria	287	3.39e-73	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g142240	i0	98.758	4.99382716049383	161	2	99	0	1	161	784396	784556	Leptotrichia buccalis DSM 1135, complete genome	blastn	809	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
4400960	4400960	PRJNA600413_P_NODE_138904_length_162_cov_0.902655_g138203_i0	PRJNA600413	138904	162	0.902655	1.4623011	Fusobacterium vincentii	155615	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2707709886\|gb\|CP077168.1\|	155615	g138203	i0	100	98.7592592592593	159	0	98	0	4	162	100959	100801	Fusobacterium vincentii strain SB046 chromosome, complete genome	blastn	15999	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
4401187	4401187	PRJNA600413_P_NODE_152904_length_158_cov_2.467890_g152203_i0	PRJNA600413	152904	158	2.46789	3.8992662	Leptotrichia wadei	157687	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g152203	i0	100	8.77215189873418	158	0	100	0	1	158	375005	375162	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	1386	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
6951189	6951189	PRJNA600413_P_NODE_112826_length_166_cov_0.871795_g112125_i0	PRJNA600413	112826	166	0.871795	1.4471797	Fusobacterium polymorphum	76857	Bacteria	Bacteria	287	3.5e-73	NTclustered	gi\|2673502234\|gb\|CP144257.1\|	76857	g112125	i0	98.171	48.5602409638554	164	3	99	0	3	166	2333082	2333245	Fusobacterium polymorphum strain IOOS_98 chromosome	blastn	8061	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6951292	6951292	PRJNA600413_P_NODE_119826_length_165_cov_0.879310_g119125_i0	PRJNA600413	119826	165	0.87931	1.4508615	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g119125	i0	98.182	81.7757575757576	165	3	100	0	1	165	294309	294145	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	13493	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
8228336	8228336	PRJNA600413_P_NODE_82647_length_178_cov_1.581395_g81946_i0	PRJNA600413	82647	178	1.581395	2.8148831	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	291	2.93e-74	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g81946	i0	96.067	1.21910112359551	178	7	100	0	1	178	1558407	1558230	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	217	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8795321	8795321	PRJNA600413_P_NODE_70427_length_186_cov_1.489051_g69726_i0	PRJNA600413	70427	186	1.489051	2.76963486	Fusobacterium	848	Bacteria	Bacteria	339	1.0899999999999998e-88	NTclustered	gi\|2706038927\|gb\|CP056017.1\|	76857	g69726	i0	99.462	17	186	1	100	0	1	186	272095	272280	Fusobacterium polymorphum strain SB009 chromosome, complete genome	blastn	3162	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9501420	9501420	PRJNA600413_P_NODE_114948_length_165_cov_2.362069_g114247_i0	PRJNA600413	114948	165	2.362069	3.89741385	Leptotrichia mesophila	3239303	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g114247	i0	96.97	10	165	5	100	0	1	165	1578778	1578614	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	1650	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
10777763	10777763	PRJNA600413_P_NODE_147869_length_161_cov_0.910714_g147168_i0	PRJNA600413	147869	161	0.910714	1.46624954	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g147168	i0	99.379	247.962732919255	161	1	100	0	1	161	1060411	1060251	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	39922	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12054676	12054676	PRJNA600413_P_NODE_99450_length_168_cov_1.899160_g98749_i0	PRJNA600413	99450	168	1.89916	3.1905888	Fusobacterium polymorphum	76857	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g98749	i0	100	497.940476190476	168	0	100	0	1	168	632753	632920	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	83654	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15877862	15877862	PRJNA600413_P_NODE_77173_length_181_cov_2.651515_g76472_i0	PRJNA600413	77173	181	2.651515	4.79924215	Fusobacterium polymorphum	76857	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|2673502234\|gb\|CP144257.1\|	76857	g76472	i0	100	99.2044198895028	181	0	100	0	1	181	265014	265194	Fusobacterium polymorphum strain IOOS_98 chromosome	blastn	17956	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18424681	18424681	PRJNA600413_P_NODE_100075_length_168_cov_1.613445_g99374_i0	PRJNA600413	100075	168	1.613445	2.7105876	Leptotrichia buccalis	40542	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g99374	i0	98.788	8.91071428571429	165	2	98	0	4	168	287375	287211	Leptotrichia buccalis DSM 1135, complete genome	blastn	1497	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
19699484	19699484	PRJNA600413_P_NODE_115496_length_165_cov_1.758621_g114795_i0	PRJNA600413	115496	165	1.758621	2.90172465	Leptotrichia wadei	157687	Bacteria	Bacteria	222	9.939999999999999e-54	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g114795	i0	91.824	9.64848484848485	159	13	96	0	7	165	1309967	1310125	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1592	222	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19701748	19701748	PRJNA600413_P_NODE_84016_length_177_cov_1.593750_g83315_i0	PRJNA600413	84016	177	1.59375	2.8209375	Leptotrichia alba	3239304	Bacteria	Bacteria	298	1.74e-76	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g83315	i0	97.175	2	177	4	100	1	1	177	1945697	1945872	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	354	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
27617127	27617127	PRJNA600413_P_NODE_119884_length_165_cov_0.879310_g119183_i0	PRJNA600413	119884	165	0.87931	1.4508615	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	106	2.86e-25	NR	WP_047384826.1	1340502	g119183	i0	100	1.92727272727273	53	0	96.4	0	5	163	381	433	WP_047384826.1 aminopeptidase [Cetobacterium sp. ZWU0022]	diamond	318	106	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
31216989	31216989	PRJNA600413_P_NODE_96455_length_170_cov_1.429752_g95754_i0	PRJNA600413	96455	170	1.429752	2.4305784	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	63.9	6.64e-11	NR	WP_053392652.1	712357	g95754	i0	79.6	0.864705882352941	49	8	86.5	2	169	23	27	73	WP_053392652.1 FAD-I family protein [Leptotrichia sp. oral taxon 212]	diamond	147	63.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
32419554	32419554	PRJNA600413_P_NODE_43299_length_221_cov_1.186047_g42598_i0	PRJNA600413	43299	221	1.186047	2.62116387	unclassified Cetobacterium	2630983	Bacteria	Bacteria	153	1.1e-44	NR	WP_047383820.1	2630983	g42598	i0	100	0.990950226244344	73	0	99.1	0	220	2	177	249	WP_047383820.1 MULTISPECIES: thiamine pyrophosphate-dependent enzyme [unclassified Cetobacterium]	diamond	219	153	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium

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