metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA613025" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA613025" 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
592020	592020	PRJNA613025_S_NODE_33341_length_162_cov_0.902655_g33187_i0	PRJNA613025	33341	162	0.902655	1.4623011	Cetobacterium somerae	188913	Bacteria	Bacteria	233	4.49e-57	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g33187	i0	93.082	4.90740740740741	159	11	98	0	1	159	1816568	1816726	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	795	233	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1148837	1148837	PRJNA613025_S_NODE_19641_length_223_cov_1.448276_g19487_i0	PRJNA613025	19641	223	1.448276	3.22965548	Cetobacterium	180162	Bacteria	Bacteria	379	7.999999999999999e-101	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g19487	i0	97.309	27.7757847533632	223	6	100	0	1	223	1902530	1902752	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6194	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3142865	3142865	PRJNA613025_S_NODE_33183_length_162_cov_0.902655_g33029_i0	PRJNA613025	33183	162	0.902655	1.4623011	Fusobacterium gastrosuis	1755100	Bacteria	Bacteria	130	6.05e-26	NTclustered	gi\|1795735174\|emb\|LT607734.1\|	1755100	g33029	i0	82.759	0.895061728395062	145	25	90	0	18	162	57888	58032	Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr	blastn	145	130	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis
3700410	3700410	PRJNA613025_S_NODE_23063_length_199_cov_1.360000_g22909_i0	PRJNA613025	23063	199	1.36	2.7064	Cetobacterium	180162	Bacteria	Bacteria	324	3.31e-84	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g22909	i0	95.98	5	199	8	100	0	1	199	481035	480837	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	995	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3700416	3700416	PRJNA613025_S_NODE_23403_length_197_cov_1.378378_g23249_i0	PRJNA613025	23403	197	1.378378	2.71540466	Cetobacterium	180162	Bacteria	Bacteria	294	2.57e-75	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g23249	i0	93.846	79.7817258883249	195	12	99	0	3	197	1897256	1897450	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	15717	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8245092	8245092	PRJNA613025_S_NODE_33167_length_162_cov_0.902655_g33013_i0	PRJNA613025	33167	162	0.902655	1.4623011	Cetobacterium somerae	188913	Bacteria	Bacteria	259	7.400000000000001e-65	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33013	i0	95.652	5.90740740740741	161	7	99	0	1	161	1234092	1233932	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	957	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10077372	10077372	PRJNA613025_S_NODE_32988_length_162_cov_1.353982_g32834_i0	PRJNA613025	32988	162	1.353982	2.19345084	Cetobacterium	180162	Bacteria	Bacteria	222	9.709999999999999e-54	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g32834	i0	91.975	7.03086419753086	162	8	100	3	1	162	1913210	1913054	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1139	222	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11352188	11352188	PRJNA613025_S_NODE_15669_length_269_cov_1.150000_g15515_i0	PRJNA613025	15669	269	1.15	3.0935	Cetobacterium	180162	Bacteria	Bacteria	436	5.819999999999999e-118	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15515	i0	95.911	18	269	11	100	0	1	269	1913659	1913927	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4842	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11352190	11352190	PRJNA613025_S_NODE_16149_length_261_cov_2.099057_g15995_i0	PRJNA613025	16149	261	2.099057	5.47853877	Cetobacterium	180162	Bacteria	Bacteria	383	7.43e-102	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15995	i0	93.156	6.83141762452107	263	15	100	3	1	261	1861424	1861685	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1783	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13902679	13902679	PRJNA613025_S_NODE_16951_length_251_cov_1.767327_g16797_i0	PRJNA613025	16951	251	1.767327	4.43599077	Cetobacterium	180162	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g16797	i0	91.235	194.059760956175	251	22	100	0	1	251	1630411	1630661	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	48709	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16451527	16451527	PRJNA613025_S_NODE_16713_length_254_cov_1.346341_g16559_i0	PRJNA613025	16713	254	1.346341	3.41970614	Cetobacterium	180162	Bacteria	Bacteria	333	7.35e-87	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16559	i0	93.333	65.7716535433071	225	15	89	0	30	254	1899190	1898966	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	16706	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16451563	16451563	PRJNA613025_S_NODE_20493_length_216_cov_1.221557_g20339_i0	PRJNA613025	20493	216	1.221557	2.63856312	Cetobacterium	180162	Bacteria	Bacteria	364	2.16e-96	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20339	i0	98.086	7.78240740740741	209	4	97	0	8	216	1906792	1907000	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1681	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16451569	16451569	PRJNA613025_S_NODE_21053_length_212_cov_0.932515_g20899_i0	PRJNA613025	21053	212	0.932515	1.9769318	Cetobacterium	180162	Bacteria	Bacteria	381	2.0899999999999994e-101	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20899	i0	99.057	29.0566037735849	212	2	100	0	1	212	1900978	1901189	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6160	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17726630	17726630	PRJNA613025_S_NODE_17714_length_242_cov_1.575130_g17560_i0	PRJNA613025	17714	242	1.57513	3.8118146	Cetobacterium	180162	Bacteria	Bacteria	403	5.22e-108	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g17560	i0	96.694	19.0082644628099	242	8	100	0	1	242	1902974	1902733	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4600	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17726637	17726637	PRJNA613025_S_NODE_18174_length_237_cov_1.627660_g18020_i0	PRJNA613025	18174	237	1.62766	3.8575542	Cetobacterium	180162	Bacteria	Bacteria	388	1.43e-103	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18020	i0	96.203	17.6793248945148	237	9	100	0	1	237	1904168	1903932	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4190	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17726789	17726789	PRJNA613025_S_NODE_33854_length_161_cov_0.910714_g33700_i0	PRJNA613025	33854	161	0.910714	1.46624954	Cetobacterium	180162	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33700	i0	99.379	5	161	1	100	0	1	161	1914162	1914322	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	805	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18443952	18443952	PRJNA613025_S_NODE_28615_length_172_cov_1.658537_g28461_i0	PRJNA613025	28615	172	1.658537	2.85268364	Cetobacterium somerae	188913	Bacteria	Bacteria	274	2.83e-69	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g28461	i0	95.349	17.9127906976744	172	8	100	0	1	172	1948538	1948709	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3081	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19000171	19000171	PRJNA613025_S_NODE_16855_length_252_cov_1.960591_g16701_i0	PRJNA613025	16855	252	1.960591	4.94068932	Cetobacterium	180162	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g16701	i0	98.024	5.01984126984127	253	4	100	1	1	252	435259	435511	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1265	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21550781	21550781	PRJNA613025_S_NODE_34277_length_157_cov_2.833333_g34123_i0	PRJNA613025	34277	157	2.833333	4.44833281	Cetobacterium	180162	Bacteria	Bacteria	268	1.1799999999999998e-67	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g34123	i0	97.452	10.9617834394904	157	4	100	0	1	157	1664625	1664469	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1721	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24100693	24100693	PRJNA613025_S_NODE_29719_length_168_cov_1.285714_g29565_i0	PRJNA613025	29719	168	1.285714	2.15999952	Cetobacterium	180162	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g29565	i0	97.024	6	168	5	100	0	1	168	1909051	1908884	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1008	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25375103	25375103	PRJNA613025_S_NODE_21960_length_206_cov_0.974522_g21806_i0	PRJNA613025	21960	206	0.974522	2.00751532	Cetobacterium	180162	Bacteria	Bacteria	324	3.46e-84	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g21806	i0	95.122	4.97572815533981	205	10	99	0	1	205	1219506	1219710	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1025	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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