metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA715461" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA715461" 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
705120	705120	PRJNA715461_S_NODE_21_length_1220_cov_68.383609_g11_i0	PRJNA715461	21	1220	68.383609	834.2800298	Phocaeicola coprophilus	387090	Bacteria	Bacteria	1777	0	NTclustered	gi\|1985970415\|gb\|CP069440.1\|	387090	g11	i0	95.594	462.899180327869	1112	44	91	5	108	1217	2866949	2868057	Phocaeicola coprophilus strain FDAARGOS_1220 chromosome, complete genome	blastn	564737	1777	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola coprophilus
5808774	5808774	PRJNA715461_S_NODE_145_length_687_cov_7.045603_g101_i0	PRJNA715461	145	687	7.045603	48.40329261	Fulvivirga ulvae	2904245	Bacteria	Bacteria	616	1.9399999999999998e-171	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g101	i0	87.138	196.823871906841	552	60	79	11	59	603	447629	448176	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	135218	616	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae
6296253	6296253	PRJNA715461_S_NODE_85_length_907_cov_2837.666667_g2_i2	PRJNA715461	85	907	2837.666667	25737.63666969	Chryseobacterium	59732	Bacteria	Bacteria	1415	0	NTclustered	gi\|399572466\|gb\|JQ918520.1\|	152509	g2	i2	99.87	244.646085997795	769	1	85	0	56	824	1	769	Uncultured Bacteroidetes bacterium clone Cd5d841 16S ribosomal RNA gene, partial sequence	blastn	221894	1419	0.997181113460183	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
9633678	9633678	PRJNA715461_S_NODE_808_length_281_cov_11347.692308_g734_i0	PRJNA715461	808	281	11347.692308	31887.01538548	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	278	3.9300000000000005e-70	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g734	i0	90.187	282.861209964413	214	19	75	2	67	278	1075678	1075465	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	79484	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
10120771	10120771	PRJNA715461_S_NODE_168_length_636_cov_5.815275_g119_i0	PRJNA715461	168	636	5.815275	36.985149	Flavobacterium	237	Bacteria	Bacteria	1037	0	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g119	i0	99.647	400.196540880503	567	2	89	0	67	633	717988	718554	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	254525	1037	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
10120774	10120774	PRJNA715461_S_NODE_248_length_556_cov_6.287785_g192_i0	PRJNA715461	248	556	6.287785	34.9600846	Flavobacterium	237	Bacteria	Bacteria	760	0	NTclustered	gi\|1810685637\|gb\|MH028244.2\|	2565924	g192	i0	97.111	99.4424460431655	450	13	81	0	103	552	451	2	Flavobacterium supellecticarium strain CC-CTC003 16S ribosomal RNA gene, partial sequence	blastn	55290	760	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium supellecticarium
10909216	10909216	PRJNA715461_S_NODE_209_length_596_cov_7.059273_g158_i0	PRJNA715461	209	596	7.059273	42.07326708	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	946	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g158	i0	96.831	393.827181208054	568	15	95	2	4	568	360564	361131	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	234721	946	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
12184450	12184450	PRJNA715461_S_NODE_1110_length_238_cov_14723.830303_g1036_i0	PRJNA715461	1110	238	14723.830303	35042.71612114	Fibrella aestuarina	651143	Bacteria	Bacteria	226	1.1899999999999999e-54	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g1036	i0	92.593	50.4663865546218	162	4	66	6	82	238	609888	609730	Fibrella aestuarina BUZ 2 drat genome	blastn	12011	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
12184457	12184457	PRJNA715461_S_NODE_350_length_460_cov_5088.449612_g23_i1	PRJNA715461	350	460	5088.449612	23406.8682152	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	531	4.6999999999999984e-146	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g23	i1	92.308	197.534782608696	377	24	82	3	82	457	217438	217066	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	90866	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
17283211	17283211	PRJNA715461_S_NODE_574_length_358_cov_180.659649_g500_i0	PRJNA715461	574	358	180.659649	646.76154342	Fibrella aestuarina	651143	Bacteria	Bacteria	446	1.33e-120	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g500	i0	98.8	25.9916201117318	250	3	70	0	2	251	609817	610066	Fibrella aestuarina BUZ 2 drat genome	blastn	9305	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
17283212	17283212	PRJNA715461_S_NODE_654_length_324_cov_18869.003984_g580_i0	PRJNA715461	654	324	18869.003984	61135.57290816	Chryseobacterium sp. E1	2853434	Bacteria	Bacteria	394	4.39e-105	NTclustered	gi\|2065946897\|gb\|CP078104.1\|	2853434	g580	i0	95.918	331.947530864198	245	6	76	2	80	324	1142403	1142643	Chryseobacterium sp. E1 chromosome, complete genome	blastn	107551	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. E1
17769916	17769916	PRJNA715461_S_NODE_594_length_348_cov_6970.640000_g520_i0	PRJNA715461	594	348	6970.64	24257.8272	Chryseobacterium	59732	Bacteria	Bacteria	483	9.859999999999999e-132	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g520	i0	98.893	217.198275862069	271	2	78	1	3	272	2629617	2629347	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	75585	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
19043972	19043972	PRJNA715461_S_NODE_1075_length_242_cov_3308.278107_g1001_i0	PRJNA715461	1075	242	3308.278107	8006.03301894	Chitinophaga	79328	Bacteria	Bacteria	202	2.0499999999999998e-47	NTclustered	gi\|2656636291\|gb\|CP140771.1\|	3108349	g1001	i0	95.276	125.214876033058	127	6	52	0	3	129	6704453	6704327	Chitinophaga sp. 212800008-4 chromosome, complete genome	blastn	30302	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. 212800008-4
20318623	20318623	PRJNA715461_S_NODE_856_length_272_cov_4.135678_g782_i0	PRJNA715461	856	272	4.135678	11.24904416	Bacteroidota	976	Bacteria	Bacteria	239	1.78e-58	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g782	i0	88.832	313.158088235294	197	19	72	3	69	264	565698	565504	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	85179	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
21107573	21107573	PRJNA715461_S_NODE_37_length_1088_cov_107.059113_g23_i0	PRJNA715461	37	1088	107.059113	1164.80314944	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	1212	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g23	i0	89.648	445.807904411765	966	81	88	17	4	960	217066	218021	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	485039	1212	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
21594446	21594446	PRJNA715461_S_NODE_637_length_330_cov_7329.007782_g563_i0	PRJNA715461	637	330	7329.007782	24185.7256806	Imperialibacter	1649461	Bacteria	Bacteria	159	1.78e-34	NTclustered	gi\|2597771528\|gb\|CP136051.1\|	1324217	g563	i0	83.146	80.5121212121212	178	26	53	3	72	247	4788595	4788420	Imperialibacter roseus strain P4T chromosome, complete genome	blastn	26569	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Imperialibacter	Imperialibacter roseus
25418732	25418732	PRJNA715461_S_NODE_1200_length_228_cov_12216.361290_g1126_i0	PRJNA715461	1200	228	12216.36129	27853.3037412	Flectobacillus	101	Bacteria	Bacteria	270	5.15e-68	NTclustered	gi\|2868812398\|dbj\|LC855767.1\|	50419	g1126	i0	100	64.0877192982456	146	0	64	0	83	228	399	254	Flectobacillus sp. FWB18 gene for 16S ribosomal RNA, partial sequence	blastn	14612	272	0.992647058823529	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.

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