metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA832865" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA832865" and tax_clade = "FCB group"

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
822484	822484	PRJNA832865_S_NODE_16141_length_973_cov_2.114444_g12037_i0	PRJNA832865	16141	973	2.114444	20.57354012	uncultured Bacteroides sp.	162156	Bacteria	Bacteria	54.7	0.027	NTclustered	gi\|2814788366\|emb\|OY781098.2\|	162156	g12037	i0	100	0.0298047276464543	29	0	3	0	620	648	2170347	2170375	MAG: uncultured Bacteroides sp. isolate f2676154-5b30-4884-ab03-e6063c135ffa genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
822986	822986	PRJNA832865_S_NODE_34061_length_478_cov_2.538272_g28981_i0	PRJNA832865	34061	478	2.538272	12.13294016	uncultured Bacteroidales bacterium	194843	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2874254021\|emb\|OY970346.1\|	194843	g28981	i0	96.875	0.0669456066945607	32	1	7	0	79	110	3298089	3298058	MAG: uncultured Bacteroidales bacterium isolate MFD01476.bin.1.81 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			uncultured Bacteroidales bacterium
823952	823952	PRJNA832865_S_NODE_92461_length_253_cov_1.783333_g87375_i0	PRJNA832865	92461	253	1.783333	4.51183249	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g87375	i0	100	0.221343873517787	28	0	11	0	97	124	2123527	2123500	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
2097596	2097596	PRJNA832865_S_NODE_103682_length_245_cov_0.895349_g98596_i0	PRJNA832865	103682	245	0.895349	2.19360505	Chryseobacterium sp. MEBOG06	2879938	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2186956161\|gb\|CP084580.1\|	2879938	g98596	i0	100	0.114285714285714	28	0	11	0	74	101	1607055	1607082	Chryseobacterium sp. MEBOG06 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. MEBOG06
2098199	2098199	PRJNA832865_S_NODE_23922_length_659_cov_1.761092_g19009_i0	PRJNA832865	23922	659	1.761092	11.60559628	Flavobacterium soyae	2903098	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2714450175\|gb\|CP150845.1\|	2903098	g19009	i0	100	0.0440060698027314	29	0	4	0	63	91	643099	643071	Flavobacterium soyae strain 55 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium soyae
3780575	3780575	PRJNA832865_S_NODE_56543_length_332_cov_5.926641_g51457_i0	PRJNA832865	56543	332	5.926641	19.67644812	Flavobacterium	237	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2284918182\|gb\|CP100442.1\|	1114867	g51457	i0	96.875	0.192771084337349	32	0	9	1	271	301	332334	332303	Flavobacterium plurextorum strain RSG-18 chromosome, complete genome	blastn	64	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium plurextorum
4651322	4651322	PRJNA832865_S_NODE_34004_length_479_cov_1.640394_g28924_i0	PRJNA832865	34004	479	1.640394	7.85748726	Chryseobacterium indoltheticum	254	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1519503470\|gb\|CP033928.1\|	254	g28924	i0	90.698	0.0897703549060543	43	2	9	2	323	365	81903	81863	Chryseobacterium indoltheticum strain G0211 chromosome, complete genome	blastn	43	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indoltheticum
4652212	4652212	PRJNA832865_S_NODE_86924_length_262_cov_1.386243_g81838_i0	PRJNA832865	86924	262	1.386243	3.63195666	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1893901202\|gb\|CP059199.1\|	1653831	g81838	i0	100	0.106870229007634	28	0	11	0	104	131	227189	227216	Blattabacterium cuenoti strain MEDIASdel chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
5926976	5926976	PRJNA832865_S_NODE_86925_length_262_cov_1.380952_g81839_i0	PRJNA832865	86925	262	1.380952	3.61809424	Prevotella nigrescens	28133	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g81839	i0	100	0.221374045801527	29	0	11	0	95	123	1111233	1111205	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	58	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
7202104	7202104	PRJNA832865_S_NODE_89126_length_258_cov_1.967568_g84040_i0	PRJNA832865	89126	258	1.967568	5.07632544	Adhaeribacter swui	2086471	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g84040	i0	96.97	0.127906976744186	33	0	12	1	61	92	2302812	2302844	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	33	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
7202242	7202242	PRJNA832865_S_NODE_99366_length_248_cov_0.880000_g94280_i0	PRJNA832865	99366	248	0.88	2.1824	Sphingobacterium multivorum	28454	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g94280	i0	100	15	248	0	100	0	1	248	4324835	4325082	Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome	blastn	3720	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
12302538	12302538	PRJNA832865_S_NODE_54410_length_340_cov_1.745318_g49324_i0	PRJNA832865	54410	340	1.745318	5.9340812	Prevotella nigrescens	28133	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g49324	i0	100	0.164705882352941	28	0	8	0	171	198	1820317	1820290	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
14851218	14851218	PRJNA832865_S_NODE_46592_length_376_cov_1.099010_g41506_i0	PRJNA832865	46592	376	1.09901	4.1322776	Formosa sp. Hel1_33_131	1336794	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1069150152\|gb\|CP017260.1\|	1336794	g41506	i0	100	0.297872340425532	28	0	7	0	89	116	1866595	1866622	Formosa sp. Hel1_33_131 chromosome, complete genome	blastn	112	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Formosa	Formosa sp. Hel1_33_131
16126192	16126192	PRJNA832865_S_NODE_72933_length_288_cov_8.772093_g67847_i0	PRJNA832865	72933	288	8.772093	25.26362784	Spirosoma foliorum	2710596	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1886902300\|gb\|CP059732.1\|	2710596	g67847	i0	92.308	0.135416666666667	39	1	14	2	144	182	3717296	3717332	Spirosoma foliorum strain KCTC 72228 chromosome, complete genome	blastn	39	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma foliorum
17400443	17400443	PRJNA832865_S_NODE_107354_length_243_cov_0.905882_g102268_i0	PRJNA832865	107354	243	0.905882	2.20129326	Zunongwangia sp. SCSIO 43204	2779359	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2090724234\|gb\|CP063204.1\|	2779359	g102268	i0	90.476	0.172839506172839	42	0	17	2	178	218	1799088	1799126	Zunongwangia sp. SCSIO 43204 chromosome, complete genome	blastn	42	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Zunongwangia	Zunongwangia sp. SCSIO 43204
17401993	17401993	PRJNA832865_S_NODE_76154_length_282_cov_1.105263_g71068_i0	PRJNA832865	76154	282	1.105263	3.11684166	Chryseobacterium indologenes	253	Bacteria	Bacteria	58.4	5.59e-4	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g71068	i0	94.737	5.9822695035461	38	1	13	1	21	57	2598590	2598553	Chryseobacterium indologenes strain AA5 chromosome, complete genome	blastn	1687	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
18673428	18673428	PRJNA832865_S_NODE_102195_length_246_cov_0.890173_g97109_i0	PRJNA832865	102195	246	0.890173	2.18982558	Flavobacterium aquiphilum	3003261	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2493254723\|gb\|CP114288.2\|	3003261	g97109	i0	100	0.117886178861789	29	0	12	0	213	241	2088853	2088881	Flavobacterium aquiphilum strain IMCC34779 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium aquiphilum
18673490	18673490	PRJNA832865_S_NODE_106535_length_243_cov_1.658824_g101449_i0	PRJNA832865	106535	243	1.658824	4.03094232	Marinoscillum sp.	2024838	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2836248207\|gb\|CP121337.1\|	2024838	g101449	i0	94.595	0.152263374485597	37	1	15	1	146	181	3333752	3333716	MAG: Marinoscillum sp. isolate NCC532_bact_3502 chromosome, complete genome	blastn	37	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Marinoscillum	Marinoscillum sp.
18674416	18674416	PRJNA832865_S_NODE_40575_length_415_cov_1.535088_g35490_i0	PRJNA832865	40575	415	1.535088	6.3706152	Zunongwangia sp. SCSIO 43204	2779359	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2090724234\|gb\|CP063204.1\|	2779359	g35490	i0	100	0.0674698795180723	28	0	7	0	316	343	2115120	2115093	Zunongwangia sp. SCSIO 43204 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Zunongwangia	Zunongwangia sp. SCSIO 43204
21225255	21225255	PRJNA832865_S_NODE_45777_length_380_cov_1.713355_g40691_i0	PRJNA832865	45777	380	1.713355	6.510749	Chryseobacterium sp. MYb264	2745153	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2653376484\|gb\|CP142422.1\|	2745153	g40691	i0	94.595	0.0973684210526316	37	1	9	1	332	367	486391	486355	Chryseobacterium sp. MYb264 chromosome	blastn	37	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. MYb264
21630619	21630619	PRJNA832865_S_NODE_103197_length_245_cov_1.790698_g98111_i0	PRJNA832865	103197	245	1.790698	4.3872101	Apibacter	1778601	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1820023728\|gb\|CP049714.1\|	2656761	g98111	i0	100	0.228571428571429	28	0	11	0	165	192	2242358	2242385	Apibacter sp. B2966 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Apibacter	Apibacter sp. B2966
23775662	23775662	PRJNA832865_S_NODE_48859_length_364_cov_1.680412_g43773_i0	PRJNA832865	48859	364	1.680412	6.11669968	Marivirga salinarum	3059078	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2571466792\|gb\|CP129971.2\|	3059078	g43773	i0	100	0.0769230769230769	28	0	8	0	255	282	4281732	4281759	Marivirga salinae isolate BDSF4-3 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Marivirgaceae	Marivirga	Marivirga salinarum
25049981	25049981	PRJNA832865_S_NODE_75620_length_283_cov_1.204762_g70534_i0	PRJNA832865	75620	283	1.2047620000000001	3.40947646	Christiangramia forsetii	411153	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|117576522\|emb\|CU207366.1\|	411154	g70534	i0	100	0.0989399293286219	28	0	10	0	166	193	2959092	2959119	Gramella forsetii KT0803 complete circular genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Christiangramia	Christiangramia forsetii

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