metadata: contig_metadata: 16 rows where bioproject = "PRJNA599026" and tax

16 rows where bioproject = "PRJNA599026" 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
6245020	6245020	PRJNA599026_S_NODE_65265_length_163_cov_0.885965_g64809_i0	PRJNA599026	65265	163	0.885965	1.44412295	Leptotrichia	32067	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g64809	i0	100	8.70552147239264	157	0	96	0	1	157	1985220	1985376	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1419	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
8224993	8224993	PRJNA599026_S_NODE_51447_length_167_cov_0.864407_g50991_i0	PRJNA599026	51447	167	0.864407	1.44355969	Leptotrichia shahii	157691	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g50991	i0	99.401	11	167	1	100	0	1	167	1010462	1010628	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	1837	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
8225163	8225163	PRJNA599026_S_NODE_64847_length_163_cov_0.894737_g64391_i0	PRJNA599026	64847	163	0.894737	1.45842131	Cetobacterium	180162	Bacteria	Bacteria	107	1.23e-25	NR	WP_047381211.1	2630983	g64391	i0	98.1	1.98773006134969	54	1	99.4	0	162	1	24	77	WP_047381211.1 MULTISPECIES: methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [unclassified Cetobacterium]	diamond	324	107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
12051041	12051041	PRJNA599026_S_NODE_54210_length_166_cov_0.871795_g53754_i0	PRJNA599026	54210	166	0.871795	1.4471797	Cetobacterium somerae	188913	Bacteria	Bacteria	169	1.32e-37	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g53754	i0	87.248	1.81325301204819	149	17	89	1	1	147	1352645	1352793	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	301	169	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14600536	14600536	PRJNA599026_S_NODE_34692_length_191_cov_1.838028_g34236_i0	PRJNA599026	34692	191	1.838028	3.51063348	Cetobacterium somerae	188913	Bacteria	Bacteria	315	1.9e-81	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g34236	i0	96.335	16.020942408377	191	7	100	0	1	191	384952	384762	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3060	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17719249	17719249	PRJNA599026_S_NODE_8834_length_326_cov_2.425993_g8378_i0	PRJNA599026	8834	326	2.425993	7.90873718	Cetobacterium	180162	Bacteria	Bacteria	442	1.5599999999999995e-119	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g8378	i0	91.104	95.7177914110429	326	29	100	0	1	326	346470	346145	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	31204	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19698460	19698460	PRJNA599026_S_NODE_60076_length_164_cov_0.886957_g59620_i0	PRJNA599026	60076	164	0.886957	1.45460948	Leptotrichia buccalis	40542	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g59620	i0	99.39	1	164	1	100	0	1	164	401343	401180	Leptotrichia buccalis DSM 1135, complete genome	blastn	164	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
19698600	19698600	PRJNA599026_S_NODE_70136_length_161_cov_0.910714_g69680_i0	PRJNA599026	70136	161	0.910714	1.46624954	Leptotrichia wadei	157687	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g69680	i0	100	1	161	0	100	0	1	161	228957	228797	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	161	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
26872039	26872039	PRJNA599026_S_NODE_5201_length_418_cov_2.197832_g4746_i0	PRJNA599026	5201	418	2.197832	9.18693776	Cetobacterium	180162	Bacteria	Bacteria	111	2.07e-25	NR	WP_240220714.1	188913	g4746	i0	41.9	5.84928229665072	136	74	96.9	3	14	418	539	670	WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae]	diamond	2445	111	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27301226	27301226	PRJNA599026_S_NODE_64523_length_163_cov_0.894737_g64067_i0	PRJNA599026	64523	163	0.894737	1.45842131	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	107	1.7e-25	NR	WP_294096797.1	527638	g64067	i0	100	0.993865030674847	54	0	99.4	0	1	162	200	253	WP_294096797.1 ABC transporter substrate-binding protein [uncultured Cetobacterium sp.]	diamond	162	107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
27775020	27775020	PRJNA599026_S_NODE_60624_length_164_cov_0.886957_g60168_i0	PRJNA599026	60624	164	0.886957	1.45460948	unclassified Cetobacterium	2630983	Bacteria	Bacteria	107	3.03e-28	NR	WP_047383851.1	2630983	g60168	i0	96.3	0.98780487804878	54	2	98.8	0	163	2	50	103	WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	162	107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28893098	28893098	PRJNA599026_S_NODE_35908_length_189_cov_1.307143_g35452_i0	PRJNA599026	35908	189	1.307143	2.47050027	Cetobacterium	180162	Bacteria	Bacteria	48.9	1.2e-4	NR	WP_297599059.1	527638	g35452	i0	31.7	5	63	42	98.4	1	187	2	597	659	WP_297599059.1 glycosyl hydrolase family 18 protein [uncultured Cetobacterium sp.]	diamond	945	49.3	0.991886409736308	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
29398404	29398404	PRJNA599026_S_NODE_1429_length_783_cov_3.735695_g1103_i0	PRJNA599026	1429	783	3.735695	29.25049185	Bacteria	2	Bacteria	Bacteria	98.6	3.03e-19	NR	WP_281833196.1	45622	g1103	i0	55.8	5.59386973180077	86	31	31.8	2	253	5	519	600	WP_281833196.1 glycosyl hydrolase family 18 protein [Propionigenium maris]	diamond	4380	98.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Propionigenium	Propionigenium maris
30978012	30978012	PRJNA599026_S_NODE_134_length_1979_cov_6.703627_g80_i0	PRJNA599026	134	1979	6.703627	132.66477833	Cetobacterium	180162	Bacteria	Bacteria	424	5.53e-135	NR	WP_240220714.1	188913	g80	i0	64.9	2.36634663971703	313	105	47.4	3	1239	301	449	756	WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae]	diamond	4683	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
31470541	31470541	PRJNA599026_S_NODE_60956_length_164_cov_0.886957_g60500_i0	PRJNA599026	60956	164	0.886957	1.45460948	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	111	6.95e-27	NR	WP_294095512.1	527638	g60500	i0	100	0.98780487804878	54	0	98.8	0	3	164	597	650	WP_294095512.1 transcription-repair coupling factor [uncultured Cetobacterium sp.]	diamond	162	111	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
32829541	32829541	PRJNA599026_S_NODE_27800_length_207_cov_1.291139_g27344_i0	PRJNA599026	27800	207	1.291139	2.67265773	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	73.2	4.28e-13	NR	MBN1469292.1	2053555	g27344	i0	55.1	8.01449275362319	69	29	97.1	1	2	202	615	683	MBN1469292.1 endopeptidase La [Fusobacteriaceae bacterium]	diamond	1659	73.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium

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