metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA980587" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
3506648	3506648	PRJNA980587_P_NODE_78723_length_251_cov_0.865169_g77930_i0	PRJNA980587	78723	251	0.865169	2.17157419	Cetobacterium somerae	188913	Bacteria	Bacteria	313	9.45e-81	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g77930	i0	90.041	0.960159362549801	241	24	96	0	11	251	346794	346554	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	241	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3821447	3821447	PRJNA980587_P_NODE_34863_length_401_cov_3.231707_g34070_i0	PRJNA980587	34863	401	3.231707	12.95914507	Cetobacterium	180162	Bacteria	Bacteria	736	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g34070	i0	99.751	503.15710723192	401	1	100	0	1	401	279071	278671	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	201766	736	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3821464	3821464	PRJNA980587_P_NODE_43263_length_352_cov_1.247312_g42470_i0	PRJNA980587	43263	352	1.247312	4.39053824	Cetobacterium	180162	Bacteria	Bacteria	643	4.319999999999998e-180	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g42470	i0	99.715	487.190340909091	351	1	99	0	1	351	279066	279416	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	171491	643	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6373576	6373576	PRJNA980587_P_NODE_52005_length_318_cov_2.032653_g51212_i0	PRJNA980587	52005	318	2.032653	6.46383654	Cetobacterium	180162	Bacteria	Bacteria	577	3.9799999999999996e-160	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g51212	i0	99.371	498.830188679245	318	2	100	0	1	318	1804997	1804680	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	158628	582	0.991408934707904	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7647639	7647639	PRJNA980587_P_NODE_78026_length_251_cov_1.825843_g77233_i0	PRJNA980587	78026	251	1.825843	4.58286593	Cetobacterium	180162	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g77233	i0	87.649	5	251	31	100	0	1	251	145243	144993	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1255	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8608824	8608824	PRJNA980587_P_NODE_66407_length_278_cov_1.126829_g65614_i0	PRJNA980587	66407	278	1.126829	3.13258462	Leptotrichia wadei	157687	Bacteria	Bacteria	503	5.88e-138	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g65614	i0	99.281	462.859712230216	278	2	100	0	1	278	221428	221151	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	128675	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
11159175	11159175	PRJNA980587_P_NODE_53449_length_313_cov_2.629167_g52656_i0	PRJNA980587	53449	313	2.629167	8.22929271	Cetobacterium somerae	188913	Bacteria	Bacteria	399	9.079999999999998e-107	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g52656	i0	89.623	4.97444089456869	318	27	100	6	1	313	67074	67390	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1557	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11159491	11159491	PRJNA980587_P_NODE_75589_length_257_cov_1.309783_g74796_i0	PRJNA980587	75589	257	1.309783	3.36614231	Cetobacterium somerae	188913	Bacteria	Bacteria	339	1.5999999999999998e-88	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g74796	i0	90.588	4.99221789883268	255	24	99	0	1	255	1723106	1722852	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1283	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11159649	11159649	PRJNA980587_P_NODE_86249_length_246_cov_0.890173_g85456_i0	PRJNA980587	86249	246	0.890173	2.18982558	Cetobacterium somerae	188913	Bacteria	Bacteria	309	1.19e-79	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g85456	i0	94.118	4.14634146341463	204	11	83	1	41	244	1796443	1796645	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1020	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13709153	13709153	PRJNA980587_P_NODE_34251_length_406_cov_1.327327_g33458_i0	PRJNA980587	34251	406	1.327327	5.38894762	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	641	1.8199999999999993e-179	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g33458	i0	95.11	485.805418719212	409	17	100	3	1	406	52634	52226	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	197237	641	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15297514	15297514	PRJNA980587_P_NODE_85572_length_247_cov_0.885057_g84779_i0	PRJNA980587	85572	247	0.885057	2.18609079	Cetobacterium	180162	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g84779	i0	83.806	3	247	37	100	2	1	247	582340	582583	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	741	231	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17847172	17847172	PRJNA980587_P_NODE_7334_length_1048_cov_4.353846_g6756_i0	PRJNA980587	7334	1048	4.353846	45.62830608	Cetobacterium	180162	Bacteria	Bacteria	878	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g6756	i0	81.991	5.30248091603053	1055	170	99	18	2	1045	408418	409463	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	5557	878	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20082729	20082729	PRJNA980587_P_NODE_82756_length_248_cov_1.760000_g81963_i0	PRJNA980587	82756	248	1.76	4.3648	Leptotrichia wadei	157687	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g81963	i0	100	45.9758064516129	248	0	100	0	1	248	2182467	2182220	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	11402	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21671879	21671879	PRJNA980587_P_NODE_21317_length_548_cov_1.067368_g20529_i0	PRJNA980587	21317	548	1.067368	5.84917664	Fusobacterium	848	Bacteria	Bacteria	985	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g20529	i0	99.088	469.326642335766	548	5	100	0	1	548	461520	462067	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	257191	985	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
22632759	22632759	PRJNA980587_P_NODE_46318_length_339_cov_1.484962_g45525_i0	PRJNA980587	46318	339	1.484962	5.03402118	Cetobacterium somerae	188913	Bacteria	Bacteria	538	2.0199999999999992e-148	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g45525	i0	95.28	99.4985250737463	339	16	100	0	1	339	1897916	1898254	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	33730	538	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23907952	23907952	PRJNA980587_P_NODE_29079_length_449_cov_3.255319_g28286_i0	PRJNA980587	29079	449	3.255319	14.61638231	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	669	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g28286	i0	93.541	366.122494432071	449	29	100	0	1	449	53449	53001	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	164389	669	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24221147	24221147	PRJNA980587_P_NODE_32259_length_421_cov_2.612069_g31466_i0	PRJNA980587	32259	421	2.612069	10.99681049	Fusobacterium	848	Bacteria	Bacteria	357	7.67e-94	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g31466	i0	84.085	183.458432304038	377	52	89	8	47	421	157154	156784	Fusobacterium varium strain SB069 chromosome	blastn	77236	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
25182485	25182485	PRJNA980587_P_NODE_92420_length_242_cov_1.822485_g91627_i0	PRJNA980587	92420	242	1.822485	4.4104137	Cetobacterium somerae	188913	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g91627	i0	97.521	28.5413223140496	242	6	100	0	1	242	1743490	1743731	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	6907	414	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25496014	25496014	PRJNA980587_P_NODE_52020_length_318_cov_1.873469_g51227_i0	PRJNA980587	52020	318	1.873469	5.95763142	Cetobacterium	180162	Bacteria	Bacteria	357	5.639999999999998e-94	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g51227	i0	87.421	13.4811320754717	318	31	100	2	1	318	1992128	1991820	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4287	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25496048	25496048	PRJNA980587_P_NODE_64380_length_282_cov_2.392344_g63587_i0	PRJNA980587	64380	282	2.392344	6.74641008	Cetobacterium	180162	Bacteria	Bacteria	329	1.07e-85	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g63587	i0	88.087	4.93971631205674	277	33	98	0	6	282	119131	118855	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1393	329	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25496117	25496117	PRJNA980587_P_NODE_91220_length_243_cov_0.905882_g90427_i0	PRJNA980587	91220	243	0.905882	2.20129326	Cetobacterium	180162	Bacteria	Bacteria	289	1.53e-73	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g90427	i0	88.066	3.96296296296296	243	29	100	0	1	243	1773485	1773243	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	963	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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