metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1214993" 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
330311	330311	PRJNA1214993_P_NODE_24221_length_245_cov_0.906977_g24035_i0	PRJNA1214993	24221	245	0.906977	2.22209365	Porphyromonadaceae bacterium	2049046	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|2189488613\|gb\|CP091732.1\|	2049046	g24035	i0	99.59	0.995918367346939	244	1	99	0	2	245	1900831	1901074	MAG: Porphyromonadaceae bacterium isolate nC29_bin.32.fa chromosome	blastn	244	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium
2881190	2881190	PRJNA1214993_P_NODE_15163_length_285_cov_1.509434_g14977_i0	PRJNA1214993	15163	285	1.509434	4.3018869	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	460	3.69e-125	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g14977	i0	95.804	405.568421052632	286	10	100	2	1	285	4030684	4030968	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	115587	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
4157312	4157312	PRJNA1214993_P_NODE_21124_length_250_cov_0.881356_g20938_i0	PRJNA1214993	21124	250	0.881356	2.20339	Segatella copri	165179	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2726125546\|gb\|CP152484.1\|	165179	g20938	i0	88.412	21.032	233	27	93	0	2	234	512023	512255	Segatella copri strain HDD04 chromosome, complete genome	blastn	5258	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
4873553	4873553	PRJNA1214993_P_NODE_9144_length_361_cov_1.354167_g8958_i0	PRJNA1214993	9144	361	1.354167	4.88854287	Segatella	2974251	Bacteria	Bacteria	667	0	NTclustered	gi\|2733784973\|gb\|CP152348.1\|	165179	g8958	i0	100	272.598337950139	361	0	100	0	1	361	1481291	1481651	Segatella copri strain HDB01 chromosome, complete genome	blastn	98408	667	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
6148210	6148210	PRJNA1214993_P_NODE_14025_length_295_cov_0.828829_g13839_i0	PRJNA1214993	14025	295	0.828829	2.44504555	Ignavibacteriales	795748	Bacteria	Bacteria	305	1.9e-78	NTclustered	gi\|470490116\|ref\|NR_076968.1\|	591197	g13839	i0	93.269	277.4	208	13	70	1	86	292	1252	1045	Ignavibacterium album strain Mat9-16 23S ribosomal RNA gene, complete sequence	blastn	81833	305	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
6148217	6148217	PRJNA1214993_P_NODE_21565_length_249_cov_1.607955_g21379_i0	PRJNA1214993	21565	249	1.607955	4.00380795	Leadbetterella	319458	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|470487076\|ref\|NR_076799.1\|	316068	g21379	i0	95.238	36.3012048192771	231	11	93	0	10	240	1443	1213	Leadbetterella byssophila strain 4M15 23S ribosomal RNA gene, complete sequence	blastn	9039	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella byssophila
6708218	6708218	PRJNA1214993_P_NODE_8266_length_377_cov_2.052632_g8080_i0	PRJNA1214993	8266	377	2.052632	7.73842264	Flavobacterium arcticum	1784713	Bacteria	Bacteria	647	0	NTclustered	gi\|1435276337\|gb\|CP031188.1\|	1784713	g8080	i0	97.613	486.936339522546	377	9	100	0	1	377	432303	432679	Flavobacterium arcticum strain SM1502 chromosome, complete genome	blastn	183575	647	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium arcticum
9258314	9258314	PRJNA1214993_P_NODE_3068_length_603_cov_1.926415_g2889_i0	PRJNA1214993	3068	603	1.926415	11.61628245	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2556925782\|gb\|CP129489.1\|	2021391	g2889	i0	94.444	0.0597014925373134	36	0	6	1	522	555	429724	429689	MAG: Flavobacteriales bacterium isolate cMAG.7 chromosome, complete genome	blastn	36	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
11248684	11248684	PRJNA1214993_P_NODE_14149_length_293_cov_1.972727_g13963_i0	PRJNA1214993	14149	293	1.972727	5.78009011	Cloacibacterium	501783	Bacteria	Bacteria	536	6.149999999999998e-148	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g13963	i0	99.659	498.839590443686	293	1	100	0	1	293	130211	130503	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	146160	536	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
13084014	13084014	PRJNA1214993_P_NODE_21731_length_249_cov_0.886364_g21545_i0	PRJNA1214993	21731	249	0.886364	2.20704636	Cloacibacterium normanense	237258	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g21545	i0	95.299	3.16064257028112	234	11	94	0	1	234	169645	169878	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	787	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
15073048	15073048	PRJNA1214993_P_NODE_24552_length_244_cov_1.824561_g24366_i0	PRJNA1214993	24552	244	1.824561	4.45192884	Cloacibacterium	501783	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g24366	i0	100	466.987704918033	244	0	100	0	1	244	1872625	1872382	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	113945	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
15073055	15073055	PRJNA1214993_P_NODE_4772_length_488_cov_2.462651_g4587_i0	PRJNA1214993	4772	488	2.462651	12.01773688	Weeksellaceae	2762318	Bacteria	Bacteria	857	0	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g4587	i0	98.361	476.012295081967	488	8	100	0	1	488	168053	168540	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	232294	863	0.993047508690614	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
15633144	15633144	PRJNA1214993_P_NODE_13853_length_296_cov_2.825112_g13667_i0	PRJNA1214993	13853	296	2.825112	8.36233152	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g13667	i0	100	409.287162162162	296	0	100	0	1	296	2968958	2968663	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	121149	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
16907426	16907426	PRJNA1214993_P_NODE_15354_length_284_cov_1.109005_g15168_i0	PRJNA1214993	15354	284	1.109005	3.1495742	Bacteroides graminisolvens	477666	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|2621703509\|emb\|OY762556.1\|	477666	g15168	i0	99.648	490.806338028169	284	1	100	0	1	284	1378425	1378708	MAG: Bacteroides graminisolvens isolate c2c85108-0b76-4fb4-8ed9-98fc9390ecb6 genome assembly, chromosome: 1	blastn	139389	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides graminisolvens
16907490	16907490	PRJNA1214993_P_NODE_23334_length_246_cov_1.803468_g23148_i0	PRJNA1214993	23334	246	1.803468	4.43653128	Segatella copri	165179	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2726121972\|gb\|CP152346.1\|	165179	g23148	i0	97.561	1	246	6	100	0	1	246	1779147	1778902	Segatella copri strain HDE04 chromosome, complete genome	blastn	246	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
20171680	20171680	PRJNA1214993_P_NODE_24696_length_244_cov_0.912281_g24510_i0	PRJNA1214993	24696	244	0.912281	2.22596564	Pseudomonadati	3379134	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|2874254046\|emb\|OY970370.1\|	2044591	g24510	i0	83.186	94.1434426229508	226	36	92	2	1	225	1320779	1320555	MAG: Candidatus Fermentibacteria bacterium isolate MFD00905.bin.1.36 genome assembly, chromosome: 1	blastn	22971	207	0.995169082125604	Bacteria	FCB group	Pseudomonadati	Candidatus Fermentibacterota					Candidatus Fermentibacterota bacterium
20731717	20731717	PRJNA1214993_P_NODE_14057_length_294_cov_1.963801_g13871_i0	PRJNA1214993	14057	294	1.963801	5.77357494	Adhaeribacter swui	2086471	Bacteria	Bacteria	460	3.82e-125	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g13871	i0	94.932	261.996598639456	296	11	100	4	1	294	95235	95528	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	77027	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
22007032	22007032	PRJNA1214993_P_NODE_12478_length_312_cov_1.953975_g12292_i0	PRJNA1214993	12478	312	1.953975	6.096402	Segatella copri	165179	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|2589387312\|gb\|CP134816.1\|	165179	g12292	i0	100	385.086538461538	312	0	100	0	1	312	851478	851789	Segatella copri strain H-2383 chromosome	blastn	120147	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
22722297	22722297	PRJNA1214993_P_NODE_11998_length_318_cov_1.591837_g11812_i0	PRJNA1214993	11998	318	1.591837	5.06204166	Paludibacter	346096	Bacteria	Bacteria	483	8.919999999999998e-132	NTclustered	gi\|470487156\|ref\|NR_076804.1\|	185300	g11812	i0	94.025	382.194968553459	318	19	100	0	1	318	810	1127	Paludibacter propionicigenes strain WB4 23S ribosomal RNA gene, complete sequence	blastn	121538	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter propionicigenes
23282473	23282473	PRJNA1214993_P_NODE_20219_length_252_cov_0.871508_g20033_i0	PRJNA1214993	20219	252	0.871508	2.19620016	Flavobacterium sp. RS13.1	3400345	Bacteria	Bacteria	243	1.2600000000000001e-59	NTclustered	gi\|2919780193\|gb\|CP182487.1\|	3400345	g20033	i0	85.47	0.928571428571429	234	32	92	2	1	233	1735220	1735452	Flavobacterium sp. RS13.1 chromosome, complete genome	blastn	234	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. RS13.1

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