metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA981359" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA981359" 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
4790620	4790620	PRJNA981359_S_NODE_42364_length_297_cov_1.428571_g42264_i0	PRJNA981359	42364	297	1.428571	4.24285587	Flavobacterium sp. GSB-24	2994319	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2415636785\|dbj\|AP027043.1\|	2994319	g42264	i0	90.476	0.141414141414141	42	0	14	3	139	180	3956794	3956831	Flavobacterium sp. GSB-24 DNA, complete genome	blastn	42	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. GSB-24
11166416	11166416	PRJNA981359_S_NODE_58769_length_263_cov_2.873684_g58669_i0	PRJNA981359	58769	263	2.873684	7.55778892	Chryseobacterium daecheongense	192389	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2222664923\|gb\|CP095185.1\|	192389	g58669	i0	100	0.106463878326996	28	0	11	0	234	261	3176588	3176615	Chryseobacterium daecheongense strain F23 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
11474510	11474510	PRJNA981359_S_NODE_24989_length_342_cov_3.654275_g24889_i0	PRJNA981359	24989	342	3.654275	12.4976205	Polaribacter	52959	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1149028905\|gb\|CP019704.1\|	1529069	g24889	i0	100	0.245614035087719	28	0	8	0	176	203	1519928	1519901	Polaribacter sp. BM10 chromosome, complete genome	blastn	84	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter sp. BM10
12440755	12440755	PRJNA981359_S_NODE_10070_length_419_cov_2.028902_g9970_i0	PRJNA981359	10070	419	2.028902	8.50109938	Psychroflexus sp. ALD_RP9	2777186	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1999269559\|gb\|CP062973.1\|	2777186	g9970	i0	100	0.0668257756563246	28	0	7	0	270	297	2267100	2267127	Psychroflexus sp. ALD_RP9 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroflexus	Psychroflexus sp. ALD_RP9
17540154	17540154	PRJNA981359_S_NODE_30934_length_325_cov_1.611111_g30834_i0	PRJNA981359	30934	325	1.611111	5.23611075	Aquimarina sp. AD10	1714849	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1468738248\|gb\|CP031965.1\|	1714849	g30834	i0	100	0.0861538461538462	28	0	9	0	270	297	1460222	1460195	Aquimarina sp. AD10 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. AD10
17540622	17540622	PRJNA981359_S_NODE_47694_length_285_cov_3.410377_g47594_i0	PRJNA981359	47694	285	3.410377	9.71957445	Aureibaculum algae	2584122	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1678494258\|gb\|CP040749.1\|	2584122	g47594	i0	100	0.0982456140350877	28	0	10	0	245	272	223896	223923	Aureibaculum algae strain 10Alg 115 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureibaculum	Aureibaculum algae
21363725	21363725	PRJNA981359_S_NODE_10477_length_415_cov_3.994152_g10377_i0	PRJNA981359	10477	415	3.994152	16.5757308	Imtechella halotolerans	1165090	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2572593368\|gb\|CP117969.2\|	1165090	g10377	i0	100	0.0698795180722892	29	0	7	0	385	413	732778	732806	Imtechella halotolerans strain JCM 17677 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Imtechella	Imtechella halotolerans
22639963	22639963	PRJNA981359_S_NODE_53678_length_273_cov_2.115000_g53578_i0	PRJNA981359	53678	273	2.115	5.77395	Flavobacterium crassostreae	1763534	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1089747896\|gb\|CP017688.1\|	1763534	g53578	i0	100	0.102564102564103	28	0	10	0	102	129	1632350	1632377	Flavobacterium crassostreae strain LPB0076 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium crassostreae
22640402	22640402	PRJNA981359_S_NODE_6938_length_458_cov_5.449351_g6839_i0	PRJNA981359	6938	458	5.449351	24.95802758	Chryseobacterium suipulveris	2929800	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2216359423\|gb\|CP094532.1\|	2929800	g6839	i0	100	0.0633187772925764	29	0	6	0	306	334	2143799	2143771	Chryseobacterium suipulveris strain SC2-2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium suipulveris
23915223	23915223	PRJNA981359_S_NODE_42219_length_297_cov_2.437500_g42119_i0	PRJNA981359	42219	297	2.4375	7.239375	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	538	1.74e-148	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g42119	i0	99.327	3	297	2	100	0	1	297	1511507	1511211	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	891	538	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
25188683	25188683	PRJNA981359_S_NODE_38940_length_305_cov_1.137931_g38840_i0	PRJNA981359	38940	305	1.137931	3.47068955	Sediminicola sp. YIK13	1453352	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|946526387\|gb\|CP010535.1\|	1453352	g38840	i0	100	0.0918032786885246	28	0	9	0	276	303	661705	661732	Sediminicola sp. YIK13 isolate Sediment chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Sediminicola	Sediminicola sp. YIK13

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