metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB81171" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB81171" 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
139289	139289	PRJEB81171_P_NODE_10141_length_236_cov_2.760736_g10014_i0	PRJEB81171	10141	236	2.760736	6.51533696	Sphingobacterium psychroaquaticum	561061	Bacteria	Bacteria	296	8.86e-76	NTclustered	gi\|1601834842\|gb\|CP038029.1\|	561061	g10014	i0	90.393	378.902542372881	229	16	96	5	10	236	27310	27086	Sphingobacterium psychroaquaticum strain SJ-25 chromosome, complete genome	blastn	89421	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium psychroaquaticum
139419	139419	PRJEB81171_P_NODE_6521_length_271_cov_1.333333_g6394_i0	PRJEB81171	6521	271	1.333333	3.61333243	Sphingobacterium multivorum	28454	Bacteria	Bacteria	490	4.44e-134	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g6394	i0	99.262	5.02214022140221	271	2	100	0	1	271	927307	927577	Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome	blastn	1361	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
139466	139466	PRJEB81171_P_NODE_8621_length_248_cov_1.514286_g8494_i0	PRJEB81171	8621	248	1.514286	3.75542928	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	198	2.7199999999999993e-46	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g8494	i0	81.496	1.91935483870968	254	35	100	10	1	248	2264805	2265052	Hymenobacter sp. APR13, complete genome	blastn	476	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
2689569	2689569	PRJEB81171_P_NODE_9843_length_243_cov_0.917647_g9716_i0	PRJEB81171	9843	243	0.917647	2.22988221	Sphingobacterium multivorum	28454	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g9716	i0	100	15.9506172839506	243	0	100	0	1	243	1817046	1817288	Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome	blastn	3876	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
3547241	3547241	PRJEB81171_P_NODE_8183_length_251_cov_0.876404_g8056_i0	PRJEB81171	8183	251	0.876404	2.19977404	Hymenobacter	89966	Bacteria	Bacteria	353	5.569999999999998e-93	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g8056	i0	92.339	210.725099601594	248	19	100	0	4	251	432338	432091	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	52892	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
3965631	3965631	PRJEB81171_P_NODE_8704_length_248_cov_0.891429_g8577_i0	PRJEB81171	8704	248	0.891429	2.21074392	Cloacibacterium sp. TD35	2976818	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2449726939\|gb\|CP104850.1\|	2976818	g8577	i0	99.597	1	248	1	100	0	1	248	2560621	2560374	Cloacibacterium sp. TD35 chromosome, complete genome	blastn	248	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp. TD35
5242077	5242077	PRJEB81171_P_NODE_7405_length_256_cov_1.661202_g7278_i0	PRJEB81171	7405	256	1.661202	4.25267712	Flavobacterium covae	2906076	Bacteria	Bacteria	272	1.64e-68	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g7278	i0	85.938	11.078125	256	34	99	2	2	256	1785009	1785263	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	2836	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
7791602	7791602	PRJEB81171_P_NODE_10107_length_238_cov_4.921212_g9980_i0	PRJEB81171	10107	238	4.921212	11.71248456	Pedobacter sp. UC225_65	3350173	Bacteria	Bacteria	396	8.5699999999999955e-106	NTclustered	gi\|2814008831\|gb\|CP170550.1\|	3350173	g9980	i0	96.639	256.672268907563	238	8	100	0	1	238	2832	3069	Pedobacter sp. UC225_65 chromosome, complete genome	blastn	61088	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. UC225_65
7791721	7791721	PRJEB81171_P_NODE_6647_length_269_cov_1.219388_g6520_i0	PRJEB81171	6647	269	1.219388	3.28015372	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	327	3.66e-85	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g6520	i0	89.695	188.654275092937	262	19	95	7	6	261	338408	338149	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	50748	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
8649836	8649836	PRJEB81171_P_NODE_9587_length_244_cov_0.912281_g9460_i0	PRJEB81171	9587	244	0.912281	2.22596564	Porphyromonas	836	Bacteria	Bacteria	296	9.21e-76	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g9460	i0	88.797	34.1516393442623	241	27	99	0	1	241	1084051	1083811	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	8333	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
9066658	9066658	PRJEB81171_P_NODE_3468_length_355_cov_1.539007_g3341_i0	PRJEB81171	3468	355	1.539007	5.46347485	Tannerella serpentiformis	712710	Bacteria	Bacteria	182	4.11e-41	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g3341	i0	81.197	42.0197183098592	234	36	65	6	119	348	2547328	2547557	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	14917	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
9066747	9066747	PRJEB81171_P_NODE_7188_length_260_cov_1.288770_g7061_i0	PRJEB81171	7188	260	1.28877	3.350802	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	372	1.6e-98	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g7061	i0	93.281	192.638461538462	253	16	97	1	1	252	1742610	1742862	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	50086	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
12892809	12892809	PRJEB81171_P_NODE_1351_length_566_cov_4.243408_g1229_i0	PRJEB81171	1351	566	4.243408	24.01768928	Flavobacterium sp. C-2	1076576	Bacteria	Bacteria	992	0	NTclustered	gi\|343532186\|gb\|HQ188912.1\|	1076576	g1229	i0	98.243	123.623674911661	569	6	100	4	1	566	571	4	Flavobacterium sp. C-2 16S ribosomal RNA gene, partial sequence	blastn	69971	992	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. C-2
12892942	12892942	PRJEB81171_P_NODE_7091_length_261_cov_2.313830_g6964_i0	PRJEB81171	7091	261	2.31383	6.0390963	Hymenobacter monticola	1705399	Bacteria	Bacteria	381	2.669999999999999e-101	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g6964	i0	93.701	340.141762452107	254	16	97	0	8	261	5237857	5238110	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	88777	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
13750078	13750078	PRJEB81171_P_NODE_711_length_771_cov_2.070201_g598_i0	PRJEB81171	711	771	2.070201	15.96124971	Cloacibacterium	501783	Bacteria	Bacteria	1336	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g598	i0	97.925	487.271076523995	771	16	100	0	1	771	2157555	2158325	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	375686	1336	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14167885	14167885	PRJEB81171_P_NODE_9092_length_246_cov_0.901734_g8965_i0	PRJEB81171	9092	246	0.901734	2.21826564	Cloacibacterium normanense	237258	Bacteria	Bacteria	350	7.04e-92	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g8965	i0	92.276	11.2439024390244	246	19	100	0	1	246	366793	367038	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	2766	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14167895	14167895	PRJEB81171_P_NODE_9572_length_244_cov_0.912281_g9445_i0	PRJEB81171	9572	244	0.912281	2.22596564	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g9445	i0	88.889	34.6024590163934	243	27	99	0	2	244	2629647	2629889	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	8443	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
15441795	15441795	PRJEB81171_P_NODE_10053_length_242_cov_0.875740_g9926_i0	PRJEB81171	10053	242	0.87574	2.1192908	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g9926	i0	90.909	10.7768595041322	242	22	100	0	1	242	1240879	1240638	Flavobacterium psychrophilum strain Z1, complete genome	blastn	2608	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
15441897	15441897	PRJEB81171_P_NODE_5413_length_288_cov_2.060465_g5286_i0	PRJEB81171	5413	288	2.060465	5.9341392	Flavobacterium indicum	312277	Bacteria	Bacteria	137	7.15e-28	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g5286	i0	79.592	1.80902777777778	196	36	67	3	3	196	2769824	2769631	Flavobacterium indicum GPTSA100-9 complete genome	blastn	521	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
16299350	16299350	PRJEB81171_P_NODE_7193_length_260_cov_1.251337_g7066_i0	PRJEB81171	7193	260	1.251337	3.2534762	Bacteria	2	Bacteria	Bacteria	82.4	3.02e-11	NTclustered	gi\|116734214\|gb\|DQ873223.1\|	403970	g7066	i0	82.292	1.10769230769231	96	15	37	2	154	248	427	521	Flavobacteriales endosymbiont of Dactylaspis sp. GEM-2005a D287 clone 20 23S ribosomal RNA gene, partial sequence	blastn	288	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales endosymbiont of Dactylaspis sp. GEM-2005a D287
16716165	16716165	PRJEB81171_P_NODE_5614_length_285_cov_1.136792_g5487_i0	PRJEB81171	5614	285	1.136792	3.2398572	Chryseolinea soli	2321403	Bacteria	Bacteria	357	4.98e-94	NTclustered	gi\|1481087475\|gb\|CP032382.1\|	2321403	g5487	i0	89.199	318.456140350877	287	29	100	2	1	285	901025	901311	Chryseolinea soli strain KIS68-18 chromosome, complete genome	blastn	90760	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea soli
17574549	17574549	PRJEB81171_P_NODE_654_length_802_cov_2.012346_g545_i0	PRJEB81171	654	802	2.012346	16.13901492	Chryseobacterium	59732	Bacteria	Bacteria	1325	0	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g545	i0	96.734	492.416458852868	796	25	99	1	1	795	1727481	1728276	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	394918	1328	0.997740963855422	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
17574553	17574553	PRJEB81171_P_NODE_7714_length_253_cov_0.866667_g7587_i0	PRJEB81171	7714	253	0.866667	2.19266751	Weeksellaceae	2762318	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g7587	i0	100	8.98418972332016	250	0	99	0	1	250	1149475	1149724	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	2273	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
17991044	17991044	PRJEB81171_P_NODE_9095_length_246_cov_0.901734_g8968_i0	PRJEB81171	9095	246	0.901734	2.21826564	Persicobacter sp. JZB09	1085624	Bacteria	Bacteria	267	7.289999999999999e-67	NTclustered	gi\|937530659\|gb\|CP012859.1\|	1085624	g8968	i0	86.235	429.065040650407	247	32	100	2	1	246	16978	16733	Persicobacter sp. JZB09 plasmid JZB09-Plasmid16, complete sequence	blastn	105550	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Persicobacter	Persicobacter sp. JZB09
19264968	19264968	PRJEB81171_P_NODE_6176_length_276_cov_1.492611_g6049_i0	PRJEB81171	6176	276	1.492611	4.11960636	Flavobacterium nakdongensis	3073563	Bacteria	Bacteria	267	8.33e-67	NTclustered	gi\|2575681008\|gb\|CP133721.1\|	3073563	g6049	i0	88.94	8.80797101449275	217	22	78	2	40	255	1921055	1921270	Flavobacterium nakdongensis strain 20NA77.7 chromosome, complete genome	blastn	2431	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nakdongensis
19265003	19265003	PRJEB81171_P_NODE_856_length_705_cov_1.528481_g738_i0	PRJEB81171	856	705	1.528481	10.77579105	Flavobacterium sp. N2820	2986834	Bacteria	Bacteria	132	8.8e-26	NTclustered	gi\|2324023843\|gb\|CP110008.1\|	2986834	g738	i0	83.217	0.520567375886525	143	24	20	0	560	702	529675	529817	Flavobacterium sp. N2820 chromosome, complete genome	blastn	367	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2820
20540436	20540436	PRJEB81171_P_NODE_9357_length_245_cov_0.906977_g9230_i0	PRJEB81171	9357	245	0.906977	2.22209365	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g9230	i0	98.367	5.18367346938776	245	4	100	0	1	245	2042682	2042438	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	1270	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
21816177	21816177	PRJEB81171_P_NODE_6378_length_273_cov_1.415000_g6251_i0	PRJEB81171	6378	273	1.415	3.86295	Hymenobacter sp. BRD67	2675877	Bacteria	Bacteria	353	6.14e-93	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g6251	i0	90.943	205.838827838828	265	20	97	2	10	273	433432	433693	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	56194	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
21816191	21816191	PRJEB81171_P_NODE_6798_length_266_cov_1.481865_g6671_i0	PRJEB81171	6798	266	1.481865	3.9417609	Hymenobacter sp. BRD67	2675877	Bacteria	Bacteria	448	2.6599999999999996e-121	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g6671	i0	98.054	282.375939849624	257	5	97	0	1	257	432532	432788	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	75112	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
21816236	21816236	PRJEB81171_P_NODE_8818_length_247_cov_1.465517_g8691_i0	PRJEB81171	8818	247	1.465517	3.61982699	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	283	7.269999999999999e-72	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g8691	i0	87.398	1.99595141700405	246	31	99	0	2	247	131918	132163	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	493	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
23091435	23091435	PRJEB81171_P_NODE_7719_length_253_cov_0.866667_g7592_i0	PRJEB81171	7719	253	0.866667	2.19266751	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g7592	i0	99.605	24	253	1	100	0	1	253	3923129	3922877	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	6072	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
24365176	24365176	PRJEB81171_P_NODE_4080_length_327_cov_3.476378_g3953_i0	PRJEB81171	4080	327	3.476378	11.36775606	uncultured Hymenobacter group bacterium	169966	Bacteria	Bacteria	588	1.8999999999999994e-163	NTclustered	gi\|343787927\|gb\|JN367169.1\|	169966	g3953	i0	99.083	104.382262996942	327	3	100	0	1	327	347	21	Uncultured Hymenobacter group bacterium clone SeqSEEZ147 16S ribosomal RNA gene, partial sequence	blastn	34133	588	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Hymenobacter group bacterium

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