metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1145574" and tax

8 rows where analysis = "blastn", 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
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
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

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