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

13 rows where analysis = "blastn", bioproject = "PRJNA512103" 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
1760770	1760770	PRJNA512103_P_NODE_13642_length_288_cov_7.058577_g13230_i0	PRJNA512103	13642	288	7.058577	20.32870176	Euzebyella marina	1761453	Bacteria	Bacteria	444	3.76e-120	NTclustered	gi\|1495890593\|gb\|CP032050.1\|	1761453	g13230	i0	96.296	264.055555555556	270	10	94	0	10	279	1227476	1227207	Euzebyella marina strain RN62 chromosome, complete genome	blastn	76048	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Euzebyella	Euzebyella marina
4313260	4313260	PRJNA512103_P_NODE_35004_length_153_cov_3.307692_g34592_i0	PRJNA512103	35004	153	3.307692	5.06076876	Euzebyella marina	1761453	Bacteria	Bacteria	279	5.28e-71	NTclustered	gi\|1495890593\|gb\|CP032050.1\|	1761453	g34592	i0	100	381.392156862745	151	0	99	0	1	151	1227911	1227761	Euzebyella marina strain RN62 chromosome, complete genome	blastn	58353	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Euzebyella	Euzebyella marina
5589473	5589473	PRJNA512103_P_NODE_17045_length_240_cov_1.031414_g16633_i0	PRJNA512103	17045	240	1.031414	2.4753936	Salinivirga cyanobacteriivorans	1307839	Bacteria	Bacteria	132	2.7e-26	NTclustered	gi\|952475893\|gb\|CP013118.1\|	1307839	g16633	i0	81.595	24.5375	163	26	67	4	20	180	1435296	1435456	Salinivirga cyanobacteriivorans strain L21-Spi-D4, complete genome.	blastn	5889	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae	Salinivirga	Salinivirga cyanobacteriivorans
6214335	6214335	PRJNA512103_P_NODE_11165_length_342_cov_2.406143_g10753_i0	PRJNA512103	11165	342	2.406143	8.22900906	Bacteroidota	976	Bacteria	Bacteria	603	7.119999999999999e-168	NTclustered	gi\|1198339295\|gb\|KY770081.1\|	29535	g10753	i0	99.696	101.093567251462	329	1	96	0	2	330	341	13	Cytophaga sp. strain 1334-056 16S ribosomal RNA gene, partial sequence	blastn	34574	606	0.995049504950495	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga sp.
10690295	10690295	PRJNA512103_P_NODE_7789_length_463_cov_1.958937_g7380_i0	PRJNA512103	7789	463	1.958937	9.06987831	Zobellia alginiliquefaciens	3032586	Bacteria	Bacteria	719	0	NTclustered	gi\|2463200998\|gb\|CP119758.1\|	3032586	g7380	i0	95.74	243.183585313175	446	19	96	0	10	455	466551	466106	Zobellia alginiliquefaciens strain LLG6346-3.1 chromosome, complete genome	blastn	112594	719	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Zobellia	Zobellia alginiliquefaciens
11965099	11965099	PRJNA512103_P_NODE_410_length_2667_cov_24.004202_g339_i0	PRJNA512103	410	2667	24.004202	640.19206734	Coprobacter fastidiosus	1099853	Bacteria	Bacteria	152	2.6499999999999996e-31	NTclustered	gi\|2487365010\|dbj\|AP028032.1\|	1099853	g339	i0	83.529	11.8076490438695	170	21	6	7	1992	2157	1036626	1036792	Coprobacter fastidiosus JCM 33896 DNA, complete genome	blastn	31491	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Coprobacter	Coprobacter fastidiosus
17063555	17063555	PRJNA512103_P_NODE_34094_length_163_cov_0.833333_g33682_i0	PRJNA512103	34094	163	0.833333	1.35833279	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	228	2.0999999999999998e-55	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g33682	i0	93.038	428.883435582822	158	8	96	2	8	162	1697729	1697886	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	69908	228	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
18962479	18962479	PRJNA512103_P_NODE_17355_length_236_cov_2.294118_g16943_i0	PRJNA512103	17355	236	2.294118	5.41411848	Flavobacterium	237	Bacteria	Bacteria	183	7.19e-42	NTclustered	gi\|1078660911\|gb\|CP017479.1\|	1492737	g16943	i0	81.938	557.953389830509	227	31	93	9	9	227	73423	73199	Flavobacterium gilvum strain EM1308 chromosome, complete genome	blastn	131677	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium gilvum
18962481	18962481	PRJNA512103_P_NODE_22075_length_202_cov_1.065359_g21663_i0	PRJNA512103	22075	202	1.065359	2.15202518	Tenacibaculum	104267	Bacteria	Bacteria	191	3.57e-44	NTclustered	gi\|2733075504\|emb\|OZ038524.1\|	669041	g21663	i0	85.106	3.63366336633663	188	27	93	1	7	193	2356430	2356243	Tenacibaculum dicentrarchi isolate ena-SAMPLE-TAB-13-05-2024-13:56:06:370-140309 genome assembly, chromosome: TD3509T	blastn	734	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum dicentrarchi
19611801	19611801	PRJNA512103_P_NODE_19196_length_221_cov_1.122093_g18784_i0	PRJNA512103	19196	221	1.122093	2.47982553	Aureispira anguillae	2864201	Bacteria	Bacteria	267	6.43e-67	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g18784	i0	89.524	514.968325791855	210	22	96	0	1	210	218989	219198	Aureispira anguillae EL160426 DNA, complete genome	blastn	113808	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
20888090	20888090	PRJNA512103_P_NODE_25617_length_186_cov_1.138686_g25205_i0	PRJNA512103	25617	186	1.138686	2.11795596	Chitinophaga niabensis	536979	Bacteria	Bacteria	235	1.4699999999999997e-57	NTclustered	gi\|2727467759\|gb\|CP154260.1\|	536979	g25205	i0	92.638	231.596774193548	163	12	88	0	24	186	3433	3271	Chitinophaga niabensis strain CN7 chromosome, complete genome	blastn	43077	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga niabensis
21512812	21512812	PRJNA512103_P_NODE_21617_length_204_cov_2.277419_g21205_i0	PRJNA512103	21617	204	2.277419	4.64593476	FCB group	1783270	Bacteria	Bacteria	342	9.429999999999999e-90	NTclustered	gi\|2554608523\|gb\|CP130738.1\|	248906	g21205	i0	100	213.995098039216	185	0	91	0	10	194	933738	933554	Zobellia laminariae strain AS94 chromosome, complete genome	blastn	43655	342	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Zobellia	Zobellia laminariae
25337263	25337263	PRJNA512103_P_NODE_17460_length_235_cov_2.704301_g17048_i0	PRJNA512103	17460	235	2.704301	6.35510735	Flavobacteriales	200644	Bacteria	Bacteria	167	7.21e-37	NTclustered	gi\|79083435\|gb\|DQ241813.1\|	354471	g17048	i0	81.517	430.03829787234	211	32	89	7	19	226	2009	2215	Bergeyella sp. AF14 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	101059	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella sp. AF14

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