metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA971676" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA971676" 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
944591	944591	PRJNA971676_P_NODE_16361_length_249_cov_0.875000_g16272_i0	PRJNA971676	16361	249	0.875	2.17875	Maribellus comscasis	2681766	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1785267174\|gb\|CP046401.1\|	2681766	g16272	i0	94.595	0.14859437751004	37	0	14	2	166	200	4838075	4838039	Maribellus comscasis strain WC007 chromosome, complete genome	blastn	37	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Maribellus	Maribellus comscasis
5094666	5094666	PRJNA971676_P_NODE_10124_length_285_cov_1.452830_g10035_i0	PRJNA971676	10124	285	1.45283	4.1405655	Weeksellaceae	2762318	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g10035	i0	100	469.99649122807	285	0	100	0	1	285	131623	131339	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	133949	527	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8597627	8597627	PRJNA971676_P_NODE_21247_length_243_cov_0.905882_g21158_i0	PRJNA971676	21247	243	0.905882	2.20129326	Chryseobacterium scophthalmum	59733	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g21158	i0	100	5.97530864197531	243	0	100	0	1	243	401500	401258	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	1452	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
9872885	9872885	PRJNA971676_P_NODE_23168_length_241_cov_0.916667_g23079_i0	PRJNA971676	23168	241	0.916667	2.20916747	Chryseobacterium sp. M5	3379128	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|2853920187\|gb\|CP173626.1\|	3379128	g23079	i0	97.095	6.90871369294606	241	7	100	0	1	241	526166	526406	Chryseobacterium sp. M5 chromosome, complete genome	blastn	1665	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. M5
14972429	14972429	PRJNA971676_P_NODE_11672_length_271_cov_0.969697_g11583_i0	PRJNA971676	11672	271	0.969697	2.62787887	Chryseobacterium lactis	1241981	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1519559429\|gb\|CP033925.1\|	1241981	g11583	i0	94.286	0.25830258302583	35	2	13	0	51	85	1083539	1083573	Chryseobacterium lactis strain G0197 chromosome, complete genome	blastn	70	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium lactis
14972580	14972580	PRJNA971676_P_NODE_20692_length_244_cov_0.900585_g20603_i0	PRJNA971676	20692	244	0.900585	2.1974274	Chryseobacterium sp. KACC 21268	3025664	Bacteria	Bacteria	414	2.44e-111	NTclustered	gi\|2446111318\|gb\|CP117875.1\|	3025664	g20603	i0	97.521	13.1106557377049	242	6	99	0	3	244	3899487	3899728	Chryseobacterium sp. KACC 21268 chromosome, complete genome	blastn	3199	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. KACC 21268
16568931	16568931	PRJNA971676_P_NODE_2113_length_524_cov_1.698448_g2024_i0	PRJNA971676	2113	524	1.698448	8.89986752	Chryseobacterium	59732	Bacteria	Bacteria	830	0	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g2024	i0	95.229	489.729007633588	524	25	100	0	1	524	1757232	1757755	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	256618	830	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
18796408	18796408	PRJNA971676_P_NODE_18575_length_246_cov_0.890173_g18486_i0	PRJNA971676	18575	246	0.890173	2.18982558	uncultured candidate division Zixibacteria bacterium	1664345	Bacteria	Bacteria	165	2.74e-36	NTclustered	gi\|2874254123\|emb\|OY970208.1\|	1664345	g18486	i0	80.645	0.882113821138211	217	39	88	3	6	221	277702	277916	MAG: uncultured candidate division Zixibacteria bacterium isolate MFD04408.bin.1.44 genome assembly, chromosome: 1	blastn	217	165	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota					uncultured candidate division Zixibacteria bacterium
18796566	18796566	PRJNA971676_P_NODE_5235_length_363_cov_1.179310_g5146_i0	PRJNA971676	5235	363	1.17931	4.2808953	Fulvivirga ulvae	2904245	Bacteria	Bacteria	455	2.2500000000000003e-123	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g5146	i0	89.474	290.589531680441	361	36	99	2	1	359	447597	447957	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	105484	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae
21668913	21668913	PRJNA971676_P_NODE_9577_length_290_cov_1.714286_g9488_i0	PRJNA971676	9577	290	1.714286	4.9714294	Chryseobacterium	59732	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g9488	i0	100	517.203448275862	290	0	100	0	1	290	167743	168032	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	149989	536	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
25170615	25170615	PRJNA971676_P_NODE_10660_length_280_cov_1.371981_g10571_i0	PRJNA971676	10660	280	1.371981	3.8415468	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	392	1.3399999999999999e-104	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g10571	i0	92.115	410.392857142857	279	21	99	1	1	278	2012882	2012604	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	114910	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris

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