metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA474911" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA474911" 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
1097081	1097081	PRJNA474911_P_NODE_6081_length_227_cov_2.102410_g5954_i0	PRJNA474911	6081	227	2.10241	4.7724707	Weeksellaceae	2762318	Bacteria	Bacteria	407	3.7499999999999994e-109	NTclustered	gi\|1264300638\|gb\|CP023049.2\|	558152	g5954	i0	99.115	461.854625550661	226	2	99	0	1	226	2120155	2119930	Chryseobacterium piperi strain ATCC BAA-1782 chromosome, complete genome	blastn	104841	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium piperi
7475061	7475061	PRJNA474911_P_NODE_1306_length_556_cov_2.806061_g1184_i0	PRJNA474911	1306	556	2.806061	15.60169916	Cloacibacterium	501783	Bacteria	Bacteria	955	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1184	i0	97.666	497.564748201439	557	11	100	2	1	556	2158017	2158572	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	276646	955	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8750011	8750011	PRJNA474911_P_NODE_1167_length_594_cov_3.371482_g1046_i0	PRJNA474911	1167	594	3.371482	20.02660308	Candidatus Parvibacillus	2981995	Bacteria	Bacteria	479	2.2699999999999992e-130	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g1046	i0	81.653	167.053872053872	605	86	99	25	1	592	3059854	3060446	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	99230	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
8750014	8750014	PRJNA474911_P_NODE_1727_length_482_cov_2.429929_g1603_i0	PRJNA474911	1727	482	2.429929	11.71225778	Haliscomenobacter	2349	Bacteria	Bacteria	545	1.77e-150	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g1603	i0	87.216	373.46265560166	485	55	100	6	1	482	999	519	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	180009	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
8750016	8750016	PRJNA474911_P_NODE_2527_length_389_cov_2.646341_g2401_i0	PRJNA474911	2527	389	2.646341	10.29426649	Flavobacteriaceae	49546	Bacteria	Bacteria	318	3.32e-82	NTclustered	gi\|2752113481\|gb\|CP158972.1\|	393006	g2401	i0	86.986	128.92030848329	292	27	74	11	104	389	3109229	3108943	Tamlana crocina strain HT-18 chromosome, complete genome	blastn	50150	320	0.99375	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tamlana	Tamlana crocina
10025379	10025379	PRJNA474911_P_NODE_4568_length_271_cov_1.219048_g4441_i0	PRJNA474911	4568	271	1.219048	3.30362008	Candidatus Parvibacillus	2981995	Bacteria	Bacteria	302	2.24e-77	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g4441	i0	87.547	229.143911439114	265	28	96	2	1	260	3061063	3060799	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	62098	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
11926287	11926287	PRJNA474911_P_NODE_4730_length_264_cov_2.118227_g4603_i0	PRJNA474911	4730	264	2.118227	5.59211928	Flavobacterium oreochromis	2906078	Bacteria	Bacteria	442	1.2199999999999994e-119	NTclustered	gi\|2079163087\|gb\|CP067377.1\|	2906078	g4603	i0	96.958	678.325757575758	263	8	99	0	1	263	4854	4592	Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome	blastn	179078	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium oreochromis
14476191	14476191	PRJNA474911_P_NODE_512_length_902_cov_2.718193_g420_i0	PRJNA474911	512	902	2.718193	24.51810086	Prevotella sp.	59823	Bacteria	Bacteria	1042	0	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g420	i0	87.946	540.920177383592	896	93	99	11	1	894	2265	3147	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	487910	1042	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
15125011	15125011	PRJNA474911_P_NODE_3112_length_342_cov_2.519573_g2986_i0	PRJNA474911	3112	342	2.519573	8.61693966	Cloacibacterium	501783	Bacteria	Bacteria	601	2.5599999999999993e-167	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g2986	i0	98.256	421.739766081871	344	4	100	2	1	342	130475	130132	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	144235	601	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15750281	15750281	PRJNA474911_P_NODE_7233_length_208_cov_0.870748_g7106_i0	PRJNA474911	7233	208	0.870748	1.81115584	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	337	4.49e-88	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g7106	i0	95.714	150.283653846154	210	7	100	2	1	208	787665	787456	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	31259	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
18299194	18299194	PRJNA474911_P_NODE_6395_length_220_cov_1.610063_g6268_i0	PRJNA474911	6395	220	1.610063	3.5421386	Chryseobacterium sp. KACC 21268	3025664	Bacteria	Bacteria	318	1.7399999999999995e-82	NTclustered	gi\|2446111318\|gb\|CP117875.1\|	3025664	g6268	i0	92.727	6.36818181818182	220	16	100	0	1	220	886589	886808	Chryseobacterium sp. KACC 21268 chromosome, complete genome	blastn	1401	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. KACC 21268
19573413	19573413	PRJNA474911_P_NODE_6256_length_223_cov_3.191358_g6129_i0	PRJNA474911	6256	223	3.191358	7.11672834	Epilithonimonas zeae	1416779	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g6129	i0	100	305.04932735426	223	0	100	0	1	223	2242391	2242613	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	68026	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
22124085	22124085	PRJNA474911_P_NODE_3698_length_309_cov_0.895161_g3571_i0	PRJNA474911	3698	309	0.895161	2.76604749	Pontibacter pudoricolor	2694930	Bacteria	Bacteria	521	1.8299999999999998e-143	NTclustered	gi\|1804497162\|gb\|CP048106.1\|	2694930	g3571	i0	97.087	280.702265372168	309	9	100	0	1	309	3635252	3635560	Pontibacter pudoricolor strain BT214 chromosome, complete genome	blastn	86737	521	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter pudoricolor
22124098	22124098	PRJNA474911_P_NODE_7758_length_204_cov_0.916084_g7631_i0	PRJNA474911	7758	204	0.916084	1.86881136	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	300	5.76e-77	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g7631	i0	93.137	296.401960784314	204	14	100	0	1	204	444067	443864	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	60466	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
24673735	24673735	PRJNA474911_P_NODE_2120_length_428_cov_2.607629_g1995_i0	PRJNA474911	2120	428	2.607629	11.16065212	Cloacibacterium caeni	2004710	Bacteria	Bacteria	732	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g1995	i0	97.448	311.107476635514	431	7	100	4	1	428	1872535	1872106	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	133154	732	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
25323310	25323310	PRJNA474911_P_NODE_6820_length_211_cov_2.066667_g6693_i0	PRJNA474911	6820	211	2.066667	4.36066737	Bacteroidota	976	Bacteria	Bacteria	248	2.2e-61	NTclustered	gi\|2634447873\|gb\|CP139724.1\|	333140	g6693	i0	88.152	284.132701421801	211	22	100	2	1	211	2503120	2502913	Roseivirga spongicola strain OXR-11 chromosome, complete genome	blastn	59952	250	0.992	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Roseivirgaceae	Roseivirga	Roseivirga spongicola

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