metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA638138" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA638138" 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
609548	609548	PRJNA638138_P_NODE_9381_length_339_cov_1.157895_g9166_i0	PRJNA638138	9381	339	1.157895	3.92526405	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	438	2.1e-118	NTclustered	gi\|2874253829\|emb\|OY969813.1\|	152509	g9166	i0	89.884	132.849557522124	346	27	100	5	1	339	3891784	3891440	MAG: uncultured Bacteroidetes bacterium isolate MFD09671.bin.1.97 genome assembly, chromosome: 1	blastn	45036	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
3706938	3706938	PRJNA638138_P_NODE_33183_length_242_cov_0.911243_g32968_i0	PRJNA638138	33183	242	0.911243	2.20520806	Hymenobacter	89966	Bacteria	Bacteria	276	1.19e-69	NTclustered	gi\|1682022672\|gb\|CP040896.1\|	2502781	g32968	i0	87.19	9.94628099173554	242	31	100	0	1	242	3127936	3128177	Hymenobacter jejuensis strain 17J68-5 chromosome, complete genome	blastn	2407	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter jejuensis
6987883	6987883	PRJNA638138_P_NODE_23426_length_249_cov_0.875000_g23211_i0	PRJNA638138	23426	249	0.875	2.17875	Hymenobacter sp. 5317J-9	2932250	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|2221939013\|gb\|CP095050.1\|	2932250	g23211	i0	84.091	0.883534136546185	220	31	88	4	32	249	4102066	4101849	Hymenobacter sp. 5317J-9 chromosome, complete genome	blastn	220	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5317J-9
14638199	14638199	PRJNA638138_P_NODE_1572_length_741_cov_1.961078_g1370_i0	PRJNA638138	1572	741	1.961078	14.53158798	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	1308	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g1370	i0	98.516	270.572199730094	741	11	100	0	1	741	2979633	2980373	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	200494	1308	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
14638270	14638270	PRJNA638138_P_NODE_22512_length_249_cov_0.875000_g22297_i0	PRJNA638138	22512	249	0.875	2.17875	Chryseobacterium indologenes	253	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g22297	i0	100	0.116465863453815	29	0	12	0	140	168	4302987	4303015	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
19736158	19736158	PRJNA638138_P_NODE_27436_length_246_cov_0.890173_g27221_i0	PRJNA638138	27436	246	0.890173	2.18982558	Pontibacter russatus	2694929	Bacteria	Bacteria	298	2.5799999999999998e-76	NTclustered	gi\|1802158094\|gb\|CP047984.1\|	2694929	g27221	i0	88.664	1.00406504065041	247	25	100	3	1	246	2148354	2148598	Pontibacter russatus strain BT326 chromosome, complete genome	blastn	247	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter russatus
19736271	19736271	PRJNA638138_P_NODE_456_length_1274_cov_2.457119_g348_i0	PRJNA638138	456	1274	2.457119	31.30369606	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	2058	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g348	i0	95.859	273.324960753532	1280	39	100	14	1	1274	2977652	2978923	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	348216	2058	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
22832680	22832680	PRJNA638138_P_NODE_29138_length_245_cov_0.895349_g28923_i0	PRJNA638138	29138	245	0.895349	2.19360505	Prevotella	838	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1276663706\|gb\|CP024723.1\|	28131	g28923	i0	98.776	19	245	3	100	0	1	245	1621791	1622035	Prevotella intermedia strain KCOM 2837 chromosome 1, complete sequence	blastn	4655	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
24835711	24835711	PRJNA638138_P_NODE_26900_length_246_cov_0.890173_g26685_i0	PRJNA638138	26900	246	0.890173	2.18982558	Prevotella intermedia	28131	Bacteria	Bacteria	411	3.1799999999999995e-110	NTclustered	gi\|1276666115\|gb\|CP024725.1\|	28131	g26685	i0	96.748	212.955284552846	246	8	100	0	1	246	113135	113380	Prevotella intermedia strain KCOM 2838 chromosome 1, complete sequence	blastn	52387	411	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
24835868	24835868	PRJNA638138_P_NODE_7600_length_367_cov_1.309524_g7385_i0	PRJNA638138	7600	367	1.309524	4.80595308	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	503	8.009999999999998e-138	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g7385	i0	91.553	121.212534059945	367	27	100	3	1	367	1672271	1672633	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	44485	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans

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