metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA643700" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA643700" 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
618224	618224	PRJNA643700_P_NODE_391121_length_168_cov_1.630252_g389565_i0	PRJNA643700	391121	168	1.630252	2.73882336	Sneathia vaginalis	187101	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g389565	i0	100	0.166666666666667	28	0	17	0	108	135	881826	881853	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
3710378	3710378	PRJNA643700_P_NODE_118723_length_380_cov_2.280967_g117168_i0	PRJNA643700	118723	380	2.280967	8.6676746	Leptotrichia	32067	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g117168	i0	92.5	0.292105263157895	40	1	11	2	19	58	1541366	1541329	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	111	56.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
4445782	4445782	PRJNA643700_P_NODE_225164_length_257_cov_2.250000_g223608_i0	PRJNA643700	225164	257	2.25	5.7825	Leptotrichia mesophila	3239303	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g223608	i0	100	0.11284046692607	29	0	11	0	9	37	1003522	1003494	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
4445869	4445869	PRJNA643700_P_NODE_334984_length_192_cov_1.944056_g333428_i0	PRJNA643700	334984	192	1.944056	3.73258752	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	58.4	3.55e-4	NTclustered	gi\|2621703980\|emb\|OY762935.1\|	544433	g333428	i0	100	0.161458333333333	31	0	16	0	150	180	1385499	1385529	MAG: uncultured Ilyobacter sp. isolate b034904b-4944-4ecc-b743-47c946c9bc96 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
4986985	4986985	PRJNA643700_P_NODE_290184_length_215_cov_1.397590_g288628_i0	PRJNA643700	290184	215	1.39759	3.0048185	Fusobacterium	848	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2704977725\|gb\|CP077125.1\|	851	g288628	i0	100	1.48372093023256	29	0	13	0	60	88	1865551	1865523	Fusobacterium nucleatum strain KCOM3714 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16461558	16461558	PRJNA643700_P_NODE_8073_length_1170_cov_9.732382_g7464_i0	PRJNA643700	8073	1170	9.732382	113.8688694	Cetobacterium	180162	Bacteria	Bacteria	2017	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g7464	i0	97.949	532.423076923077	1170	13	100	5	1	1170	278673	279831	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	622935	2017	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18470376	18470376	PRJNA643700_P_NODE_252575_length_238_cov_1.100529_g251019_i0	PRJNA643700	252575	238	1.100529	2.61925902	Leptotrichia sp. oral taxon 847	1785996	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|987458696\|gb\|CP014231.1\|	1785996	g251019	i0	100	0.121848739495798	29	0	12	0	150	178	417690	417718	Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 847
21020609	21020609	PRJNA643700_P_NODE_364737_length_178_cov_2.782946_g363181_i0	PRJNA643700	364737	178	2.782946	4.9536438800000004	Cetobacterium somerae	188913	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g363181	i0	98.876	501.76404494382	178	2	100	0	1	178	941317	941140	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	89314	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22295419	22295419	PRJNA643700_P_NODE_62358_length_528_cov_9.123173_g60842_i0	PRJNA643700	62358	528	9.123173	48.17035344	Cetobacterium somerae	188913	Bacteria	Bacteria	929	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g60842	i0	98.485	525.426136363636	528	7	100	1	1	528	1318442	1318968	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	277425	929	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22836095	22836095	PRJNA643700_P_NODE_273678_length_224_cov_2.491429_g272122_i0	PRJNA643700	273678	224	2.491429	5.58080096	Fusobacterium	848	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g272122	i0	96.875	1.85714285714286	32	0	14	1	28	58	23022	23053	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	416	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23570775	23570775	PRJNA643700_P_NODE_151439_length_331_cov_1.436170_g149884_i0	PRJNA643700	151439	331	1.43617	4.7537227	Leptotrichia rugosa	3239302	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2785246835\|gb\|CP165644.1\|	3239302	g149884	i0	94.286	0.105740181268882	35	0	10	2	135	168	1626629	1626596	Leptotrichia sp. HSP-334 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia rugosa
24110657	24110657	PRJNA643700_P_NODE_83899_length_457_cov_2.039216_g82351_i0	PRJNA643700	83899	457	2.039216	9.31921712	Fusobacterium	848	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g82351	i0	100	0.678336980306346	28	0	6	0	422	449	884293	884320	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	310	52.8	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);;