metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
414401	414401	PRJNA404067_P_NODE_17621_length_248_cov_1.224599_g17234_i0	PRJNA404067	17621	248	1.224599	3.03700552	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	390	4.1799999999999996e-104	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g17234	i0	96.596	332.665322580645	235	8	95	0	1	235	52555	52789	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	82501	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1689674	1689674	PRJNA404067_P_NODE_39522_length_199_cov_3.014493_g39135_i0	PRJNA404067	39522	199	3.014493	5.99884107	Leptotrichia buccalis	40542	Bacteria	Bacteria	324	3.31e-84	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g39135	i0	95.98	10.1206030150754	199	8	100	0	1	199	1314713	1314911	Leptotrichia buccalis DSM 1135, complete genome	blastn	2014	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
2356806	2356806	PRJNA404067_P_NODE_31022_length_209_cov_1.493243_g30635_i0	PRJNA404067	31022	209	1.493243	3.12087787	Fusobacterium	848	Bacteria	Bacteria	370	4.45e-98	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g30635	i0	98.565	483.923444976077	209	3	100	0	1	209	299207	298999	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	101140	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6184357	6184357	PRJNA404067_P_NODE_22805_length_228_cov_4.089820_g22418_i0	PRJNA404067	22805	228	4.08982	9.3247896	Leptotrichia	32067	Bacteria	Bacteria	387	4.91e-103	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g22418	i0	97.368	465.026315789474	228	5	100	1	1	228	1757310	1757084	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	106026	390	0.992307692307692	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
8067831	8067831	PRJNA404067_P_NODE_22867_length_228_cov_1.910180_g22480_i0	PRJNA404067	22867	228	1.91018	4.3552104	Fusobacterium polymorphum	76857	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2706067283\|gb\|CP077110.1\|	76857	g22480	i0	100	4	228	0	100	0	1	228	1382156	1381929	Fusobacterium polymorphum strain KCOM1278 chromosome, complete genome	blastn	912	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9342649	9342649	PRJNA404067_P_NODE_19328_length_239_cov_1.488764_g18941_i0	PRJNA404067	19328	239	1.488764	3.55814596	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	392	1.11e-104	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g18941	i0	96.234	1	239	9	100	0	1	239	196291	196053	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	239	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9342829	9342829	PRJNA404067_P_NODE_30748_length_210_cov_0.946309_g30361_i0	PRJNA404067	30748	210	0.946309	1.9872489	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	350	5.84e-92	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g30361	i0	96.682	276.338095238095	211	5	100	2	1	210	53393	53184	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	58031	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11284803	11284803	PRJNA404067_P_NODE_44869_length_168_cov_7.542056_g44482_i0	PRJNA404067	44869	168	7.542056	12.67065408	root	1	Root_unresolved	Root_unresolved	300	4.56e-77	NTclustered	gi\|1756501895\|gb\|MN537503.1\|	852	g44482	i0	98.81	100	168	2	100	0	1	168	250	417	Fusobacterium perfoetens strain DSM 105865 16S ribosomal RNA gene, partial sequence	blastn	16800	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
11893656	11893656	PRJNA404067_P_NODE_40590_length_194_cov_4.345865_g40203_i0	PRJNA404067	40590	194	4.345865	8.4309781	Fusobacterium mortiferum	850	Bacteria	Bacteria	320	4.16e-83	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g40203	i0	96.859	2.9639175257732	191	6	98	0	4	194	156051	155861	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	575	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
13168152	13168152	PRJNA404067_P_NODE_10351_length_339_cov_2.611511_g9966_i0	PRJNA404067	10351	339	2.611511	8.85302229	Cetobacterium somerae	188913	Bacteria	Bacteria	401	2.759999999999999e-107	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g9966	i0	97.845	514.743362831858	232	5	100	0	108	339	941232	941001	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	174498	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16383694	16383694	PRJNA404067_P_NODE_23993_length_225_cov_2.932927_g23606_i0	PRJNA404067	23993	225	2.932927	6.59908575	Fusobacterium	848	Bacteria	Bacteria	411	2.869999999999999e-110	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g23606	i0	99.556	486.853333333333	225	1	100	0	1	225	463043	462819	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	109542	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
16991963	16991963	PRJNA404067_P_NODE_17454_length_249_cov_1.553191_g17067_i0	PRJNA404067	17454	249	1.553191	3.86744559	Fusobacterium polymorphum	76857	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g17067	i0	98.4	427.987951807229	250	2	100	2	1	249	165281	165033	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	106569	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18932632	18932632	PRJNA404067_P_NODE_12015_length_304_cov_3.074074_g11629_i0	PRJNA404067	12015	304	3.074074	9.34518496	Fusobacterium	848	Bacteria	Bacteria	562	1.06e-155	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g11629	i0	100	490.542763157895	304	0	100	0	1	304	2087394	2087697	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	149125	562	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19540181	19540181	PRJNA404067_P_NODE_12156_length_302_cov_1.746888_g11770_i0	PRJNA404067	12156	302	1.746888	5.27560176	Leptotrichia sp. oral taxon 225	671213	Bacteria	Bacteria	553	6.32e-153	NTclustered	gi\|257480633\|gb\|GQ422732.1\|	671213	g11770	i0	99.669	113.278145695364	302	1	100	0	1	302	304	3	Leptotrichia sp. oral taxon 225 clone HE052 16S ribosomal RNA gene, partial sequence	blastn	34210	553	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 225
19540334	19540334	PRJNA404067_P_NODE_23456_length_227_cov_1.174699_g23069_i0	PRJNA404067	23456	227	1.174699	2.66656673	Fusobacterium polymorphum	76857	Bacteria	Bacteria	409	1.04e-109	NTclustered	gi\|2706426664\|gb\|CP077146.1\|	76857	g23069	i0	99.119	99.726872246696	227	2	100	0	1	227	1503085	1503311	Fusobacterium polymorphum strain KCOM2500 chromosome, complete genome	blastn	22638	409	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);;