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

14 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
1726586	1726586	PRJNA492280_P_NODE_1022_length_435_cov_10.118090_g924_i0	PRJNA492280	1022	435	10.11809	44.0136915	Cetobacterium somerae	188913	Bacteria	Bacteria	496	1.61e-135	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g924	i0	97.902	308.471264367816	286	6	98	0	150	435	1318691	1318976	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	134185	496	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1726611	1726611	PRJNA492280_P_NODE_12402_length_164_cov_6.590551_g12295_i0	PRJNA492280	12402	164	6.590551	10.80850364	Leptotrichia alba	3239304	Bacteria	Bacteria	137	3.67e-28	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g12295	i0	100	9.38414634146342	74	0	89	0	90	163	2136529	2136602	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	1539	137	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
1726902	1726902	PRJNA492280_P_NODE_8162_length_185_cov_4.000000_g8055_i0	PRJNA492280	8162	185	4	7.4	Leptotrichia shahii	157691	Bacteria	Bacteria	315	1.8199999999999998e-81	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g8055	i0	97.312	104.551351351351	186	4	100	1	1	185	1942492	1942677	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	19342	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
10027175	10027175	PRJNA492280_P_NODE_20308_length_164_cov_3.283465_g20201_i0	PRJNA492280	20308	164	3.283465	5.3848826	Fusobacterium	848	Bacteria	Bacteria	134	4.75e-27	NTclustered	gi\|13447133\|gb\|AF342849.1\|	850	g20201	i0	98.684	133.890243902439	76	0	92	1	1	75	405	480	Fusobacterium mortiferum strain ATCC 25557 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21958	135	0.992592592592593	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
11301961	11301961	PRJNA492280_P_NODE_10089_length_169_cov_5.401515_g9982_i0	PRJNA492280	10089	169	5.401515	9.12856035	Cetobacterium	180162	Bacteria	Bacteria	259	7.75e-65	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g9982	i0	95.122	478.899408284024	164	8	97	0	5	168	280560	280723	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	80934	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15127093	15127093	PRJNA492280_P_NODE_5412_length_220_cov_6.830601_g5305_i0	PRJNA492280	5412	220	6.830601	15.0273222	Fusobacterium	848	Bacteria	Bacteria	370	4.74e-98	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g5305	i0	99.034	456.772727272727	207	1	94	1	13	219	462833	463038	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	100490	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
15754486	15754486	PRJNA492280_P_NODE_13573_length_164_cov_5.322835_g13466_i0	PRJNA492280	13573	164	5.322835	8.7294494	Cetobacterium somerae	188913	Bacteria	Bacteria	104	3.73e-18	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g13466	i0	92.958	2.16463414634146	71	5	43	0	91	161	556294	556224	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	355	104	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16401687	16401687	PRJNA492280_P_NODE_6873_length_199_cov_2.691358_g6766_i0	PRJNA492280	6873	199	2.691358	5.35580242	Fusobacteriaceae	203492	Bacteria	Bacteria	363	7.019999999999998e-96	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g6766	i0	100	513.130653266332	196	0	98	0	4	199	157870	158065	Fusobacterium varium strain SB069 chromosome	blastn	102113	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
18303601	18303601	PRJNA492280_P_NODE_2495_length_295_cov_9.519380_g2388_i0	PRJNA492280	2495	295	9.51938	28.082171	Leptotrichia shahii	157691	Bacteria	Bacteria	529	1.0399999999999996e-145	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g2388	i0	99.315	490.772881355932	292	2	99	0	4	295	94899	95190	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	144778	529	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
18303783	18303783	PRJNA492280_P_NODE_8395_length_183_cov_4.000000_g8288_i0	PRJNA492280	8395	183	4	7.32	Fusobacterium animalis	76859	Bacteria	Bacteria	309	8.38e-80	NTclustered	gi\|2707729169\|gb\|CP077173.1\|	76859	g8288	i0	97.765	478.311475409836	179	4	98	0	2	180	1259687	1259865	Fusobacterium animalis strain SB041 chromosome, complete genome	blastn	87531	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
18950554	18950554	PRJNA492280_P_NODE_33215_length_150_cov_4.309735_g33108_i0	PRJNA492280	33215	150	4.309735	6.4646025	Cetobacterium	180162	Bacteria	Bacteria	261	1.86e-65	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33108	i0	99.31	4.9133333333333304	145	0	96	1	4	147	86416	86272	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	737	261	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20853756	20853756	PRJNA492280_P_NODE_3737_length_254_cov_7.419355_g3630_i0	PRJNA492280	3737	254	7.419355	18.8451617	Leptotrichia shahii	157691	Bacteria	Bacteria	315	2.66e-81	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g3630	i0	98.864	122.830708661417	176	2	69	0	4	179	105461	105286	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	31199	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
20853797	20853797	PRJNA492280_P_NODE_737_length_507_cov_10.938298_g648_i0	PRJNA492280	737	507	10.938298	55.45717086	Leptotrichia shahii	157691	Bacteria	Bacteria	891	0	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g648	i0	98.802	388.4516765286	501	4	99	1	4	504	105461	104963	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	196945	891	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
22776006	22776006	PRJNA492280_P_NODE_28218_length_157_cov_3.016667_g28111_i0	PRJNA492280	28218	157	3.016667	4.73616719	Leptotrichia	32067	Bacteria	Bacteria	180	5.699999999999998e-41	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g28111	i0	87.5	468.815286624204	160	14	100	5	1	157	178140	177984	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	73604	180	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii

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