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

8 rows where analysis = "blastn", bioproject = "PRJNA855894" 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
3392808	3392808	PRJNA855894_P_NODE_25043_length_288_cov_1.362791_g24921_i0	PRJNA855894	25043	288	1.362791	3.92483808	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	499	7.92e-137	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g24921	i0	97.917	7.29166666666667	288	6	100	0	1	288	3611567	3611854	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	2100	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
3393022	3393022	PRJNA855894_P_NODE_33363_length_243_cov_1.641176_g33241_i0	PRJNA855894	33363	243	1.641176	3.98805768	Cytophaga hutchinsonii	985	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|110279108\|gb\|CP000383.1\|	269798	g33241	i0	95.851	1.98353909465021	241	10	99	0	3	243	2299210	2299450	Cytophaga hutchinsonii ATCC 33406, complete genome	blastn	482	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
5062963	5062963	PRJNA855894_P_NODE_20424_length_331_cov_1.162791_g20302_i0	PRJNA855894	20424	331	1.162791	3.84883821	Chitinophagaceae	563835	Bacteria	Bacteria	553	7.009999999999998e-153	NTclustered	gi\|470489618\|ref\|NR_076941.1\|	354356	g20302	i0	96.96	180.993957703927	329	10	99	0	1	329	2064	2392	Niastella koreensis GR20-10 strain GR20-10 23S ribosomal RNA, complete sequence	blastn	59909	558	0.991039426523297	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella koreensis
5063098	5063098	PRJNA855894_P_NODE_34124_length_242_cov_0.911243_g34002_i0	PRJNA855894	34124	242	0.911243	2.20520806	Sphingobacterium	28453	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g34002	i0	99.174	9.88429752066116	242	2	100	0	1	242	3822955	3822714	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	2392	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
6338991	6338991	PRJNA855894_P_NODE_32045_length_246_cov_1.121387_g31923_i0	PRJNA855894	32045	246	1.121387	2.75861202	Weeksellaceae	2762318	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g31923	i0	100	478.016260162602	246	0	100	0	1	246	168053	168298	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	117592	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
7220146	7220146	PRJNA855894_P_NODE_19166_length_344_cov_1.398524_g19044_i0	PRJNA855894	19166	344	1.398524	4.81092256	Flavobacterium sp. 140616W15	2478552	Bacteria	Bacteria	625	1.5299999999999996e-174	NTclustered	gi\|1494316954\|gb\|CP033068.1\|	2478552	g19044	i0	99.707	552.563953488372	341	1	100	0	4	344	1306170	1305830	Flavobacterium sp. 140616W15 chromosome, complete genome	blastn	190082	625	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 140616W15
7613035	7613035	PRJNA855894_P_NODE_29646_length_251_cov_0.865169_g29524_i0	PRJNA855894	29646	251	0.865169	2.17157419	Flavobacterium	237	Bacteria	Bacteria	329	9.38e-86	NTclustered	gi\|2284918182\|gb\|CP100442.1\|	1114867	g29524	i0	90.438	2.86852589641434	251	22	99	2	2	251	5532765	5533014	Flavobacterium plurextorum strain RSG-18 chromosome, complete genome	blastn	720	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium plurextorum
13988828	13988828	PRJNA855894_P_NODE_28071_length_262_cov_1.529101_g27949_i0	PRJNA855894	28071	262	1.529101	4.00624462	Flavobacterium	237	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2223843353\|gb\|CP090145.1\|	2024526	g27949	i0	99.618	454.557251908397	262	1	100	0	1	262	701193	701454	Flavobacterium sediminilitoris strain YSM-43 chromosome, complete genome	blastn	119094	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminilitoris

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