metadata: contig_metadata: 18 rows where bioproject = "PRJNA768450" and tax

18 rows where bioproject = "PRJNA768450" 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
2021316	2021316	PRJNA768450_P_NODE_1842_length_160_cov_13641.900763_g1770_i0	PRJNA768450	1842	160	13641.900763	21827.0412208	Chryseobacterium gallinarum	1324352	Bacteria	Bacteria	119	1.29e-22	NTclustered	gi\|1830200908\|gb\|CP050996.1\|	1324352	g1770	i0	100	3.2375	64	0	75	0	97	160	1071	1134	Chryseobacterium gallinarum strain FDAARGOS_636 plasmid unnamed2	blastn	518	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum
5849356	5849356	PRJNA768450_S_NODE_23545_length_162_cov_1.292035_g23496_i0	PRJNA768450	23545	162	1.292035	2.0930967	Chryseobacterium gambrini	373672	Bacteria	Bacteria	285	1.2199999999999998e-72	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g23496	i0	99.367	97.1975308641975	158	0	97	1	1	157	3372125	3371968	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	15746	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
7124040	7124040	PRJNA768450_P_NODE_666_length_402_cov_3.608579_g599_i0	PRJNA768450	666	402	3.608579	14.50648758	Fluviicola sp.	1917219	Bacteria	Bacteria	420	9.17e-113	NTclustered	gi\|2837311343\|gb\|CP121319.1\|	1917219	g599	i0	85.821	290.268656716418	402	44	100	4	1	402	247474	247086	MAG: Fluviicola sp. isolate NCC532_bact_2449 chromosome, complete genome	blastn	116688	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola sp.
7124706	7124706	PRJNA768450_S_NODE_4126_length_311_cov_1.465649_g4077_i0	PRJNA768450	4126	311	1.465649	4.55816839	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	473	5.2299999999999996e-129	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g4077	i0	96.22	471.411575562701	291	7	93	4	1	288	1037806	1037517	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	146609	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
8859252	8859252	PRJNA768450_P_NODE_1347_length_232_cov_2.147783_g1275_i0	PRJNA768450	1347	232	2.147783	4.98285656	Gemmatimonas	173479	Bacteria	Bacteria	383	6.48e-102	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g1275	i0	96.537	323	231	8	99	0	2	232	907	677	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	74936	383	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
8859253	8859253	PRJNA768450_P_NODE_1667_length_192_cov_2.656442_g1595_i0	PRJNA768450	1667	192	2.656442	5.10036864	Fluviicola	332102	Bacteria	Bacteria	289	1.1599999999999998e-73	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g1595	i0	93.75	84.3802083333333	192	12	100	0	1	192	1594	1403	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	16201	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
14774599	14774599	PRJNA768450_S_NODE_19852_length_170_cov_5.214876_g19803_i0	PRJNA768450	19852	170	5.214876	8.8652892	Algoriphagus machipongonensis	388413	Bacteria	Bacteria	174	2.91e-39	NTclustered	gi\|662020028\|ref\|NR_121915.1\|	388413	g19803	i0	93.913	232.564705882353	115	7	68	0	53	167	128	14	Algoriphagus machipongonensis strain PR1 23S ribosomal RNA gene, complete sequence	blastn	39536	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus machipongonensis
16048002	16048002	PRJNA768450_S_NODE_12393_length_204_cov_1.167742_g12344_i0	PRJNA768450	12393	204	1.167742	2.38219368	Flavobacterium covae	2906076	Bacteria	Bacteria	355	1.21e-93	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g12344	i0	98.039	593	204	4	100	0	1	204	1570420	1570217	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	120972	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
16048646	16048646	PRJNA768450_S_NODE_6053_length_267_cov_1145.733945_g6004_i0	PRJNA768450	6053	267	1145.733945	3059.10963315	Chryseobacterium gambrini	373672	Bacteria	Bacteria	381	2.739999999999999e-101	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g6004	i0	97.738	306.479400749064	221	5	83	0	45	265	1757297	1757517	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	81830	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
16509136	16509136	PRJNA768450_S_NODE_19133_length_173_cov_1.500000_g19084_i0	PRJNA768450	19133	173	1.5	2.595	Flavobacterium	237	Bacteria	Bacteria	291	2.8299999999999998e-74	NTclustered	gi\|2450142035\|gb\|OQ546399.1\|	239	g19084	i0	97.093	99.4971098265896	172	5	99	0	1	172	332	503	Flavobacterium sp. strain CA_59 16S ribosomal RNA gene, partial sequence	blastn	17213	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
18597060	18597060	PRJNA768450_P_NODE_255_length_657_cov_3.176752_g225_i0	PRJNA768450	255	657	3.176752	20.87126064	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	697	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g225	i0	93.362	219.089802130898	467	20	98	4	1	467	2977625	2978080	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	143942	697	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
19057864	19057864	PRJNA768450_S_NODE_11435_length_210_cov_0.931677_g11386_i0	PRJNA768450	11435	210	0.931677	1.9565217	Chryseobacterium	59732	Bacteria	Bacteria	364	2.0799999999999992e-96	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g11386	i0	100	375.47619047619	197	0	94	0	14	210	1756861	1757057	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	78850	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19872112	19872112	PRJNA768450_P_NODE_356_length_565_cov_2.932836_g315_i0	PRJNA768450	356	565	2.932836	16.5705234	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	490	9.959999999999998e-134	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g315	i0	96.321	269.976991150442	299	9	98	2	1	297	787692	787394	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	152537	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
21147894	21147894	PRJNA768450_P_NODE_437_length_506_cov_3.228512_g389_i0	PRJNA768450	437	506	3.228512	16.33627072	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	455	3.2300000000000004e-123	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g389	i0	91.071	271.703557312253	336	30	97	0	1	336	786302	786637	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	137482	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
22884037	22884037	PRJNA768450_S_NODE_8598_length_234_cov_1.745946_g8549_i0	PRJNA768450	8598	234	1.745946	4.08551364	Flavobacterium	237	Bacteria	Bacteria	427	2.9799999999999993e-115	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g8549	i0	100	555	231	0	100	0	4	234	1150007	1149777	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	129870	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
23698625	23698625	PRJNA768450_S_NODE_18879_length_174_cov_1.256000_g18830_i0	PRJNA768450	18879	174	1.256	2.18544	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	302	1.3200000000000001e-77	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g18830	i0	100	523.942528735632	163	0	94	0	12	174	1149978	1150140	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	91166	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
28727015	28727015	PRJNA768450_S_NODE_12707_length_202_cov_1.202614_g12658_i0	PRJNA768450	12707	202	1.202614	2.42928028	Sediminibacterium goheungense	1086393	Bacteria	Bacteria	103	7.79e-27	NR	TDO25478.1	1086393	g12658	i0	98.1	1.57425742574257	53	1	78.7	0	4	162	56	108	TDO25478.1 ribosomal protein L29 [Sediminibacterium goheungense]	diamond	318	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium goheungense
32298211	32298211	PRJNA768450_S_NODE_7959_length_241_cov_1.796875_g7910_i0	PRJNA768450	7959	241	1.796875	4.33046875	Prevotella sp. P3-12	59823	Bacteria	Bacteria	71.6	1.57e-14	NR	WP_216822835.1	2024220	g7910	i0	91.4	0.435684647302905	35	3	43.6	0	139	35	3	37	WP_216822835.1 hypothetical protein, partial [Prevotella sp. P3-120]	diamond	105	71.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. P3-120

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