metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA795983" 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
780154	780154	PRJNA795983_S_NODE_34321_length_255_cov_1.263736_g34196_i0	PRJNA795983	34321	255	1.263736	3.2225268	Dyadobacter sp. 676	3088362	Bacteria	Bacteria	209	1.3e-49	NTclustered	gi\|2752922223\|gb\|CP159289.1\|	3088362	g34196	i0	86.07	213.678431372549	201	20	77	8	1	196	3093395	3093198	Dyadobacter sp. 676 chromosome, complete genome	blastn	54488	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 676
2056143	2056143	PRJNA795983_S_NODE_41542_length_243_cov_0.905882_g41417_i0	PRJNA795983	41542	243	0.905882	2.20129326	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2193939264\|gb\|CP077751.1\|	1117645	g41417	i0	99.177	16.9259259259259	243	2	100	0	1	243	2844465	2844223	Elizabethkingia anophelis strain 2008N07-201 chromosome, complete genome	blastn	4113	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
4608659	4608659	PRJNA795983_S_NODE_604_length_1136_cov_4.715898_g551_i0	PRJNA795983	604	1136	4.715898	53.57260128	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	1507	0	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g551	i0	90.726	400.731514084507	1143	88	99	15	1	1135	955853	954721	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	455231	1507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
8433020	8433020	PRJNA795983_S_NODE_10947_length_376_cov_2.861386_g10822_i0	PRJNA795983	10947	376	2.861386	10.75881136	Fulvivirga ulvae	2904245	Bacteria	Bacteria	483	1.07e-131	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g10822	i0	90.107	296.893617021277	374	34	99	3	6	376	447636	448009	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	111632	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae
10145001	10145001	PRJNA795983_S_NODE_30588_length_266_cov_1.155440_g30463_i0	PRJNA795983	30588	266	1.15544	3.0734704	Flavobacterium	237	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|1387106870\|gb\|CP029186.1\|	2175091	g30463	i0	97.744	524.139097744361	266	6	100	0	1	266	382774	382509	Flavobacterium album strain HYN0059 chromosome, complete genome	blastn	139421	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium album
10145009	10145009	PRJNA795983_S_NODE_35168_length_252_cov_2.737430_g35043_i0	PRJNA795983	35168	252	2.73743	6.8983236	Bacteroidota	976	Bacteria	Bacteria	220	5.919999999999999e-53	NTclustered	gi\|2621711850\|emb\|OY769938.1\|	2021391	g35043	i0	87.31	184.496031746032	197	20	77	5	58	252	680249	680056	MAG: Flavobacteriales bacterium isolate 8533b3cd-f90e-4a47-8fbb-482e72fcba36 genome assembly, chromosome: 1	blastn	46493	222	0.990990990990991	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
10984146	10984146	PRJNA795983_S_NODE_38609_length_247_cov_0.885057_g38484_i0	PRJNA795983	38609	247	0.885057	2.18609079	Chryseobacterium paludis	2956784	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2308166955\|gb\|CP099966.1\|	2956784	g38484	i0	96.97	2.28744939271255	33	1	13	0	215	247	4311484	4311516	Chryseobacterium sp. CJ51 chromosome, complete genome	blastn	565	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium paludis
13533778	13533778	PRJNA795983_S_NODE_33011_length_258_cov_2.313514_g32886_i0	PRJNA795983	33011	258	2.313514	5.96886612	Prevotella melaninogenica	28132	Bacteria	Bacteria	473	4.2299999999999996e-129	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g32886	i0	100	226.414728682171	256	0	99	0	1	256	698109	698364	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	58415	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
14808674	14808674	PRJNA795983_S_NODE_27612_length_275_cov_3.000000_g27487_i0	PRJNA795983	27612	275	3	8.25	Pseudotamlana carrageenivorans	2069432	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1332718063\|gb\|CP025938.1\|	2069432	g27487	i0	100	0.105454545454545	29	0	11	0	213	241	2249389	2249417	Pseudotamlana carrageenivorans strain UJ94 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pseudotamlana	Pseudotamlana carrageenivorans
18631508	18631508	PRJNA795983_S_NODE_1655_length_776_cov_4.829303_g1558_i0	PRJNA795983	1655	776	4.829303	37.47539128	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	889	0	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g1558	i0	87.5	434.275773195876	784	80	100	15	1	776	954754	953981	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	336998	889	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
19068203	19068203	PRJNA795983_S_NODE_39235_length_246_cov_0.890173_g39110_i0	PRJNA795983	39235	246	0.890173	2.18982558	Flavobacterium	237	Bacteria	Bacteria	206	1.61e-48	NTclustered	gi\|2496343437\|gb\|CP092332.1\|	1306518	g39110	i0	82.083	3.90243902439024	240	43	98	0	2	241	2243201	2242962	Flavobacterium keumense strain K3R-10 chromosome, complete genome	blastn	960	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium keumense
22457424	22457424	PRJNA795983_S_NODE_42218_length_242_cov_0.911243_g42093_i0	PRJNA795983	42218	242	0.911243	2.20520806	Flavobacterium indicum	312277	Bacteria	Bacteria	368	1.91e-97	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g42093	i0	94.191	3.61570247933884	241	14	99	0	2	242	2979885	2980125	Flavobacterium indicum GPTSA100-9 complete genome	blastn	875	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
25443281	25443281	PRJNA795983_S_NODE_42380_length_242_cov_0.911243_g42255_i0	PRJNA795983	42380	242	0.911243	2.20520806	Emticicia	312278	Bacteria	Bacteria	412	8.68e-111	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g42255	i0	97.521	267.425619834711	242	4	100	2	1	242	1544	1783	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	64717	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica

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