metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1193541" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1193541" and tax_phylum = "Bacteroidota"

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
320662	320662	PRJNA1193541_P_NODE_15181_length_241_cov_0.910714_g15043_i0	PRJNA1193541	15181	241	0.910714	2.19482074	Chryseobacterium sp.	1871047	Bacteria	Bacteria	143	1.2499999999999998e-29	NTclustered	gi\|1757093052\|gb\|CP044507.1\|	1871047	g15043	i0	89.381	1.33195020746888	113	12	47	0	1	113	1330349	1330461	Chryseobacterium sp. strain SNU WT7 chromosome, complete genome	blastn	321	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
320817	320817	PRJNA1193541_P_NODE_8381_length_301_cov_1.350877_g8243_i0	PRJNA1193541	8381	301	1.350877	4.06613977	Pseudobacter ginsenosidimutans	661488	Bacteria	Bacteria	472	1.81e-128	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g8243	i0	95.05	249.016611295681	303	10	100	5	1	301	498910	498611	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	74954	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
1042383	1042383	PRJNA1193541_P_NODE_14681_length_242_cov_1.366864_g14543_i0	PRJNA1193541	14681	242	1.366864	3.30781088	Weeksellaceae	2762318	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g14543	i0	100	328.756198347107	242	0	100	0	1	242	36875	36634	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	79559	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
1595235	1595235	PRJNA1193541_P_NODE_13342_length_247_cov_0.885057_g13204_i0	PRJNA1193541	13342	247	0.885057	2.18609079	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	363	9.079999999999999e-96	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g13204	i0	93.469	428.643724696356	245	15	99	1	1	245	112808	112565	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	105875	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
2871421	2871421	PRJNA1193541_P_NODE_2143_length_526_cov_1.335541_g2006_i0	PRJNA1193541	2143	526	1.335541	7.02494566	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	885	0	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g2006	i0	96.987	458.283269961977	531	8	100	4	1	526	730458	730985	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	241057	885	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
4147523	4147523	PRJNA1193541_P_NODE_14904_length_242_cov_0.911243_g14766_i0	PRJNA1193541	14904	242	0.911243	2.20520806	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	363	8.869999999999999e-96	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g14766	i0	93.776	170.52479338843	241	15	99	0	1	241	2977661	2977901	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	41267	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
4147668	4147668	PRJNA1193541_P_NODE_8344_length_302_cov_1.344978_g8206_i0	PRJNA1193541	8344	302	1.344978	4.06183356	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	518	2.31e-142	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g8206	i0	97.69	346.675496688742	303	3	100	2	1	302	113664	113365	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	104696	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
10524450	10524450	PRJNA1193541_P_NODE_8709_length_294_cov_1.990950_g8571_i0	PRJNA1193541	8709	294	1.99095	5.853393	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	527	3.719999999999999e-145	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g8571	i0	98.98	281.608843537415	294	3	100	0	1	294	56418	56711	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	82793	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
11799145	11799145	PRJNA1193541_P_NODE_12990_length_248_cov_0.880000_g12852_i0	PRJNA1193541	12990	248	0.88	2.1824	Chryseobacterium indologenes	253	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1957908205\|gb\|CP067044.1\|	253	g12852	i0	100	98.7620967741936	245	0	99	0	4	248	3792873	3792629	Chryseobacterium indologenes strain 3125 chromosome, complete genome	blastn	24493	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
15623320	15623320	PRJNA1193541_P_NODE_10813_length_268_cov_1.897436_g10675_i0	PRJNA1193541	10813	268	1.897436	5.08512848	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	399	7.609999999999999e-107	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g10675	i0	93.657	479.742537313433	268	15	99	2	1	267	1235257	1234991	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	128571	399	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
17620170	17620170	PRJNA1193541_P_NODE_2194_length_521_cov_1.352679_g2057_i0	PRJNA1193541	2194	521	1.352679	7.04745759	Emticicia	312278	Bacteria	Bacteria	798	0	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g2057	i0	94.434	460.99424184261	521	26	100	3	1	521	23	540	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	240178	798	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
22719230	22719230	PRJNA1193541_P_NODE_13258_length_247_cov_0.885057_g13120_i0	PRJNA1193541	13258	247	0.885057	2.18609079	Bacteroides	816	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|2101501970\|gb\|CP083813.1\|	28116	g13120	i0	98.222	30.0607287449393	225	0	89	1	23	243	3591789	3592013	Bacteroides ovatus strain FDAARGOS_1516 chromosome	blastn	7425	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ovatus

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