metadata: contig_metadata: 9 rows where bioproject = "PRJEB48218" and tax

9 rows where bioproject = "PRJEB48218" 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
2612273	2612273	PRJEB48218_S_NODE_11183_length_269_cov_4.079167_g10221_i0	PRJEB48218	11183	269	4.079167	10.97295923	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g10221	i0	100	382.895910780669	269	0	100	0	1	269	197254	197522	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	102999	497	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
5165143	5165143	PRJEB48218_S_NODE_6625_length_386_cov_8.159664_g5663_i0	PRJEB48218	6625	386	8.159664	31.49630304	Fusobacterium polymorphum	76857	Bacteria	Bacteria	713	0	NTclustered	gi\|2706496642\|gb\|CP084152.1\|	76857	g5663	i0	100	493.015544041451	386	0	100	0	1	386	754350	753965	Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome	blastn	190304	713	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6440805	6440805	PRJEB48218_S_NODE_3566_length_655_cov_6053.963259_g2729_i0	PRJEB48218	3566	655	6053.963259	39653.45934645	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	952	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2729	i0	98.694	317.665648854962	536	7	82	0	2	537	52118	51583	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	208071	952	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
16293215	16293215	PRJEB48218_S_NODE_8793_length_313_cov_7.612676_g7831_i0	PRJEB48218	8793	313	7.6126760000000004	23.82767588	Fusobacterium	848	Bacteria	Bacteria	579	1.0899999999999999e-160	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g7831	i0	100	471.670926517572	313	0	100	0	1	313	1932978	1932666	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	147633	579	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
17914183	17914183	PRJEB48218_S_NODE_30275_length_151_cov_4.344262_g29313_i0	PRJEB48218	30275	151	4.344262	6.55983562	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	255	8.75e-64	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g29313	i0	97.973	216.417218543046	148	2	98	1	4	151	53040	52894	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	32679	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
18842157	18842157	PRJEB48218_S_NODE_6855_length_376_cov_1200.685879_g5893_i0	PRJEB48218	6855	376	1200.6858790000001	4514.57890504	Fusobacterium	848	Bacteria	Bacteria	501	2.96e-137	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g5893	i0	100	316.207446808511	271	0	72	0	1	271	308	38	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	118894	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20116958	20116958	PRJEB48218_S_NODE_30016_length_152_cov_3.455285_g29054_i0	PRJEB48218	30016	152	3.455285	5.2520332	Leptotrichia	32067	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g29054	i0	100	463.756578947368	152	0	100	0	1	152	2454858	2454707	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	70491	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20463555	20463555	PRJEB48218_S_NODE_3577_length_653_cov_6067.713141_g2740_i0	PRJEB48218	3577	653	6067.713141	39622.16681073	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	981	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g2740	i0	99.813	256.779479326187	534	1	82	0	2	535	197200	196667	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	167677	981	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
23942824	23942824	PRJEB48218_S_NODE_8019_length_334_cov_961.032787_g7057_i0	PRJEB48218	8019	334	961.032787	3209.84950858	Fusobacterium	848	Bacteria	Bacteria	442	1.5999999999999994e-119	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g7057	i0	100	342.035928143713	239	0	72	0	1	239	465231	464993	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	114240	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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