metadata: contig_metadata: 22 rows where bioproject = "PRJNA512103" and tax

22 rows where 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
26918991	26918991	PRJNA512103_P_NODE_22202_length_201_cov_1.335526_g21790_i0	PRJNA512103	22202	201	1.335526	2.68440726	Bacteroidales bacterium	2030927	Bacteria	Bacteria	67	6.09e-11	NR	MFO7827122.1	2030927	g21790	i0	51.6	0.955223880597015	64	31	95.5	0	1	192	577	640	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	192	67	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27140002	27140002	PRJNA512103_P_NODE_20102_length_214_cov_0.963636_g19690_i0	PRJNA512103	20102	214	0.963636	2.06218104	Psychroflexus sp.	1921580	Bacteria	Bacteria	59.3	3.57e-8	NR	MFO7744505.1	1921580	g19690	i0	41.3	0.883177570093458	63	36	86.9	1	9	194	671	733	MFO7744505.1 reverse transcriptase family protein [Psychroflexus sp.]	diamond	189	59.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroflexus	Psychroflexus sp.
28277152	28277152	PRJNA512103_P_NODE_23486_length_195_cov_1.150685_g23074_i0	PRJNA512103	23486	195	1.150685	2.24383575	Bacteroidales bacterium	2030927	Bacteria	Bacteria	70.9	2.47e-12	NR	MFO7827238.1	2030927	g23074	i0	54.2	0.907692307692308	59	27	90.8	0	186	10	839	897	MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium]	diamond	177	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28340435	28340435	PRJNA512103_P_NODE_13626_length_289_cov_1.225000_g13214_i0	PRJNA512103	13626	289	1.225	3.54025	Bacteroidales bacterium	2030927	Bacteria	Bacteria	119	1.07e-28	NR	MFO7827122.1	2030927	g13214	i0	59.1	0.913494809688581	88	36	91.3	0	12	275	511	598	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	264	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30456673	30456673	PRJNA512103_P_NODE_33433_length_164_cov_0.904348_g33021_i0	PRJNA512103	33433	164	0.904348	1.48313072	Bacteroidales bacterium	2030927	Bacteria	Bacteria	83.2	2.24e-17	NR	MFO7844438.1	2030927	g33021	i0	77.1	0.878048780487805	48	11	87.8	0	154	11	103	150	MFO7844438.1 endonuclease/exonuclease/phosphatase family protein [Bacteroidales bacterium]	diamond	144	83.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31150980	31150980	PRJNA512103_P_NODE_34555_length_162_cov_0.920354_g34143_i0	PRJNA512103	34555	162	0.920354	1.49097348	Bacteroidales bacterium	2030927	Bacteria	Bacteria	62	1.94e-9	NR	MFO7827238.1	2030927	g34143	i0	69.4	0.666666666666667	36	11	66.7	0	154	47	872	907	MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium]	diamond	108	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31372938	31372938	PRJNA512103_P_NODE_22796_length_198_cov_1.221477_g22384_i0	PRJNA512103	22796	198	1.221477	2.41852446	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42	0.0379	NR	HOY31904.1	2030927	g22384	i0	40	0.757575757575758	50	27	75.8	1	38	187	200	246	HOY31904.1 radical SAM protein [Bacteroidales bacterium]	diamond	150	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31546477	31546477	PRJNA512103_P_NODE_32216_length_166_cov_0.888889_g31804_i0	PRJNA512103	32216	166	0.888889	1.47555574	FCB group	1783270	Bacteria	Bacteria	43.1	0.00997	NR	MEI6821811.1	1898104	g31804	i0	63	3.74096385542169	27	10	48.8	0	156	76	760	786	MEI6821811.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium]	diamond	621	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31847093	31847093	PRJNA512103_P_NODE_30117_length_170_cov_1.214876_g29705_i0	PRJNA512103	30117	170	1.214876	2.0652892	Bacteroidales bacterium	2030927	Bacteria	Bacteria	45.4	0.00157	NR	MFO7827122.1	2030927	g29705	i0	41.7	0.847058823529412	48	28	84.7	0	160	17	740	787	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	144	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium

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