metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1136505" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1136505" 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
1559041	1559041	PRJNA1136505_P_NODE_115562_length_268_cov_1.579487_g108702_i0	PRJNA1136505	115562	268	1.579487	4.23302516	Spirosoma pollinicola	2057025	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1304138264\|gb\|CP025096.1\|	2057025	g108702	i0	100	241.074626865672	268	0	100	0	1	268	8390589	8390322	Spirosoma pollinicola strain Ha7 chromosome, complete genome	blastn	64608	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma pollinicola
2307305	2307305	PRJNA1136505_P_NODE_69162_length_355_cov_2.031915_g62302_i0	PRJNA1136505	69162	355	2.031915	7.21329825	Weeksellaceae	2762318	Bacteria	Bacteria	612	1.2299999999999996e-170	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g62302	i0	97.746	480.202816901408	355	8	100	0	1	355	2158652	2158298	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	170472	617	0.991896272285251	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
2835192	2835192	PRJNA1136505_P_NODE_47623_length_460_cov_1.914729_g40764_i0	PRJNA1136505	47623	460	1.914729	8.8077534	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	640	7.489999999999999e-179	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g40764	i0	91.939	259.369565217391	459	33	99	3	2	456	2978209	2977751	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	119310	640	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
3582504	3582504	PRJNA1136505_P_NODE_39163_length_543_cov_1.097872_g32324_i0	PRJNA1136505	39163	543	1.097872	5.96144496	Segatella	2974251	Bacteria	Bacteria	970	0	NTclustered	gi\|2589387295\|gb\|CP134814.1\|	165179	g32324	i0	98.895	260.390423572744	543	6	100	0	1	543	2477114	2476572	Segatella copri strain H-2489 chromosome	blastn	141392	970	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
6134827	6134827	PRJNA1136505_P_NODE_146905_length_244_cov_0.947368_g140045_i0	PRJNA1136505	146905	244	0.947368	2.31157792	Flavobacterium	237	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2284918182\|gb\|CP100442.1\|	1114867	g140045	i0	100	551.532786885246	244	0	100	0	1	244	23234	22991	Flavobacterium plurextorum strain RSG-18 chromosome, complete genome	blastn	134574	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium plurextorum
8685089	8685089	PRJNA1136505_P_NODE_41967_length_510_cov_1.929062_g35113_i0	PRJNA1136505	41967	510	1.929062	9.8382162	Niastella	354354	Bacteria	Bacteria	819	0	NTclustered	gi\|470489618\|ref\|NR_076941.1\|	354356	g35113	i0	96.024	284.464705882353	503	20	99	0	6	508	1196	694	Niastella koreensis GR20-10 strain GR20-10 23S ribosomal RNA, complete sequence	blastn	145077	819	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella koreensis
10488038	10488038	PRJNA1136505_P_NODE_139249_length_247_cov_1.442529_g132389_i0	PRJNA1136505	139249	247	1.442529	3.56304663	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	169	2.1199999999999996e-37	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g132389	i0	79.365	17.8461538461538	252	42	100	10	1	247	3467247	3467493	Hymenobacter sp. APR13, complete genome	blastn	4408	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
12510726	12510726	PRJNA1136505_P_NODE_44210_length_488_cov_2.587952_g37351_i0	PRJNA1136505	44210	488	2.587952	12.62920576	Chryseobacterium	59732	Bacteria	Bacteria	811	0	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g37351	i0	96.721	453.934426229508	488	15	100	1	1	488	1783292	1783778	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	221520	811	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
12510737	12510737	PRJNA1136505_P_NODE_96670_length_293_cov_1.950000_g89810_i0	PRJNA1136505	96670	293	1.95	5.7135	Spirosoma	107	Bacteria	Bacteria	503	6.24e-138	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g89810	i0	97.611	173.327645051195	293	7	100	0	1	293	6729892	6730184	Spirosoma linguale DSM 74, complete genome	blastn	50785	508	0.990157480314961	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
14313429	14313429	PRJNA1136505_P_NODE_148792_length_243_cov_1.811765_g141932_i0	PRJNA1136505	148792	243	1.811765	4.40258895	Chryseobacterium gambrini	373672	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2429907221\|gb\|CP116008.1\|	373672	g141932	i0	99.177	8.04526748971193	243	2	100	0	1	243	4142684	4142926	Chryseobacterium gambrini strain DMF-6 chromosome, complete genome	blastn	1955	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
16334385	16334385	PRJNA1136505_P_NODE_119393_length_263_cov_2.910526_g112533_i0	PRJNA1136505	119393	263	2.910526	7.65468338	Chitinophaga	79328	Bacteria	Bacteria	442	1.2199999999999994e-119	NTclustered	gi\|2656636291\|gb\|CP140771.1\|	3108349	g112533	i0	96.958	3	263	8	100	0	1	263	2572048	2572310	Chitinophaga sp. 212800008-4 chromosome, complete genome	blastn	789	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. 212800008-4
16861580	16861580	PRJNA1136505_P_NODE_123414_length_259_cov_0.887097_g116554_i0	PRJNA1136505	123414	259	0.887097	2.29758123	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	270	5.98e-68	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g116554	i0	88.688	0.853281853281853	221	25	85	0	2	222	1557587	1557367	Lacibacter sp. MH-610 chromosome	blastn	221	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
18136166	18136166	PRJNA1136505_P_NODE_107595_length_278_cov_1.702439_g100735_i0	PRJNA1136505	107595	278	1.702439	4.73278042	Tannerella forsythia	28112	Bacteria	Bacteria	348	2.9100000000000003e-91	NTclustered	gi\|363406024\|gb\|CP003191.1\|	203275	g100735	i0	89.209	4.5	278	30	100	0	1	278	2573813	2573536	Tannerella forsythia 92A2, complete genome	blastn	1251	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella forsythia
19410459	19410459	PRJNA1136505_P_NODE_95276_length_296_cov_1.156951_g88416_i0	PRJNA1136505	95276	296	1.156951	3.42457496	Chryseobacterium sp. Y16C	2920939	Bacteria	Bacteria	542	1.34e-149	NTclustered	gi\|2204304890\|gb\|CP092711.1\|	2920939	g88416	i0	99.662	414.75	296	1	100	0	1	296	2576814	2576519	Chryseobacterium sp. Y16C chromosome, complete genome	blastn	122766	542	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. Y16C
21961273	21961273	PRJNA1136505_P_NODE_20458_length_1115_cov_2.268714_g14592_i0	PRJNA1136505	20458	1115	2.268714	25.2961611	Segatella copri	165179	Bacteria	Bacteria	1917	0	NTclustered	gi\|2733784973\|gb\|CP152348.1\|	165179	g14592	i0	97.676	292.325560538117	1119	20	100	5	1	1115	2738066	2736950	Segatella copri strain HDB01 chromosome, complete genome	blastn	325943	1917	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
21961306	21961306	PRJNA1136505_P_NODE_92558_length_301_cov_0.890351_g85698_i0	PRJNA1136505	92558	301	0.890351	2.67995651	Segatella copri	165179	Bacteria	Bacteria	429	1.11e-115	NTclustered	gi\|2127557433\|gb\|CP085934.1\|	537011	g85698	i0	92.359	400.800664451827	301	23	100	0	1	301	13368	13068	Segatella copri DSM 18205 strain FDAARGOS_1573 plasmid unnamed2, complete sequence	blastn	120641	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
23984297	23984297	PRJNA1136505_P_NODE_106979_length_279_cov_1.485437_g100119_i0	PRJNA1136505	106979	279	1.485437	4.14436923	Parabacteroides	375288	Bacteria	Bacteria	499	7.63e-137	NTclustered	gi\|2127587261\|gb\|CP085927.1\|	46503	g100119	i0	98.925	4	279	3	100	0	1	279	1203137	1202859	Parabacteroides merdae strain FDAARGOS_1586 chromosome, complete genome	blastn	1116	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides merdae
23984317	23984317	PRJNA1136505_P_NODE_48359_length_455_cov_1.149215_g41500_i0	PRJNA1136505	48359	455	1.149215	5.22892825	Hoylesella	2974257	Bacteria	Bacteria	819	0	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g41500	i0	99.121	248.294505494506	455	4	100	0	1	455	211010	210556	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	112974	819	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
25258305	25258305	PRJNA1136505_P_NODE_76760_length_335_cov_1.053435_g69900_i0	PRJNA1136505	76760	335	1.053435	3.52900725	Bacteroides	816	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2032857078\|gb\|CP072212.1\|	371601	g69900	i0	100	0.167164179104478	28	0	8	0	121	148	4122251	4122224	Bacteroides xylanisolvens strain CL11T00C41 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides xylanisolvens

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