metadata: contig_metadata: 11 rows where bioproject = "PRJNA749559" and tax

11 rows where bioproject = "PRJNA749559" 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
5829589	5829589	PRJNA749559_P_NODE_5025_length_201_cov_0.914286_g4955_i0	PRJNA749559	5025	201	0.914286	1.83771486	Chryseobacterium gambrini	373672	Bacteria	Bacteria	207	3.53e-49	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g4955	i0	85.714	2.93034825870647	196	28	98	0	3	198	1107383	1107578	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	589	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
7104659	7104659	PRJNA749559_P_NODE_3186_length_242_cov_2.204420_g3116_i0	PRJNA749559	3186	242	2.20442	5.3346964	Salinimicrobium sp. 3283s	3114359	Bacteria	Bacteria	340	4.15e-89	NTclustered	gi\|2729656191\|gb\|CP143631.1\|	3114359	g3116	i0	92.149	408.140495867769	242	18	100	1	1	242	633565	633805	Salinimicrobium sp. 3283s chromosome, complete genome	blastn	98770	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Salinimicrobium	Salinimicrobium sp. 3283s
7104676	7104676	PRJNA749559_P_NODE_4626_length_205_cov_0.888889_g4556_i0	PRJNA749559	4626	205	0.888889	1.82222245	Aegicerativicinus sediminis	2893202	Bacteria	Bacteria	237	4.6e-58	NTclustered	gi\|1932021883\|gb\|CP064295.1\|	2893202	g4556	i0	87.805	268.565853658537	205	21	99	4	1	204	43058	42857	Aegicerativicinus sediminis strain SM2-F chromosome, complete genome	blastn	55056	237	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aegicerativicinus	Aegicerativicinus sediminis
7577794	7577794	PRJNA749559_P_NODE_3686_length_224_cov_0.901840_g3616_i0	PRJNA749559	3686	224	0.90184	2.0201216	Prevotella	838	Bacteria	Bacteria	403	4.7699999999999995e-108	NTclustered	gi\|2030190567\|gb\|CP073339.1\|	28129	g3616	i0	99.107	259.955357142857	224	2	100	0	1	224	221949	221726	Prevotella denticola strain F0105 chromosome	blastn	58230	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
8852842	8852842	PRJNA749559_P_NODE_3707_length_223_cov_1.580247_g3637_i0	PRJNA749559	3707	223	1.580247	3.52395081	Bacteroides	816	Bacteria	Bacteria	324	3.8e-84	NTclustered	gi\|453199329\|gb\|JQ997309.1\|	162156	g3637	i0	92.857	396.843049327354	224	14	100	2	1	223	497	275	Uncultured Bacteroides sp. clone GKJWQY101BLVR4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	88496	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
11403647	11403647	PRJNA749559_P_NODE_3749_length_222_cov_0.981366_g3679_i0	PRJNA749559	3749	222	0.981366	2.17863252	Antarcticibacterium	2058174	Bacteria	Bacteria	377	2.86e-100	NTclustered	gi\|1679650456\|gb\|CP040812.1\|	2058175	g3679	i0	97.297	281.346846846847	222	6	100	0	1	222	536716	536937	Antarcticibacterium flavum strain KCTC 52984 chromosome, complete genome	blastn	62459	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Antarcticibacterium	Antarcticibacterium flavum
12679504	12679504	PRJNA749559_P_NODE_5010_length_201_cov_0.914286_g4940_i0	PRJNA749559	5010	201	0.914286	1.83771486	Cloacibacterium	501783	Bacteria	Bacteria	305	1.22e-78	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g4940	i0	94.03	3	201	12	100	0	1	201	420831	420631	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	603	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
17777570	17777570	PRJNA749559_P_NODE_1534_length_360_cov_1.685619_g1464_i0	PRJNA749559	1534	360	1.685619	6.0682284	Hymenobacter	89966	Bacteria	Bacteria	483	1.02e-131	NTclustered	gi\|195972569\|emb\|FM202729.1\|	552353	g1464	i0	90.934	102.002777777778	364	25	100	8	1	360	141	500	Hymenobacter sp. CS10 partial 16S rRNA gene, strain CS10	blastn	36721	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. CS10
22877407	22877407	PRJNA749559_P_NODE_1118_length_434_cov_1.514745_g1048_i0	PRJNA749559	1118	434	1.514745	6.5739933	Aquirufa	2676247	Bacteria	Bacteria	549	1.2199999999999996e-151	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g1048	i0	89.767	354.412442396313	430	42	99	2	1	429	213145	213573	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	153815	549	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
27495198	27495198	PRJNA749559_P_NODE_5063_length_201_cov_0.914286_g4993_i0	PRJNA749559	5063	201	0.914286	1.83771486	Porphyromonas sp.	1924944	Bacteria	Bacteria	135	2.26e-35	NR	MBF1379052.1	1924944	g4993	i0	100	1.97014925373134	66	0	98.5	0	2	199	76	141	MBF1379052.1 penicillin-binding protein 2 [Porphyromonas sp.]	diamond	396	135	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp.
29074039	29074039	PRJNA749559_P_NODE_5168_length_192_cov_2.503817_g5098_i0	PRJNA749559	5168	192	2.503817	4.80732864	Chryseobacterium takakiae	1302685	Bacteria	Bacteria	95.5	4.439999999999999e-23	NR	WP_072886063.1	1302685	g5098	i0	71	0.96875	62	18	96.9	0	6	191	85	146	WP_072886063.1 hypothetical protein [Chryseobacterium takakiae]	diamond	186	95.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium takakiae

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