metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1641873	1641873	PRJNA217180_P_NODE_14482_length_163_cov_0.894737_g14382_i0	PRJNA217180	14482	163	0.894737	1.45842131	Flavobacterium nackdongense	2547394	Bacteria	Bacteria	115	1.7100000000000003e-21	NTclustered	gi\|1594504096\|gb\|CP037933.1\|	2547394	g14382	i0	80.952	0.901840490797546	147	26	90	2	2	147	2780684	2780829	Flavobacterium nackdongense strain GS13 chromosome, complete genome	blastn	147	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nackdongense
2917713	2917713	PRJNA217180_P_NODE_13363_length_165_cov_0.879310_g13263_i0	PRJNA217180	13363	165	0.87931	1.4508615	Aquirufa antheringensis	2516559	Bacteria	Bacteria	235	1.28e-57	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g13263	i0	92.638	0.987878787878788	163	12	99	0	1	163	890662	890500	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	163	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
2917723	2917723	PRJNA217180_P_NODE_14503_length_163_cov_0.894737_g14403_i0	PRJNA217180	14503	163	0.894737	1.45842131	Flavobacterium indicum	312277	Bacteria	Bacteria	169	1.29e-37	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g14403	i0	85.276	3.51533742331288	163	24	100	0	1	163	108838	108676	Flavobacterium indicum GPTSA100-9 complete genome	blastn	573	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
2917763	2917763	PRJNA217180_P_NODE_9603_length_189_cov_1.457143_g9503_i0	PRJNA217180	9603	189	1.457143	2.75400027	Cloacibacterium normanense	237258	Bacteria	Bacteria	294	2.44e-75	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g9503	i0	94.764	2.31746031746032	191	6	99	2	3	189	737827	738017	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	438	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
4884014	4884014	PRJNA217180_P_NODE_6204_length_235_cov_2.403226_g6104_i0	PRJNA217180	6204	235	2.403226	5.6475811	Aureispira	365032	Bacteria	Bacteria	272	1.4899999999999996e-68	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g6104	i0	88.646	251.855319148936	229	18	95	6	9	232	4696725	4696950	Aureispira anguillae EL160426 DNA, complete genome	blastn	59186	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
5470439	5470439	PRJNA217180_P_NODE_12585_length_167_cov_0.864407_g12485_i0	PRJNA217180	12585	167	0.864407	1.44355969	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g12485	i0	99.401	4.43712574850299	167	1	100	0	1	167	97360	97526	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	741	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
6744734	6744734	PRJNA217180_P_NODE_15266_length_161_cov_0.910714_g15166_i0	PRJNA217180	15266	161	0.910714	1.46624954	Aquirufa antheringensis	2516559	Bacteria	Bacteria	152	1.28e-32	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g15166	i0	84.516	0.962732919254658	155	23	96	1	2	155	1725567	1725413	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	155	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
8708731	8708731	PRJNA217180_P_NODE_10707_length_181_cov_1.545455_g10607_i0	PRJNA217180	10707	181	1.545455	2.79727355	Flavobacterium	237	Bacteria	Bacteria	324	2.95e-84	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g10607	i0	98.895	465.28729281768	181	2	100	0	1	181	1148395	1148575	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	84217	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
10571157	10571157	PRJNA217180_P_NODE_14869_length_162_cov_0.902655_g14769_i0	PRJNA217180	14869	162	0.902655	1.4623011	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	244	2.07e-60	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g14769	i0	93.827	1	162	10	100	0	1	162	1533449	1533610	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	162	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
10571204	10571204	PRJNA217180_P_NODE_9289_length_192_cov_1.363636_g9189_i0	PRJNA217180	9289	192	1.363636	2.61818112	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	355	1.13e-93	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g9189	i0	100	2	192	0	100	0	1	192	790398	790589	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	384	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
16944364	16944364	PRJNA217180_P_NODE_12534_length_167_cov_0.864407_g12434_i0	PRJNA217180	12534	167	0.864407	1.44355969	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g12434	i0	94.611	7.20359281437126	167	9	100	0	1	167	2093974	2094140	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	1203	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
16944369	16944369	PRJNA217180_P_NODE_12954_length_166_cov_0.871795_g12854_i0	PRJNA217180	12954	166	0.871795	1.4471797	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g12854	i0	97.59	2	166	4	100	0	1	166	1325438	1325273	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	332	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
19493046	19493046	PRJNA217180_P_NODE_13396_length_165_cov_0.879310_g13296_i0	PRJNA217180	13396	165	0.87931	1.4508615	Aquirufa antheringensis	2516559	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g13296	i0	100	1	165	0	100	0	1	165	999352	999516	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	165	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
20768614	20768614	PRJNA217180_P_NODE_15457_length_161_cov_0.910714_g15357_i0	PRJNA217180	15457	161	0.910714	1.46624954	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	289	9.37e-74	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g15357	i0	99.371	5.90062111801242	159	1	99	0	3	161	2052859	2052701	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	950	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
23319159	23319159	PRJNA217180_P_NODE_14239_length_163_cov_1.736842_g14139_i0	PRJNA217180	14239	163	1.736842	2.83105246	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	159	7.779999999999998e-35	NTclustered	gi\|2621785503\|emb\|OY781961.1\|	2053594	g14139	i0	84.81	0.969325153374233	158	24	97	0	2	159	117047	117204	MAG: Prolixibacteraceae bacterium isolate f51a5693-dc35-4a15-a57f-52dad87cda9e genome assembly, chromosome: 1	blastn	158	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
23319161	23319161	PRJNA217180_P_NODE_14479_length_163_cov_0.894737_g14379_i0	PRJNA217180	14479	163	0.894737	1.45842131	Flavobacterium galactosidilyticum	2893886	Bacteria	Bacteria	159	7.779999999999998e-35	NTclustered	gi\|2153913845\|gb\|CP087135.1\|	2893886	g14379	i0	84.472	5.6441717791411	161	25	99	0	3	163	1015063	1014903	Flavobacterium galactosidilyticum strain F-340 chromosome, complete genome	blastn	920	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium galactosidilyticum
24593312	24593312	PRJNA217180_P_NODE_13380_length_165_cov_0.879310_g13280_i0	PRJNA217180	13380	165	0.87931	1.4508615	Aquirufa antheringensis	2516559	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g13280	i0	93.333	1	165	11	100	0	1	165	2444839	2445003	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	165	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
24593325	24593325	PRJNA217180_P_NODE_14700_length_162_cov_1.539823_g14600_i0	PRJNA217180	14700	162	1.539823	2.49451326	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	254	3.44e-63	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g14600	i0	95.062	1	162	7	100	1	1	162	26985	27145	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	162	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes

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