metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA760976" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA760976" and tax_clade = "FCB group"

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
742458	742458	PRJNA760976_P_NODE_641_length_1464_cov_12.931704_g514_i0	PRJNA760976	641	1464	12.931704	189.32014656	Coprobacter fastidiosus	1099853	Bacteria	Bacteria	152	1.44e-31	NTclustered	gi\|2487365010\|dbj\|AP028032.1\|	1099853	g514	i0	83.529	21.4883879781421	170	21	11	7	786	951	1036626	1036792	Coprobacter fastidiosus JCM 33896 DNA, complete genome	blastn	31459	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Coprobacter	Coprobacter fastidiosus
1204895	1204895	PRJNA760976_P_NODE_20921_length_343_cov_3.540741_g20600_i0	PRJNA760976	20921	343	3.540741	12.14474163	Haliscomenobacter	2349	Bacteria	Bacteria	569	7.239999999999998e-158	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g20600	i0	97.313	380.084548104956	335	9	98	0	7	341	2665	2331	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	130369	569	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
2480442	2480442	PRJNA760976_P_NODE_102_length_3019_cov_32.894094_g77_i0	PRJNA760976	102	3019	32.894094	993.07269786	Bacteroidales	171549	Bacteria	Bacteria	130	1.41e-24	NTclustered	gi\|470487156\|ref\|NR_076804.1\|	185300	g77	i0	81.818	9.37263994700232	154	28	5	0	2344	2497	853	700	Paludibacter propionicigenes strain WB4 23S ribosomal RNA gene, complete sequence	blastn	28296	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
3756735	3756735	PRJNA760976_P_NODE_10343_length_443_cov_2.045946_g10024_i0	PRJNA760976	10343	443	2.045946	9.06354078	Haliscomenobacter	2349	Bacteria	Bacteria	329	1.77e-85	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g10024	i0	81.931	213.2460496614	404	59	90	13	47	443	1336	940	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	94468	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
5033283	5033283	PRJNA760976_P_NODE_144_length_2601_cov_21.631329_g109_i0	PRJNA760976	144	2601	21.631329	562.63086729	Candidatus Cardinium	273135	Bacteria	Bacteria	63.9	1.25e-4	NTclustered	gi\|1393535634\|gb\|CP029619.1\|	247481	g109	i0	83.099	0.163783160322953	71	10	3	2	1627	1696	685277	685208	Candidatus Cardinium hertigii strain cHgTN10 chromosome, complete genome	blastn	426	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Amoebophilaceae	Candidatus Cardinium	Candidatus Cardinium hertigii
5845938	5845938	PRJNA760976_P_NODE_37365_length_279_cov_1.121359_g37044_i0	PRJNA760976	37365	279	1.121359	3.12859161	Flavobacterium faecale	1355330	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1384922047\|gb\|CP020918.1\|	1355330	g37044	i0	100	0.103942652329749	29	0	10	0	2	30	2665497	2665525	Flavobacterium faecale strain WV33 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium faecale
7121071	7121071	PRJNA760976_P_NODE_19246_length_353_cov_2.075000_g18925_i0	PRJNA760976	19246	353	2.075	7.32475	Flavobacterium sp. N2270	2986831	Bacteria	Bacteria	564	3.47e-156	NTclustered	gi\|2324023718\|gb\|CP110005.1\|	2986831	g18925	i0	96.264	536.912181303116	348	5	97	5	1	344	292069	291726	Flavobacterium sp. N2270 chromosome, complete genome	blastn	189530	564	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2270
7121147	7121147	PRJNA760976_P_NODE_46646_length_254_cov_1.381215_g46325_i0	PRJNA760976	46646	254	1.381215	3.5082861	Flavobacterium channae	2897181	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g46325	i0	100	480.751968503937	254	0	100	0	1	254	486934	487187	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	122111	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
9670786	9670786	PRJNA760976_P_NODE_30928_length_299_cov_1.327434_g30607_i0	PRJNA760976	30928	299	1.327434	3.96902766	Chryseobacterium indologenes	253	Bacteria	Bacteria	531	2.9299999999999992e-146	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g30607	i0	98.662	482	299	4	100	0	1	299	3063642	3063940	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	144118	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
12221959	12221959	PRJNA760976_P_NODE_17650_length_364_cov_1.398625_g17329_i0	PRJNA760976	17650	364	1.398625	5.090995	Tenuifilaceae bacterium CYCD	3026384	Bacteria	Bacteria	228	5.3499999999999984e-55	NTclustered	gi\|2599609338\|dbj\|AP027304.1\|	3026384	g17329	i0	81.625	187.741758241758	283	45	77	7	65	343	715300	715021	Tenuifilaceae bacterium CYCD DNA, complete genome	blastn	68338	228	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tenuifilaceae		Tenuifilaceae bacterium CYCD
12222037	12222037	PRJNA760976_P_NODE_43710_length_261_cov_2.393617_g43389_i0	PRJNA760976	43710	261	2.393617	6.24734037	Bacteroidales bacterium	2030927	Bacteria	Bacteria	110	1.39e-19	NTclustered	gi\|2621700911\|emb\|OY759745.1\|	2030927	g43389	i0	74.905	59.2183908045977	263	54	99	10	2	260	637278	637532	MAG: Bacteroidales bacterium isolate 6557e7a1-78fa-4815-bf71-3c9d2683966d genome assembly, chromosome: 1	blastn	15456	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
15233518	15233518	PRJNA760976_P_NODE_20232_length_347_cov_2.448905_g19911_i0	PRJNA760976	20232	347	2.448905	8.49770035	Emticicia	312278	Bacteria	Bacteria	520	7.4899999999999985e-143	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g19911	i0	93.66	237.763688760807	347	22	100	0	1	347	364	18	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	82504	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
17320634	17320634	PRJNA760976_P_NODE_16214_length_375_cov_3.228477_g15893_i0	PRJNA760976	16214	375	3.228477	12.10678875	Spirosoma rhododendri	2728024	Bacteria	Bacteria	250	1.18e-61	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g15893	i0	92.09	165.416	177	14	48	0	196	372	1502120	1502296	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	62031	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
17320716	17320716	PRJNA760976_P_NODE_41054_length_268_cov_2.851282_g40733_i0	PRJNA760976	41054	268	2.851282	7.64143576	Bacteroidales bacterium	2030927	Bacteria	Bacteria	333	7.82e-87	NTclustered	gi\|2621784978\|emb\|OY781436.1\|	2030927	g40733	i0	89.655	268.690298507463	261	27	97	0	5	265	884061	884321	MAG: Bacteroidales bacterium isolate 341beb75-fe78-4792-8f66-49c0517f62f9 genome assembly, chromosome: 1	blastn	72009	333	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
19056784	19056784	PRJNA760976_P_NODE_44075_length_260_cov_2.994652_g43754_i0	PRJNA760976	44075	260	2.994652	7.7860952	Pedobacter	84567	Bacteria	Bacteria	375	1.2399999999999995e-99	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g43754	i0	95.359	274.088461538462	237	9	100	2	25	260	1870501	1870736	Pedobacter sp. HDW13 chromosome, complete genome	blastn	71263	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
19869192	19869192	PRJNA760976_P_NODE_11076_length_432_cov_2.445682_g10756_i0	PRJNA760976	11076	432	2.445682	10.56534624	Chryseobacterium indologenes	253	Bacteria	Bacteria	741	0	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g10756	i0	98.118	520.782407407407	425	8	98	0	1	425	3062374	3062798	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	224978	741	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
21144969	21144969	PRJNA760976_P_NODE_48597_length_250_cov_0.870056_g48276_i0	PRJNA760976	48597	250	0.870056	2.17514	Runella sp. SP2	2268026	Bacteria	Bacteria	449	6.87e-122	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g48276	i0	99.197	306.628	249	2	99	0	2	250	7121885	7121637	Runella sp. SP2 chromosome, complete genome	blastn	76657	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
22882743	22882743	PRJNA760976_P_NODE_898_length_1287_cov_2.655684_g736_i0	PRJNA760976	898	1287	2.655684	34.17865308	Emticicia	312278	Bacteria	Bacteria	2076	0	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g736	i0	95.807	315.214452214452	1288	51	100	3	1	1287	1660	375	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	405681	2076	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
23695386	23695386	PRJNA760976_P_NODE_6419_length_534_cov_1.236443_g6102_i0	PRJNA760976	6419	534	1.236443	6.60260562	Candidatus Shikimatogenerans sp. Tduv	3158567	Bacteria	Bacteria	80.5	2.41e-10	NTclustered	gi\|2859865482\|gb\|CP157894.2\|	3158567	g6102	i0	86.667	15.4906367041199	75	7	14	2	229	303	8241	8312	MAG: Candidatus Shikimatogenerans sp. Tduv chromosome	blastn	8272	80.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Shikimatogenerans	Candidatus Shikimatogenerans sp. Tduv

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