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

14 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
2480626	2480626	PRJNA763243_P_NODE_29442_length_310_cov_3.181435_g29096_i0	PRJNA763243	29442	310	3.181435	9.8624485	Fusobacterium	848	Bacteria	Bacteria	217	9.7e-52	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g29096	i0	100	433.622580645161	117	0	84	0	161	277	157294	157178	Fusobacterium varium strain SB069 chromosome	blastn	134423	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
2480633	2480633	PRJNA763243_P_NODE_30702_length_306_cov_13.433476_g30356_i0	PRJNA763243	30702	306	13.433476	41.10643656	Fusobacterium	848	Bacteria	Bacteria	540	5e-149	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g30356	i0	98.689	497.28431372549	305	3	99	1	1	305	156820	156517	Fusobacterium varium strain SB069 chromosome	blastn	152169	540	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
3295280	3295280	PRJNA763243_P_NODE_71223_length_214_cov_11.992908_g70877_i0	PRJNA763243	71223	214	11.992908	25.66482312	Fusobacterium perfoetens	852	Bacteria	Bacteria	357	3.5699999999999996e-94	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g70877	i0	96.744	141.579439252336	215	5	99	2	1	213	371	585	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30298	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
3756965	3756965	PRJNA763243_P_NODE_37843_length_282_cov_4.645933_g37497_i0	PRJNA763243	37843	282	4.645933	13.10153106	Fusobacterium	848	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g37497	i0	99.645	471.18085106383	282	1	100	0	1	282	23	304	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	132873	521	0.990403071017274	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3757110	3757110	PRJNA763243_P_NODE_72883_length_206_cov_69.233083_g72537_i0	PRJNA763243	72883	206	69.233083	142.62015098	Fusobacterium	848	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g72537	i0	100	97.5728155339806	201	0	98	0	3	203	1557871	1557671	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	20100	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7121754	7121754	PRJNA763243_P_NODE_28406_length_310_cov_8.105485_g28060_i0	PRJNA763243	28406	310	8.105485	25.1270035	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	324	5.56e-84	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g28060	i0	85.016	341.477419354839	307	41	99	4	1	307	3738	3437	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	105858	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
7583287	7583287	PRJNA763243_P_NODE_47806_length_259_cov_1.225806_g47460_i0	PRJNA763243	47806	259	1.225806	3.17483754	Streptobacillus	34104	Bacteria	Bacteria	222	1.6999999999999998e-53	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g47460	i0	85.446	363.583011583012	213	31	82	0	28	240	2230	2018	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	94168	222	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
14772193	14772193	PRJNA763243_P_NODE_39772_length_277_cov_4.450980_g39426_i0	PRJNA763243	39772	277	4.45098	12.3292146	uncultured Propionigenium sp.	259317	Bacteria	Bacteria	357	4.82e-94	NTclustered	gi\|453201797\|gb\|JQ999705.1\|	259317	g39426	i0	90	453.216606498195	280	23	100	4	1	277	419	142	Uncultured Propionigenium sp. clone GKJWQY101AW14Z 23S ribosomal RNA gene, partial sequence	blastn	125541	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Propionigenium	uncultured Propionigenium sp.
17322184	17322184	PRJNA763243_P_NODE_65474_length_236_cov_6.220859_g65128_i0	PRJNA763243	65474	236	6.220859	14.68122724	Fusobacteria bacterium ZRK30	2970471	Bacteria	Bacteria	132	2.64e-26	NTclustered	gi\|2284595238\|gb\|CP102405.1\|	2970471	g65128	i0	78.166	57.3347457627119	229	35	95	14	10	234	497541	497758	Fusobacteria bacterium ZRK30 chromosome 2, complete sequence	blastn	13531	132	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteria bacterium ZRK30
17782800	17782800	PRJNA763243_P_NODE_26594_length_315_cov_8.855372_g26248_i0	PRJNA763243	26594	315	8.855372	27.8944218	Fusobacterium	848	Bacteria	Bacteria	507	5.24e-139	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g26248	i0	96.721	498.8	305	9	97	1	4	308	337297	337600	Fusobacterium varium strain SB069 chromosome	blastn	157122	512	0.990234375	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
18594730	18594730	PRJNA763243_P_NODE_3155_length_760_cov_5.828239_g2879_i0	PRJNA763243	3155	760	5.828239	44.2946164	Fusobacterium polymorphum	76857	Bacteria	Bacteria	1173	0	NTclustered	gi\|2706501641\|gb\|CP084157.1\|	76857	g2879	i0	94.723	488.186842105263	758	35	99	5	1	757	435216	434463	Fusobacterium polymorphum strain KCOM2446 chromosome, complete genome	blastn	371022	1173	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19870701	19870701	PRJNA763243_P_NODE_66096_length_234_cov_13.273292_g65750_i0	PRJNA763243	66096	234	13.273292	31.05950328	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	429	8.289999999999998e-116	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g65750	i0	100	332.730769230769	232	0	99	0	1	232	1624332	1624563	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	77859	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
21146481	21146481	PRJNA763243_P_NODE_67837_length_229_cov_2.205128_g67491_i0	PRJNA763243	67837	229	2.205128	5.04974312	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	233	6.799999999999999e-57	NTclustered	gi\|2621717559\|emb\|OY775911.1\|	544433	g67491	i0	85.59	464.318777292576	229	25	98	5	5	229	1909924	1910148	MAG: uncultured Ilyobacter sp. isolate 988a6a11-b556-497a-8909-2adea115d691 genome assembly, chromosome: 1	blastn	106329	233	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
24969971	24969971	PRJNA763243_P_NODE_43440_length_268_cov_18.051282_g43094_i0	PRJNA763243	43440	268	18.051282	48.37743576	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g43094	i0	94.717	415.514925373134	265	14	99	0	1	265	53073	52809	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	111358	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212

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