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

10 rows where analysis = "blastn", bioproject = "PRJNA733995" 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
716599	716599	PRJNA733995_P_NODE_10481_length_268_cov_1.230769_g10434_i0	PRJNA733995	10481	268	1.230769	3.29846092	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g10434	i0	100	87.3619402985075	268	0	100	0	1	268	3078773	3078506	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	23413	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
716665	716665	PRJNA733995_P_NODE_6681_length_332_cov_1.189189_g6634_i0	PRJNA733995	6681	332	1.189189	3.94810748	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	470	7.289999999999999e-128	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g6634	i0	92.216	131.927710843373	334	22	100	4	1	332	2977695	2978026	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	43800	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
5820193	5820193	PRJNA733995_P_NODE_11945_length_251_cov_0.865169_g11898_i0	PRJNA733995	11945	251	0.865169	2.17157419	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	137	6.100000000000001e-28	NTclustered	gi\|2874253850\|emb\|OY969906.1\|	866510	g11898	i0	77.447	3.06772908366534	235	50	93	3	16	249	3699860	3699628	MAG: uncultured Chitinophagaceae bacterium isolate MFD05502.bin.c.1 genome assembly, chromosome: 1	blastn	770	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
5820232	5820232	PRJNA733995_P_NODE_3625_length_461_cov_2.829897_g3578_i0	PRJNA733995	3625	461	2.829897	13.04582517	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	577	5.969999999999999e-160	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g3578	i0	99.683	216.377440347072	315	1	97	0	1	315	2978449	2978763	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	99750	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
8849749	8849749	PRJNA733995_P_NODE_11007_length_261_cov_2.436170_g10960_i0	PRJNA733995	11007	261	2.43617	6.3584037	Bacteroidota	976	Bacteria	Bacteria	200	8.029999999999999e-47	NTclustered	gi\|1616390602\|gb\|CP038810.1\|	2518177	g10960	i0	81.667	1.76628352490421	240	44	92	0	22	261	1199856	1200095	Flavobacterium sangjuense strain GS03 chromosome, complete genome	blastn	461	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sangjuense
19843536	19843536	PRJNA733995_P_NODE_12216_length_249_cov_3.534091_g12169_i0	PRJNA733995	12216	249	3.534091	8.79988659	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g12169	i0	96.371	269.582329317269	248	5	99	2	2	249	2979471	2979228	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	67126	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
21119180	21119180	PRJNA733995_P_NODE_12017_length_251_cov_0.865169_g11970_i0	PRJNA733995	12017	251	0.865169	2.17157419	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	220	5.89e-53	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g11970	i0	83.691	3.29083665338645	233	38	93	0	2	234	2814172	2813940	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	826	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
23669719	23669719	PRJNA733995_P_NODE_8779_length_290_cov_1.373272_g8732_i0	PRJNA733995	8779	290	1.373272	3.9824888	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	418	2.3e-112	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g8732	i0	92.734	1.99310344827586	289	21	99	0	1	289	1453979	1453691	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	578	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
24943115	24943115	PRJNA733995_P_NODE_5660_length_361_cov_3.427083_g5613_i0	PRJNA733995	5660	361	3.427083	12.37176963	Chryseobacterium gallinarum	1324352	Bacteria	Bacteria	171	9.05e-38	NTclustered	gi\|1830200908\|gb\|CP050996.1\|	1324352	g5613	i0	100	3.23268698060942	92	0	53	0	263	354	1070	1161	Chryseobacterium gallinarum strain FDAARGOS_636 plasmid unnamed2	blastn	1167	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum
24943122	24943122	PRJNA733995_P_NODE_6940_length_326_cov_1.217391_g6893_i0	PRJNA733995	6940	326	1.217391	3.96869466	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1858604176\|gb\|CP054675.1\|	2053306	g6893	i0	100	0.0889570552147239	29	0	9	0	165	193	1860936	1860908	Ignavibacteria bacterium isolate Ch128a chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;