metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
4720769	4720769	PRJNA911178_P_NODE_216564_length_263_cov_1.157895_g214090_i0	PRJNA911178	216564	263	1.157895	3.04526385	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g214090	i0	99.62	461.927756653992	263	1	100	0	1	263	52716	52454	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	121487	481	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
5995363	5995363	PRJNA911178_P_NODE_200385_length_271_cov_2.717172_g197911_i0	PRJNA911178	200385	271	2.717172	7.36353612	Leptotrichia wadei	157687	Bacteria	Bacteria	486	5.7499999999999985e-133	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g197911	i0	99.624	231.250922509225	266	1	98	0	6	271	221341	221606	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	62669	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
5996404	5996404	PRJNA911178_P_NODE_45985_length_509_cov_2.350917_g43560_i0	PRJNA911178	45985	509	2.350917	11.96616753	Leptotrichia hofstadii	157688	Bacteria	Bacteria	924	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g43560	i0	99.411	367.157170923379	509	3	100	0	1	509	577118	577626	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	186883	924	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
8545173	8545173	PRJNA911178_P_NODE_218247_length_262_cov_1.253968_g215773_i0	PRJNA911178	218247	262	1.253968	3.28539616	Leptotrichia buccalis	40542	Bacteria	Bacteria	462	9.319999999999999e-126	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g215773	i0	98.842	228.358778625954	259	3	99	0	4	262	119062	119320	Leptotrichia buccalis DSM 1135, complete genome	blastn	59830	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
9819637	9819637	PRJNA911178_P_NODE_156248_length_299_cov_2.185841_g153775_i0	PRJNA911178	156248	299	2.185841	6.53566459	Leptotrichia shahii	157691	Bacteria	Bacteria	514	2.95e-141	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g153775	i0	97.659	446.565217391304	299	7	100	0	1	299	96078	96376	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	133523	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
11094993	11094993	PRJNA911178_P_NODE_121969_length_332_cov_4.285714_g119497_i0	PRJNA911178	121969	332	4.285714	14.22857048	Leptotrichia wadei	157687	Bacteria	Bacteria	599	8.909999999999998e-167	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g119497	i0	99.694	464.503012048193	327	1	98	0	6	332	1694883	1694557	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	154215	599	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
11095632	11095632	PRJNA911178_P_NODE_198849_length_272_cov_1.969849_g196376_i0	PRJNA911178	198849	272	1.969849	5.35798928	Fusobacterium polymorphum	76857	Bacteria	Bacteria	473	4.4899999999999996e-129	NTclustered	gi\|2706435836\|gb\|CP077154.1\|	76857	g196376	i0	98.507	108.628676470588	268	4	99	0	1	268	1044042	1044309	Fusobacterium polymorphum strain KCOM1267 chromosome, complete genome	blastn	29547	473	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11096923	11096923	PRJNA911178_P_NODE_71769_length_416_cov_3.877551_g69306_i0	PRJNA911178	71769	416	3.877551	16.13061216	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	752	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g69306	i0	99.756	275.899038461538	410	1	99	0	6	415	52861	53270	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	114774	752	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11454622	11454622	PRJNA911178_P_NODE_98049_length_364_cov_1.975945_g95579_i0	PRJNA911178	98049	364	1.975945	7.1924398	Fusobacterium	848	Bacteria	Bacteria	660	0	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g95579	i0	99.722	342.917582417582	360	1	99	0	5	364	111707	112066	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	124822	660	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13646222	13646222	PRJNA911178_P_NODE_256131_length_248_cov_0.880000_g253657_i0	PRJNA911178	256131	248	0.88	2.1824	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	370	5.45e-98	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g253657	i0	93.878	44.9112903225806	245	15	99	0	4	248	1690079	1690323	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	11138	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
16551933	16551933	PRJNA911178_P_NODE_105233_length_353_cov_7.871429_g102761_i0	PRJNA911178	105233	353	7.871429	27.78614437	Fusobacterium	848	Bacteria	Bacteria	645	1.2e-180	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g102761	i0	100	346.263456090652	349	0	99	0	5	353	459851	460199	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	122231	645	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
18743405	18743405	PRJNA911178_P_NODE_170035_length_289_cov_1.231481_g167562_i0	PRJNA911178	170035	289	1.231481	3.55898009	Fusobacterium polymorphum	76857	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2645859777\|gb\|CP141277.1\|	76857	g167562	i0	96.875	0.110726643598616	32	1	11	0	234	265	2134533	2134564	Fusobacterium polymorphum strain C48P chromosome, complete genome	blastn	32	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
20018329	20018329	PRJNA911178_P_NODE_159036_length_297_cov_1.357143_g156563_i0	PRJNA911178	159036	297	1.357143	4.03071471	Leptotrichia wadei	157687	Bacteria	Bacteria	529	1.0499999999999996e-145	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g156563	i0	98.983	417.474747474747	295	3	99	0	1	295	221367	221073	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	123990	529	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21294212	21294212	PRJNA911178_P_NODE_218917_length_261_cov_2.521277_g216443_i0	PRJNA911178	218917	261	2.521277	6.58053297	Leptotrichia wadei	157687	Bacteria	Bacteria	431	2.62e-116	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g216443	i0	97.984	417.026819923372	248	5	95	0	3	250	222514	222267	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	108844	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21652925	21652925	PRJNA911178_P_NODE_85237_length_386_cov_3.517572_g82769_i0	PRJNA911178	85237	386	3.517572	13.57782792	Fusobacterium	848	Bacteria	Bacteria	691	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g82769	i0	99.735	466.033678756477	377	1	98	0	9	385	153	529	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	179889	697	0.991391678622669	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24201543	24201543	PRJNA911178_P_NODE_20879_length_736_cov_3.407240_g18676_i0	PRJNA911178	20879	736	3.40724	25.0772864	Leptotrichia	32067	Bacteria	Bacteria	1218	0	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g18676	i0	96.744	458.520380434783	737	13	99	7	4	735	2244414	2243684	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	337471	1219	0.999179655455291	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25477415	25477415	PRJNA911178_P_NODE_9480_length_1078_cov_4.705473_g7910_i0	PRJNA911178	9480	1078	4.705473	50.72499894	Leptotrichia	32067	Bacteria	Bacteria	1685	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g7910	i0	94.907	459.730055658627	1080	50	99	4	1	1077	1099	22	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	495589	1701	0.990593768371546	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis

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