metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA798511" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA798511" 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
790178	790178	PRJNA798511_P_NODE_26701_length_600_cov_2.400380_g22493_i0	PRJNA798511	26701	600	2.40038	14.40228	uncultured Bacteroidales bacterium	194843	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2874254021\|emb\|OY970346.1\|	194843	g22493	i0	96.875	0.0533333333333333	32	1	5	0	201	232	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
2066483	2066483	PRJNA798511_P_NODE_53662_length_340_cov_1.745318_g49396_i0	PRJNA798511	53662	340	1.745318	5.9340812	Prevotella nigrescens	28133	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g49396	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
2066902	2066902	PRJNA798511_P_NODE_82162_length_262_cov_1.386243_g77896_i0	PRJNA798511	82162	262	1.386243	3.63195666	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1893901202\|gb\|CP059199.1\|	1653831	g77896	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
3341476	3341476	PRJNA798511_P_NODE_40683_length_415_cov_1.535088_g36420_i0	PRJNA798511	40683	415	1.535088	6.3706152	Zunongwangia sp. SCSIO 43204	2779359	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2090724234\|gb\|CP063204.1\|	2779359	g36420	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
4618105	4618105	PRJNA798511_P_NODE_13344_length_1200_cov_2.200532_g10250_i0	PRJNA798511	13344	1200	2.200532	26.406384	uncultured Bacteroides sp.	162156	Bacteria	Bacteria	54.7	0.034	NTclustered	gi\|2814788366\|emb\|OY781098.2\|	162156	g10250	i0	100	0.0241666666666667	29	0	2	0	847	875	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.
4619384	4619384	PRJNA798511_P_NODE_75864_length_275_cov_6.846535_g71598_i0	PRJNA798511	75864	275	6.846535	18.82797125	Spirosoma foliorum	2710596	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1886902300\|gb\|CP059732.1\|	2710596	g71598	i0	92.308	0.141818181818182	39	1	14	2	98	136	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
4619474	4619474	PRJNA798511_P_NODE_82164_length_262_cov_1.380952_g77898_i0	PRJNA798511	82164	262	1.380952	3.61809424	Prevotella nigrescens	28133	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g77898	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
5893883	5893883	PRJNA798511_P_NODE_34785_length_474_cov_1.002494_g30526_i0	PRJNA798511	34785	474	1.002494	4.75182156	Christiangramia forsetii	411153	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|117576522\|emb\|CU207366.1\|	411154	g30526	i0	100	0.0590717299578059	28	0	6	0	357	384	2959092	2959119	Gramella forsetii KT0803 complete circular genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Christiangramia	Christiangramia forsetii
5894852	5894852	PRJNA798511_P_NODE_99205_length_243_cov_1.647059_g94939_i0	PRJNA798511	99205	243	1.647059	4.00235337	Marinoscillum sp.	2024838	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2836248207\|gb\|CP121337.1\|	2024838	g94939	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.
7169115	7169115	PRJNA798511_P_NODE_61686_length_312_cov_1.732218_g57420_i0	PRJNA798511	61686	312	1.732218	5.40452016	Marivirga salinarum	3059078	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2571466792\|gb\|CP129971.2\|	3059078	g57420	i0	100	0.0897435897435897	28	0	9	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
8443552	8443552	PRJNA798511_P_NODE_44767_length_386_cov_1.408946_g40503_i0	PRJNA798511	44767	386	1.408946	5.43853156	Adhaeribacter swui	2086471	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g40503	i0	96.97	0.0854922279792746	33	0	8	1	189	220	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
9718428	9718428	PRJNA798511_P_NODE_32828_length_497_cov_1.775943_g28574_i0	PRJNA798511	32828	497	1.775943	8.82643671	Fermentimonas caenicola	1562970	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g28574	i0	100	0.0563380281690141	28	0	6	0	161	188	1562804	1562777	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
9719102	9719102	PRJNA798511_P_NODE_73048_length_282_cov_1.105263_g68782_i0	PRJNA798511	73048	282	1.105263	3.11684166	Chryseobacterium indologenes	253	Bacteria	Bacteria	58.4	5.59e-4	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g68782	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
10994271	10994271	PRJNA798511_P_NODE_33409_length_490_cov_0.983213_g29153_i0	PRJNA798511	33409	490	0.983213	4.8177437	Formosa sp. Hel1_33_131	1336794	Bacteria	Bacteria	52.8	0.048	NTclustered	gi\|1069150152\|gb\|CP017260.1\|	1336794	g29153	i0	100	0.228571428571429	28	0	6	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
10994285	10994285	PRJNA798511_P_NODE_34169_length_481_cov_1.044118_g29911_i0	PRJNA798511	34169	481	1.044118	5.02220758	Hwangdonia lutea	3075823	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2593228480\|gb\|CP136521.1\|	3075823	g29911	i0	100	0.0582120582120582	28	0	6	0	203	230	1265647	1265620	Hwangdonia lutea strain SCSIO 19198 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Hwangdonia	Hwangdonia lutea
10995245	10995245	PRJNA798511_P_NODE_92769_length_248_cov_0.880000_g88503_i0	PRJNA798511	92769	248	0.88	2.1824	Sphingobacterium multivorum	28454	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g88503	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
12270534	12270534	PRJNA798511_P_NODE_86710_length_253_cov_1.783333_g82444_i0	PRJNA798511	86710	253	1.783333	4.51183249	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g82444	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
13544102	13544102	PRJNA798511_P_NODE_45751_length_380_cov_1.713355_g41486_i0	PRJNA798511	45751	380	1.713355	6.510749	Chryseobacterium sp. MYb264	2745153	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2653376484\|gb\|CP142422.1\|	2745153	g41486	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
14819653	14819653	PRJNA798511_P_NODE_96612_length_245_cov_0.895349_g92346_i0	PRJNA798511	96612	245	0.895349	2.19360505	Chryseobacterium sp. MEBOG06	2879938	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2186956161\|gb\|CP084580.1\|	2879938	g92346	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
16092882	16092882	PRJNA798511_P_NODE_34313_length_479_cov_1.640394_g30055_i0	PRJNA798511	34313	479	1.640394	7.85748726	Chryseobacterium indoltheticum	254	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1519503470\|gb\|CP033928.1\|	254	g30055	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
19069474	19069474	PRJNA798511_P_NODE_51055_length_352_cov_1.103943_g46789_i0	PRJNA798511	51055	352	1.103943	3.88587936	Cellulophaga	104264	Bacteria	Bacteria	62.1	5.53e-5	NTclustered	gi\|2069725367\|gb\|CP058988.1\|	2745558	g46789	i0	100	1.11079545454545	33	0	9	0	15	47	1401463	1401431	Cellulophaga sp. HaHa_2_95 chromosome, complete genome	blastn	391	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. HaHa_2_95
19917851	19917851	PRJNA798511_P_NODE_78476_length_270_cov_1.182741_g74210_i0	PRJNA798511	78476	270	1.182741	3.1934007	Flavobacterium sp. CHNK8	2871165	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2086066582\|gb\|CP081492.1\|	2871165	g74210	i0	100	0.107407407407407	29	0	11	0	138	166	684844	684872	Flavobacterium sp. CHNK8 chromosome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. CHNK8
21193768	21193768	PRJNA798511_P_NODE_99937_length_243_cov_0.905882_g95671_i0	PRJNA798511	99937	243	0.905882	2.20129326	Zunongwangia sp. SCSIO 43204	2779359	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2090724234\|gb\|CP063204.1\|	2779359	g95671	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
22468361	22468361	PRJNA798511_P_NODE_95238_length_246_cov_0.890173_g90972_i0	PRJNA798511	95238	246	0.890173	2.18982558	Flavobacterium aquiphilum	3003261	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2493254723\|gb\|CP114288.2\|	3003261	g90972	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
25016571	25016571	PRJNA798511_P_NODE_24240_length_659_cov_1.744027_g20073_i0	PRJNA798511	24240	659	1.744027	11.49313793	Flavobacterium soyae	2903098	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|2714450175\|gb\|CP150845.1\|	2903098	g20073	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
25444519	25444519	PRJNA798511_P_NODE_96220_length_245_cov_1.790698_g91954_i0	PRJNA798511	96220	245	1.790698	4.3872101	Apibacter	1778601	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1820023728\|gb\|CP049714.1\|	2656761	g91954	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

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