metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA698538" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA698538" 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
681321	681321	PRJNA698538_S_NODE_14141_length_318_cov_2.069388_g13975_i0	PRJNA698538	14141	318	2.069388	6.58065384	Candidatus Chryseobacterium colombiense	3121364	Bacteria	Bacteria	477	4.149999999999998e-130	NTclustered	gi\|2457556413\|gb\|CP119310.1\|	3121364	g13975	i0	93.73	95.6415094339623	319	19	100	1	1	318	1399626	1399944	MAG: Candidatus Chryseobacterium colombiense isolate MAG_1654 chromosome, complete genome	blastn	30414	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Candidatus Chryseobacterium colombiense
681325	681325	PRJNA698538_S_NODE_14221_length_317_cov_4.303279_g14055_i0	PRJNA698538	14221	317	4.303279	13.64139443	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g14055	i0	100	0.0946372239747634	30	0	9	0	35	64	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
1957345	1957345	PRJNA698538_S_NODE_21322_length_276_cov_129.783251_g21156_i0	PRJNA698538	21322	276	129.783251	358.20177276	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	62.1	4.22e-5	NTclustered	gi\|2717309477\|emb\|OZ032149.1\|	336810	g21156	i0	97.222	0.130434782608696	36	1	13	0	110	145	226088	226053	Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1	blastn	36	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
5784759	5784759	PRJNA698538_S_NODE_15425_length_310_cov_1.949367_g15259_i0	PRJNA698538	15425	310	1.949367	6.0430377	Epilithonimonas zeae	1416779	Bacteria	Bacteria	459	1.46e-124	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g15259	i0	93.77	98.6064516129032	305	19	98	0	1	305	2080415	2080719	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	30568	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
10885324	10885324	PRJNA698538_S_NODE_14429_length_316_cov_2.111111_g14263_i0	PRJNA698538	14429	316	2.111111	6.67111076	Mucilaginibacter gotjawali	1550579	Bacteria	Bacteria	564	3.069999999999999e-156	NTclustered	gi\|998615918\|dbj\|AP017313.1\|	1550579	g14263	i0	98.742	281.575949367089	318	2	100	1	1	316	429078	428761	Mucilaginibacter gotjawali DNA, complete genome	blastn	88978	564	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter gotjawali
15212623	15212623	PRJNA698538_S_NODE_11232_length_339_cov_2.845865_g11066_i0	PRJNA698538	11232	339	2.845865	9.64748235	Elizabethkingia	308865	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g11066	i0	99.705	90	339	1	100	0	1	339	4096190	4096528	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	30510	621	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
19035836	19035836	PRJNA698538_S_NODE_10735_length_343_cov_2.811111_g10569_i0	PRJNA698538	10735	343	2.811111	9.64211073	Weeksellaceae	2762318	Bacteria	Bacteria	575	1.5599999999999995e-159	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g10569	i0	97.892	502.31778425656	332	7	97	0	1	332	1757325	1757656	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	172295	580	0.991379310344828	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19035840	19035840	PRJNA698538_S_NODE_11855_length_334_cov_3.969349_g11689_i0	PRJNA698538	11855	334	3.969349	13.25762566	Myroides	76831	Bacteria	Bacteria	484	2.6199999999999996e-132	NTclustered	gi\|969868918\|gb\|CP013690.1\|	76832	g11689	i0	92.814	99.8652694610778	334	24	100	0	1	334	511367	511700	Myroides odoratimimus strain PR63039 chromosome, complete genome	blastn	33355	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
19035875	19035875	PRJNA698538_S_NODE_9295_length_356_cov_1.632509_g9129_i0	PRJNA698538	9295	356	1.632509	5.81173204	Chryseobacterium	59732	Bacteria	Bacteria	652	0	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g9129	i0	99.719	99.9859550561798	356	1	100	0	1	356	2456145	2456500	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	35595	652	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
22861549	22861549	PRJNA698538_S_NODE_16118_length_305_cov_4.978448_g15952_i0	PRJNA698538	16118	305	4.978448	15.1842664	Aquirufa	2676247	Bacteria	Bacteria	309	1.53e-79	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g15952	i0	85.246	100.045901639344	305	40	99	5	1	301	214089	214392	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	30514	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis

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