metadata: contig_metadata: 15 rows where bioproject = "PRJNA1145574" and tax

15 rows where bioproject = "PRJNA1145574" 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
2839499	2839499	PRJNA1145574_P_NODE_15023_length_231_cov_2.949367_g14839_i0	PRJNA1145574	15023	231	2.949367	6.81303777	Chryseobacterium gambrini	373672	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g14839	i0	100	483.25974025974	231	0	100	0	1	231	1758315	1758545	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	111633	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
4861372	4861372	PRJNA1145574_P_NODE_4364_length_399_cov_1.196319_g4180_i0	PRJNA1145574	4364	399	1.196319	4.77331281	Cytophagales	768507	Bacteria	Bacteria	403	9.16e-108	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g4180	i0	86.053	290.097744360902	380	47	94	6	24	399	358998	359375	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	115749	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
5391885	5391885	PRJNA1145574_P_NODE_3805_length_423_cov_0.974286_g3621_i0	PRJNA1145574	3805	423	0.974286	4.12122978	Amniculibacterium sp. G2-70	2767188	Bacteria	Bacteria	765	0	NTclustered	gi\|1898132275\|gb\|CP060698.1\|	2767188	g3621	i0	99.291	379.330969267139	423	3	100	0	1	423	425648	426070	Amniculibacterium sp. G2-70 chromosome, complete genome	blastn	160457	765	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Amniculibacterium	Amniculibacterium sp. G2-70
6666623	6666623	PRJNA1145574_P_NODE_8746_length_291_cov_0.981651_g8562_i0	PRJNA1145574	8746	291	0.981651	2.85660441	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	74.3	5.11e-13	NR	MDI9406512.1	1869212	g8562	i0	100	0.391752577319588	38	0	39.2	0	290	177	652	689	MDI9406512.1 cation:proton antiporter [Chitinophagaceae bacterium]	diamond	114	74.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
6666625	6666625	PRJNA1145574_P_NODE_9046_length_286_cov_1.098592_g8862_i0	PRJNA1145574	9046	286	1.098592	3.14197312	Wenyingzhuangia fucanilytica	1790137	Bacteria	Bacteria	399	8.189999999999999e-107	NTclustered	gi\|1049070564\|gb\|CP014224.1\|	1790137	g8862	i0	91.958	227.979020979021	286	22	100	1	1	286	437064	437348	Wenyingzhuangia fucanilytica strain CZ1127 chromosome, complete genome	blastn	65202	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Wenyingzhuangia	Wenyingzhuangia fucanilytica
7411202	7411202	PRJNA1145574_P_NODE_9806_length_273_cov_1.145000_g9622_i0	PRJNA1145574	9806	273	1.145	3.12585	Tenacibaculum	104267	Bacteria	Bacteria	388	1.68e-103	NTclustered	gi\|2431612876\|gb\|CP116303.1\|	2781243	g9622	i0	92.593	462.981684981685	270	20	100	0	1	270	257944	258213	Tenacibaculum finnmarkense strain 20-4106-2 chromosome, complete genome	blastn	126394	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum finnmarkense
10492272	10492272	PRJNA1145574_P_NODE_11489_length_252_cov_0.871508_g11305_i0	PRJNA1145574	11489	252	0.871508	2.19620016	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	387	5.519999999999998e-103	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g11305	i0	94.444	20.5952380952381	252	13	100	1	1	252	2197429	2197679	Pedobacter sp. SL55 chromosome	blastn	5190	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
14317526	14317526	PRJNA1145574_P_NODE_10232_length_265_cov_1.572917_g10048_i0	PRJNA1145574	10232	265	1.572917	4.16823005	Flavobacterium	237	Bacteria	Bacteria	180	2.7799999999999995e-54	NR	MFM7896542.1	239	g10048	i0	98.9	3.91698113207547	87	1	98.5	0	5	265	191	277	MFM7896542.1 peroxidase family protein [Flavobacterium sp.]	diamond	1038	180	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
16335683	16335683	PRJNA1145574_P_NODE_10213_length_265_cov_2.833333_g10029_i0	PRJNA1145574	10213	265	2.833333	7.50833245	Aquirufa	2676247	Bacteria	Bacteria	243	1.34e-59	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g10029	i0	83.271	24.0943396226415	269	40	100	5	1	265	214078	214345	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	6385	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
16865812	16865812	PRJNA1145574_P_NODE_2634_length_503_cov_2.027907_g2452_i0	PRJNA1145574	2634	503	2.027907	10.20037221	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|1893901230\|gb\|CP059182.1\|	1653831	g2452	i0	100	0.0576540755467197	29	0	6	0	240	268	581295	581323	Blattabacterium cuenoti strain THEREAreg chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
26912269	26912269	PRJNA1145574_P_NODE_11982_length_250_cov_0.881356_g11798_i0	PRJNA1145574	11982	250	0.881356	2.20339	Bacteroidota bacterium	1898104	Bacteria	Bacteria	165	2.6099999999999998e-48	NR	MFM7723481.1	1898104	g11798	i0	92.8	1.992	83	6	99.6	0	2	250	98	180	MFM7723481.1 M20/M25/M40 family metallo-hydrolase [Bacteroidota bacterium]	diamond	498	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28207377	28207377	PRJNA1145574_P_NODE_11446_length_252_cov_0.871508_g11262_i0	PRJNA1145574	11446	252	0.871508	2.19620016	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	165	2.44e-48	NR	HXI97449.1	2026741	g11262	i0	95.2	1.97619047619048	83	4	98.8	0	250	2	137	219	HXI97449.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	498	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30196765	30196765	PRJNA1145574_P_NODE_9652_length_275_cov_1.544554_g9468_i0	PRJNA1145574	9652	275	1.544554	4.2475235	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	52	3.56e-6	NR	WP_269014027.1	2516557	g9468	i0	49.1	0.578181818181818	53	27	57.8	0	76	234	10	62	WP_269014027.1 hypothetical protein [Aquirufa nivalisilvae]	diamond	159	52	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
30533353	30533353	PRJNA1145574_P_NODE_13513_length_246_cov_0.901734_g13329_i0	PRJNA1145574	13513	246	0.901734	2.21826564	Bacteroidota	976	Bacteria	Bacteria	134	7.66e-36	NR	MEO0340896.1	1898104	g13329	i0	80.2	4.97560975609756	81	16	98.8	0	4	246	22	102	MEO0340896.1 aspartate aminotransferase family protein [Bacteroidota bacterium]	diamond	1224	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32030530	32030530	PRJNA1145574_P_NODE_1458_length_686_cov_4.642741_g1280_i0	PRJNA1145574	1458	686	4.642741	31.84920326	Mariniphaga sp.	1954475	Bacteria	Bacteria	83.6	6.29e-16	NR	MEI7526304.1	1954475	g1280	i0	37	3.2798833819242	146	89	62.5	3	431	3	13	158	MEI7526304.1 5'-nucleotidase [Mariniphaga sp.]	diamond	2250	84.3	0.991696322657177	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Mariniphaga	Mariniphaga 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);;