metadata: contig_metadata: 12 rows where bioproject = "PRJNA1101048" and tax

12 rows where bioproject = "PRJNA1101048" and tax_phylum = "Fusobacteriota"

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
211221	211221	PRJNA1101048_P_NODE_8101_length_248_cov_0.891429_g8045_i0	PRJNA1101048	8101	248	0.891429	2.21074392	Leptotrichia buccalis	40542	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g8045	i0	96.996	53.0040322580645	233	7	94	0	7	239	2001055	2001287	Leptotrichia buccalis DSM 1135, complete genome	blastn	13145	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
1019776	1019776	PRJNA1101048_P_NODE_9021_length_243_cov_1.376471_g8965_i0	PRJNA1101048	9021	243	1.376471	3.34482453	Cetobacterium	180162	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g8965	i0	96.137	4.79423868312757	233	9	96	0	11	243	1913609	1913841	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1165	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2295314	2295314	PRJNA1101048_P_NODE_7122_length_252_cov_1.709497_g7066_i0	PRJNA1101048	7122	252	1.709497	4.30793244	Fusobacterium	848	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g7066	i0	100	49.7103174603175	252	0	100	0	1	252	2231864	2231613	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	12527	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
3570378	3570378	PRJNA1101048_P_NODE_7463_length_251_cov_0.876404_g7407_i0	PRJNA1101048	7463	251	0.876404	2.19977404	Fusobacterium	848	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g7407	i0	98.406	98.195219123506	251	4	100	0	1	251	846150	846400	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	24647	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14239977	14239977	PRJNA1101048_P_NODE_4612_length_296_cov_1.049327_g4556_i0	PRJNA1101048	4612	296	1.049327	3.10600792	Fusobacterium polymorphum	76857	Bacteria	Bacteria	497	2.9399999999999994e-136	NTclustered	gi\|2645882547\|gb\|CP141278.1\|	76857	g4556	i0	96.959	99.722972972973	296	9	100	0	1	296	2080976	2080681	Fusobacterium polymorphum strain 149A chromosome, complete genome	blastn	29518	497	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14239989	14239989	PRJNA1101048_P_NODE_8212_length_247_cov_0.896552_g8156_i0	PRJNA1101048	8212	247	0.896552	2.21448344	Fusobacterium vincentii	155615	Bacteria	Bacteria	375	1.1699999999999999e-99	NTclustered	gi\|2078814929\|gb\|CP071093.1\|	155615	g8156	i0	99.043	95.5263157894737	209	2	100	0	39	247	374265	374473	Fusobacterium vincentii strain THCT14A3 chromosome, complete genome	blastn	23595	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
16788348	16788348	PRJNA1101048_P_NODE_4494_length_299_cov_1.194690_g4438_i0	PRJNA1101048	4494	299	1.19469	3.5721231	Fusobacterium polymorphum	76857	Bacteria	Bacteria	477	3.8699999999999984e-130	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g4438	i0	100	86.7023411371238	258	0	86	0	9	266	1273806	1273549	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	25924	477	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18062902	18062902	PRJNA1101048_P_NODE_8075_length_248_cov_0.891429_g8019_i0	PRJNA1101048	8075	248	0.891429	2.21074392	Cetobacterium somerae	188913	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g8019	i0	94.606	6.24193548387097	241	11	96	2	8	246	1816387	1816627	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1548	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18871436	18871436	PRJNA1101048_P_NODE_5055_length_287_cov_1.074766_g4999_i0	PRJNA1101048	5055	287	1.074766	3.08457842	Cetobacterium	180162	Bacteria	Bacteria	366	8.34e-97	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4999	i0	96.804	41.4355400696864	219	7	76	0	69	287	1859742	1859524	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	11892	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18871437	18871437	PRJNA1101048_P_NODE_6015_length_268_cov_1.200000_g5959_i0	PRJNA1101048	6015	268	1.2	3.216	Cetobacterium	180162	Bacteria	Bacteria	230	1.0599999999999998e-55	NTclustered	gi\|2666490175\|gb\|CP143320.1\|	188913	g5959	i0	86.538	23.6231343283582	208	28	78	0	61	268	561629	561422	Cetobacterium somerae strain ceto plasmid p1, complete sequence	blastn	6331	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19337018	19337018	PRJNA1101048_P_NODE_5436_length_279_cov_1.412621_g5380_i0	PRJNA1101048	5436	279	1.412621	3.94121259	Cetobacterium somerae	188913	Bacteria	Bacteria	351	2.26e-92	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g5380	i0	89.362	5.05376344086022	282	27	100	2	1	279	1818418	1818699	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1410	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24437098	24437098	PRJNA1101048_P_NODE_5320_length_281_cov_1.500000_g5264_i0	PRJNA1101048	5320	281	1.5	4.215	Leptotrichia buccalis	40542	Bacteria	Bacteria	501	2.14e-137	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g5264	i0	99.281	2.7900355871886098	278	1	99	1	2	278	2355505	2355228	Leptotrichia buccalis DSM 1135, complete genome	blastn	784	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis

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