metadata: contig_metadata: 19 rows where bioproject = "PRJNA287283" and tax

19 rows where bioproject = "PRJNA287283" 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
1059223	1059223	PRJNA287283_P_NODE_1961_length_480_cov_2.234192_g1741_i0	PRJNA287283	1961	480	2.234192	10.7241216	Flavobacterium	237	Bacteria	Bacteria	887	0	NTclustered	gi\|470491666\|ref\|NR_077051.1\|	312277	g1741	i0	100	647.404166666667	480	0	100	0	1	480	1950	2429	Flavobacterium indicum strain GPTSA100-9 23S ribosomal RNA gene, complete sequence	blastn	310754	887	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
1059230	1059230	PRJNA287283_P_NODE_5601_length_248_cov_0.861538_g5377_i0	PRJNA287283	5601	248	0.861538	2.13661424	Hymenobacter	89966	Bacteria	Bacteria	385	1.95e-102	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g5377	i0	94.737	284.20564516129	247	13	99	0	1	247	243165	242919	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	70483	385	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
1646947	1646947	PRJNA287283_P_NODE_5402_length_255_cov_1.084158_g5178_i0	PRJNA287283	5402	255	1.084158	2.7646029	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	462	9.03e-126	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g5178	i0	99.605	79.3058823529412	253	1	99	0	1	253	55740	55488	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	20223	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
5475595	5475595	PRJNA287283_P_NODE_10045_length_176_cov_1.544715_g9821_i0	PRJNA287283	10045	176	1.544715	2.7186984	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	252	1.36e-62	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g9821	i0	93.529	229.261363636364	170	9	96	2	8	176	3368	3536	Dyadobacter pollutisoli strain U1 chromosome	blastn	40350	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
5475605	5475605	PRJNA287283_P_NODE_5485_length_252_cov_0.924623_g5261_i0	PRJNA287283	5485	252	0.924623	2.33004996	Hymenobacter sedentarius	1411621	Bacteria	Bacteria	322	1.58e-83	NTclustered	gi\|972940812\|gb\|CP013909.1\|	1411621	g5261	i0	89.804	229.15873015873	255	21	100	5	1	252	1392373	1392121	Hymenobacter sedentarius strain DG5B chromosome, complete genome	blastn	57748	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sedentarius
5475613	5475613	PRJNA287283_P_NODE_8265_length_185_cov_1.159091_g8041_i0	PRJNA287283	8265	185	1.159091	2.14431835	Hymenobacter canadensis	2999067	Bacteria	Bacteria	324	3.03e-84	NTclustered	gi\|2417460668\|gb\|CP114767.1\|	2999067	g8041	i0	98.37	325.221621621622	184	3	99	0	1	184	2161742	2161559	Hymenobacter canadensis strain PAMC 29467 chromosome, complete genome	blastn	60166	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter canadensis
10576129	10576129	PRJNA287283_P_NODE_4989_length_270_cov_1.428571_g4765_i0	PRJNA287283	4989	270	1.428571	3.8571417	uncultured Sunxiuqinia sp.	1573825	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2907625748\|emb\|OZ223308.1\|	1573825	g4765	i0	100	0.103703703703704	28	0	10	0	228	255	195721	195694	MAG: uncultured Sunxiuqinia sp. isolate ca0ff389-0d66-4f98-8792-5b2e3713dedf genome assembly, chromosome: 2	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Sunxiuqinia	uncultured Sunxiuqinia sp.
11262368	11262368	PRJNA287283_P_NODE_10209_length_176_cov_0.910569_g9985_i0	PRJNA287283	10209	176	0.910569	1.60260144	Tannerella	195950	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|363406024\|gb\|CP003191.1\|	203275	g9985	i0	100	3	176	0	100	0	1	176	299409	299584	Tannerella forsythia 92A2, complete genome	blastn	528	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella forsythia
11262375	11262375	PRJNA287283_P_NODE_7709_length_194_cov_1.354610_g7485_i0	PRJNA287283	7709	194	1.35461	2.6279434	Prevotella	838	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|1139267393\|emb\|LT681025.1\|	28133	g7485	i0	100	116	194	0	100	0	1	194	392	199	Prevotella nigrescens partial 16S rRNA gene, isolate 438T_6439	blastn	22504	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
11850833	11850833	PRJNA287283_P_NODE_6290_length_228_cov_1.074286_g6066_i0	PRJNA287283	6290	228	1.074286	2.44937208	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	405	1.35e-108	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g6066	i0	98.684	249.162280701754	228	3	100	0	1	228	54619	54846	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	56809	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
12537698	12537698	PRJNA287283_P_NODE_810_length_813_cov_3.228947_g640_i0	PRJNA287283	810	813	3.228947	26.25133911	Hymenobacter	89966	Bacteria	Bacteria	1277	0	NTclustered	gi\|926465561\|gb\|CP012623.1\|	1385663	g640	i0	95.068	305.829028290283	811	40	99	0	3	813	763242	762432	Hymenobacter sp. DG25A, complete genome	blastn	248639	1277	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG25A
15086780	15086780	PRJNA287283_P_NODE_2512_length_413_cov_1.388889_g2289_i0	PRJNA287283	2512	413	1.388889	5.73611157	Flavobacterium	237	Bacteria	Bacteria	667	0	NTclustered	gi\|396083863\|gb\|JX114378.1\|	165435	g2289	i0	95.874	120.825665859564	412	17	99	0	2	413	1013	1424	Uncultured Flavobacterium sp. clone SNNP_2012-45 16S ribosomal RNA gene, partial sequence	blastn	49901	669	0.997010463378176	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
15674907	15674907	PRJNA287283_P_NODE_3913_length_320_cov_1.408240_g3689_i0	PRJNA287283	3913	320	1.40824	4.506368	Flavobacterium sp.	239	Bacteria	Bacteria	512	1.1499999999999998e-140	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g3689	i0	95.611	479.490625	319	14	99	0	2	320	236039	235721	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	153437	512	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
18223848	18223848	PRJNA287283_P_NODE_7515_length_198_cov_0.910345_g7291_i0	PRJNA287283	7515	198	0.910345	1.8024831	Flavobacterium channae	2897181	Bacteria	Bacteria	292	9.29e-75	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g7291	i0	93.434	447.338383838384	198	11	99	2	1	196	485844	486041	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	88573	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
19498125	19498125	PRJNA287283_P_NODE_7436_length_199_cov_1.452055_g7212_i0	PRJNA287283	7436	199	1.452055	2.88958945	Capnocytophaga granulosa	45242	Bacteria	Bacteria	335	1.5299999999999996e-87	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g7212	i0	96.985	251.1608040201	199	6	100	0	1	199	1524130	1523932	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	49981	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
27832200	27832200	PRJNA287283_P_NODE_9424_length_179_cov_0.888889_g9200_i0	PRJNA287283	9424	179	0.888889	1.59111131	Rikenellaceae bacterium	2049048	Bacteria	Bacteria	42.4	0.0216	NR	MFI3265974.1	2049048	g9200	i0	44.7	0.636871508379888	38	21	63.7	0	176	63	161	198	MFI3265974.1 ammonium transporter [Rikenellaceae bacterium]	diamond	114	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae		Rikenellaceae bacterium
29221705	29221705	PRJNA287283_P_NODE_10269_length_176_cov_0.910569_g10045_i0	PRJNA287283	10269	176	0.910569	1.60260144	Flavobacterium indicum	312277	Bacteria	Bacteria	119	7.439999999999999e-30	NR	WP_014389705.1	312277	g10045	i0	93.1	0.988636363636364	58	4	98.9	0	3	176	62	119	WP_014389705.1 OmpA family protein [Flavobacterium indicum]	diamond	174	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
29902351	29902351	PRJNA287283_P_NODE_9951_length_177_cov_0.903226_g9727_i0	PRJNA287283	9951	177	0.903226	1.59871002	root	1	Root_unresolved	Root_unresolved	44.3	0.0046	NR	WP_144887603.1	510947	g9727	i0	37	2.20338983050847	46	29	78	0	25	162	42	87	WP_144887603.1 caspase family protein [Lacibacter cauensis]	diamond	390	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter cauensis
32823813	32823813	PRJNA287283_P_NODE_8420_length_183_cov_0.861538_g8196_i0	PRJNA287283	8420	183	0.861538	1.57661454	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.5	0.00896	NR	MBN2173308.1	2030927	g8196	i0	42.6	1.59016393442623	54	24	80.3	3	170	24	158	209	MBN2173308.1 PAN domain-containing protein [Bacteroidales bacterium]	diamond	291	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;