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

18 rows where bioproject = "PRJNA383995" 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
405266	405266	PRJNA383995_P_NODE_15581_length_167_cov_0.864407_g15482_i0	PRJNA383995	15581	167	0.864407	1.44355969	Prevotella jejuni	1177574	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1318680913\|gb\|CP023863.1\|	1177574	g15482	i0	98.204	8.82035928143713	167	3	100	0	1	167	1157441	1157607	Prevotella jejuni strain CD3:33 chromosome I, complete sequence	blastn	1473	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella jejuni
3626531	3626531	PRJNA383995_P_NODE_2443_length_388_cov_3.253687_g2344_i0	PRJNA383995	2443	388	3.253687	12.62430556	Chryseobacterium	59732	Bacteria	Bacteria	643	4.809999999999999e-180	NTclustered	gi\|2463614404\|gb\|CP120209.1\|	253	g2344	i0	96.641	470.481958762887	387	13	99	0	1	387	3063932	3063546	Chryseobacterium indologenes strain Ery-6B chromosome, complete genome	blastn	182547	649	0.99075500770416	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
5508970	5508970	PRJNA383995_P_NODE_3125_length_349_cov_1.886667_g3026_i0	PRJNA383995	3125	349	1.886667	6.58446783	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	292	1.7799999999999998e-74	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g3026	i0	82.073	165.43553008596	357	51	100	10	1	349	359252	358901	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	57737	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
8058568	8058568	PRJNA383995_P_NODE_17787_length_163_cov_0.894737_g17688_i0	PRJNA383995	17787	163	0.894737	1.45842131	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g17688	i0	96.933	329.466257668712	163	5	100	0	1	163	1406734	1406572	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	53703	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
8058573	8058573	PRJNA383995_P_NODE_18927_length_161_cov_0.910714_g18828_i0	PRJNA383995	18927	161	0.910714	1.46624954	Prevotella corporis	28128	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|2446185766\|gb\|CP118020.1\|	28128	g18828	i0	95.031	1	161	8	100	0	1	161	1634091	1633931	Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence	blastn	161	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis
10003929	10003929	PRJNA383995_P_NODE_19248_length_159_cov_2.581818_g19149_i0	PRJNA383995	19248	159	2.581818	4.10509062	Bacteroidota	976	Bacteria	Bacteria	267	4.3199999999999996e-67	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g19149	i0	96.855	308.358490566038	159	5	100	0	1	159	218885	219043	Aureispira anguillae EL160426 DNA, complete genome	blastn	49029	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
10003930	10003930	PRJNA383995_P_NODE_2668_length_375_cov_2.386503_g2569_i0	PRJNA383995	2668	375	2.386503	8.94938625	Chryseobacterium	59732	Bacteria	Bacteria	649	0	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g2569	i0	97.867	507.546666666667	375	8	100	0	1	375	1093856	1094230	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	190330	654	0.992354740061162	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
13158993	13158993	PRJNA383995_P_NODE_16771_length_165_cov_0.879310_g16672_i0	PRJNA383995	16771	165	0.87931	1.4508615	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	202	1.29e-47	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g16672	i0	92.254	339.163636363636	142	11	86	0	24	165	2013331	2013190	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	55962	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
14434004	14434004	PRJNA383995_P_NODE_2852_length_364_cov_0.809524_g2753_i0	PRJNA383995	2852	364	0.809524	2.94666736	Hymenobacter sediminicola	2761579	Bacteria	Bacteria	662	0	NTclustered	gi\|1893848427\|gb\|CP060202.1\|	2761579	g2753	i0	99.451	315.387362637363	364	2	100	0	1	364	246378	246015	Hymenobacter sediminicola strain S2-20-2 chromosome, complete genome	blastn	114801	662	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sediminicola
15103599	15103599	PRJNA383995_P_NODE_132_length_1366_cov_3.719058_g94_i0	PRJNA383995	132	1366	3.719058	50.80233228	Chryseobacterium	59732	Bacteria	Bacteria	2457	0	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g94	i0	99.122	533.301610541728	1367	10	100	2	1	1366	457643	456278	Chryseobacterium indologenes strain AA5 chromosome, complete genome	blastn	728490	2462	0.997969130787977	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16378301	16378301	PRJNA383995_P_NODE_2693_length_374_cov_1.289231_g2594_i0	PRJNA383995	2693	374	1.289231	4.82172394	Cytophaga	978	Bacteria	Bacteria	525	1.7399999999999995e-144	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g2594	i0	92	292.668449197861	375	28	100	2	1	374	833	460	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	109458	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
17653375	17653375	PRJNA383995_P_NODE_17414_length_163_cov_2.666667_g17315_i0	PRJNA383995	17414	163	2.666667	4.34666721	Weeksellaceae	2762318	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g17315	i0	100	414.687116564417	163	0	100	0	1	163	227894	227732	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	67594	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
19531105	19531105	PRJNA383995_P_NODE_14156_length_175_cov_0.968254_g14057_i0	PRJNA383995	14156	175	0.968254	1.6944445	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g14057	i0	94.857	472.565714285714	175	9	100	0	1	175	729567	729393	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	82699	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
20806874	20806874	PRJNA383995_P_NODE_617_length_709_cov_4.383333_g536_i0	PRJNA383995	617	709	4.383333	31.07783097	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	846	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g536	i0	88.97	278.277856135402	689	70	97	6	22	709	217540	216857	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	197299	846	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
24027531	24027531	PRJNA383995_P_NODE_14459_length_172_cov_2.902439_g14360_i0	PRJNA383995	14459	172	2.902439	4.99219508	Dokdonia	326319	Bacteria	Bacteria	202	1.35e-47	NTclustered	gi\|332168736\|gb\|CP002528.1\|	983548	g14360	i0	87.861	278.133720930233	173	19	100	2	1	172	2386335	2386506	Dokdonia sp. 4H-3-7-5 chromosome, complete genome	blastn	47839	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Dokdonia	Dokdonia sp. 4H-3-7-5
25301974	25301974	PRJNA383995_P_NODE_10080_length_206_cov_1.101911_g9981_i0	PRJNA383995	10080	206	1.101911	2.26993666	Bacteria	2	Bacteria	Bacteria	294	2.71e-75	NTclustered	gi\|2874253850\|emb\|OY969906.1\|	866510	g9981	i0	92.647	265.029126213592	204	15	99	0	1	204	3013346	3013143	MAG: uncultured Chitinophagaceae bacterium isolate MFD05502.bin.c.1 genome assembly, chromosome: 1	blastn	54596	296	0.993243243243243	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
26758538	26758538	PRJNA383995_P_NODE_11061_length_197_cov_1.722973_g10962_i0	PRJNA383995	11061	197	1.722973	3.39425681	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	43.1	0.0137	NR	RYG34286.1	1869212	g10962	i0	40	0.761421319796954	50	29	76.1	1	170	21	131	179	RYG34286.1 MAG: RNA methyltransferase [Chitinophagaceae bacterium]	diamond	150	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27296417	27296417	PRJNA383995_P_NODE_18163_length_162_cov_0.902655_g18064_i0	PRJNA383995	18163	162	0.902655	1.4623011	Odoribacter sp.	1965233	Bacteria	Bacteria	41.2	0.0457	NR	MEI3155254.1	1965233	g18064	i0	51.3	0.722222222222222	39	18	72.2	1	40	156	283	320	MEI3155254.1 tetratricopeptide repeat protein [Odoribacter sp.]	diamond	117	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter sp.

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