metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA306153" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA306153" and tax_phylum = "Bacteroidota"

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
2337502	2337502	PRJNA306153_S_NODE_862_length_256_cov_23.691630_g849_i0	PRJNA306153	862	256	23.69163	60.6505728	Flavobacteriales	200644	Bacteria	Bacteria	435	1.98e-117	NTclustered	gi\|2070982444\|gb\|MZ604937.1\|	253	g849	i0	97.266	106	256	7	100	0	1	256	534	789	Chryseobacterium indologenes strain HR_327 16S ribosomal RNA gene, partial sequence	blastn	27136	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
4203537	4203537	PRJNA306153_S_NODE_64_length_661_cov_36.840190_g59_i0	PRJNA306153	64	661	36.84019	243.5136559	Hymenobacter sp. BRD67	2675877	Bacteria	Bacteria	1099	0	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g59	i0	96.809	265.676248108926	658	21	100	0	4	661	4321984	4321327	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	175612	1099	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
4890162	4890162	PRJNA306153_S_NODE_184_length_483_cov_25.870044_g172_i0	PRJNA306153	184	483	25.870044	124.95231252	Flectobacillus	101	Bacteria	Bacteria	604	2.879999999999999e-168	NTclustered	gi\|1493551571\|dbj\|LC378791.1\|	50419	g172	i0	89.634	99.3561076604555	492	27	100	19	1	483	492	16	Flectobacillus sp. LA-DMC-4W29 gene for 16S ribosomal RNA, partial sequence	blastn	47989	610	0.99016393442623	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
5479845	5479845	PRJNA306153_S_NODE_585_length_304_cov_15.880000_g572_i0	PRJNA306153	585	304	15.88	48.2752	Hymenobacter monticola	1705399	Bacteria	Bacteria	396	1.14e-105	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g572	i0	94.574	328.279605263158	258	10	84	4	1	256	1096511	1096766	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	99797	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
6165007	6165007	PRJNA306153_S_NODE_125_length_548_cov_11.608863_g117_i0	PRJNA306153	125	548	11.608863	63.61656924	Aquirufa	2676247	Bacteria	Bacteria	588	3.319999999999999e-163	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g117	i0	86.339	232.229927007299	549	63	99	9	1	544	213714	214255	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	127262	593	0.991568296795953	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
8029611	8029611	PRJNA306153_S_NODE_1047_length_233_cov_21.014706_g1034_i0	PRJNA306153	1047	233	21.014706	48.96426498	Hymenobacter monticola	1705399	Bacteria	Bacteria	335	1.8499999999999992e-87	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g1034	i0	92.735	203.278969957082	234	14	100	3	1	233	1093797	1094028	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	47364	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
8029614	8029614	PRJNA306153_S_NODE_447_length_339_cov_40.822581_g434_i0	PRJNA306153	447	339	40.822581	138.38854959	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	582	9.179999999999996e-162	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g434	i0	97.64	340.705014749263	339	8	100	0	1	339	338554	338216	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	115499	582	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
8714891	8714891	PRJNA306153_S_NODE_1347_length_207_cov_37.679775_g1334_i0	PRJNA306153	1347	207	37.679775	77.99713425	Flectobacillus	101	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2868812398\|dbj\|LC855767.1\|	50419	g1334	i0	100	100	207	0	100	0	1	207	652	446	Flectobacillus sp. FWB18 gene for 16S ribosomal RNA, partial sequence	blastn	20700	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
9304425	9304425	PRJNA306153_S_NODE_448_length_339_cov_32.935484_g435_i0	PRJNA306153	448	339	32.935484	111.65129076	Hymenobacter monticola	1705399	Bacteria	Bacteria	505	2.0399999999999995e-138	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g435	i0	93.51	328.772861356932	339	22	100	0	1	339	2283204	2282866	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	111454	505	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
10580296	10580296	PRJNA306153_S_NODE_229_length_438_cov_6.410758_g217_i0	PRJNA306153	229	438	6.410758	28.07912004	Aureibacter tunicatorum	866807	Bacteria	Bacteria	394	6.11e-105	NTclustered	gi\|2581931629\|dbj\|AP025313.1\|	866807	g217	i0	83.221	266.223744292237	447	58	99	15	2	438	5681	6120	Aureibacter tunicatorum NBRC 107587 plasmid pATrrn DNA, complete genome	blastn	116606	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Aureibacter	Aureibacter tunicatorum
12540757	12540757	PRJNA306153_S_NODE_1350_length_207_cov_10.331461_g1337_i0	PRJNA306153	1350	207	10.331461	21.38612427	Cloacibacterium	501783	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g1337	i0	100	467.265700483092	207	0	100	0	1	207	1872674	1872468	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	96724	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12540758	12540758	PRJNA306153_S_NODE_1750_length_186_cov_25.713376_g1737_i0	PRJNA306153	1750	186	25.713376	47.82687936	Weeksellaceae	2762318	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1519537162\|gb\|CP033926.1\|	112234	g1737	i0	100	455.962365591398	186	0	100	0	1	186	2804017	2804202	Chryseobacterium joostei strain DSM 16927 chromosome, complete genome	blastn	84809	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium joostei
12540762	12540762	PRJNA306153_S_NODE_2790_length_150_cov_12.041322_g2777_i0	PRJNA306153	2790	150	12.041322	18.061983	Chryseobacterium	59732	Bacteria	Bacteria	161	1.95e-35	NTclustered	gi\|1830197182\|gb\|CP050995.1\|	1324352	g2777	i0	86.093	285.906666666667	151	20	100	1	1	150	3629060	3628910	Chryseobacterium gallinarum strain FDAARGOS_636 chromosome, complete genome	blastn	42886	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum
12540763	12540763	PRJNA306153_S_NODE_30_length_781_cov_26.680851_g27_i0	PRJNA306153	30	781	26.680851	208.37744631	Hymenobacter	89966	Bacteria	Bacteria	944	0	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g27	i0	89.651	205.741357234315	744	73	95	3	38	781	433660	432921	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	160684	944	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
13130165	13130165	PRJNA306153_S_NODE_111_length_564_cov_38.775701_g103_i0	PRJNA306153	111	564	38.775701	218.69495364	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	832	0	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g103	i0	93.286	329.15780141844	566	34	100	4	1	564	339201	338638	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	185645	832	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
13130167	13130167	PRJNA306153_S_NODE_1951_length_177_cov_56.479730_g1938_i0	PRJNA306153	1951	177	56.479730000000004	99.9691221	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	311	2.23e-80	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g1938	i0	98.305	286.084745762712	177	3	100	0	1	177	1300286	1300110	Hymenobacter sp. APR13, complete genome	blastn	50637	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
14405344	14405344	PRJNA306153_S_NODE_1292_length_212_cov_28.633880_g1279_i0	PRJNA306153	1292	212	28.63388	60.7038256	Hymenobacter sp. BRD67	2675877	Bacteria	Bacteria	252	1.71e-62	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g1279	i0	88.018	223.438679245283	217	21	100	5	1	212	434848	434632	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	47369	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
14405356	14405356	PRJNA306153_S_NODE_392_length_358_cov_14.547112_g379_i0	PRJNA306153	392	358	14.547112	52.07866096	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	464	3.669999999999999e-126	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g379	i0	90.169	368.888268156425	356	35	99	0	3	358	216945	217300	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	132062	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
14405358	14405358	PRJNA306153_S_NODE_552_length_311_cov_25.460993_g539_i0	PRJNA306153	552	311	25.460993	79.18368823	Hymenobacter monticola	1705399	Bacteria	Bacteria	464	3.1499999999999995e-126	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g539	i0	94.983	264.379421221865	299	9	100	6	16	311	1095731	1095436	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	82222	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
14405360	14405360	PRJNA306153_S_NODE_612_length_298_cov_40.762082_g599_i0	PRJNA306153	612	298	40.762082	121.47100436	uncultured Cytophagaceae bacterium	194250	Bacteria	Bacteria	460	3.88e-125	NTclustered	gi\|545341271\|gb\|KF504503.1\|	194250	g599	i0	98.837	86.4328859060403	258	3	87	0	41	298	493	236	Uncultured Cytophagaceae bacterium clone 3869 16S ribosomal RNA gene, partial sequence	blastn	25757	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Cytophagaceae bacterium
17639904	17639904	PRJNA306153_S_NODE_2774_length_151_cov_2.286885_g2761_i0	PRJNA306153	2774	151	2.286885	3.45319635	root	1	Root_unresolved	Root_unresolved	268	1.12e-67	NTclustered	gi\|1379403122\|gb\|MH236651.1\|	239	g2761	i0	98.675	100	151	2	100	0	1	151	694	544	Flavobacterium sp. strain J4 16S ribosomal RNA gene, partial sequence	blastn	15100	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
17639907	17639907	PRJNA306153_S_NODE_414_length_349_cov_26.025000_g401_i0	PRJNA306153	414	349	26.025	90.82725	Cloacibacterium	501783	Bacteria	Bacteria	617	2.59e-172	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g401	i0	98.567	478.489971346705	349	5	100	0	1	349	130364	130016	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	166993	617	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
20188334	20188334	PRJNA306153_S_NODE_696_length_285_cov_25.371094_g683_i0	PRJNA306153	696	285	25.371094	72.3076179	Weeksellaceae	2762318	Bacteria	Bacteria	499	7.82e-137	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g683	i0	98.246	499.971929824561	285	5	100	0	1	285	129805	130089	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	142492	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
20777884	20777884	PRJNA306153_S_NODE_1277_length_213_cov_45.293478_g1264_i0	PRJNA306153	1277	213	45.293478	96.47510814	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	344	2.76e-90	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g1264	i0	95.794	357.051643192488	214	8	100	1	1	213	338736	338523	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	76052	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
20777891	20777891	PRJNA306153_S_NODE_597_length_302_cov_24.989011_g584_i0	PRJNA306153	597	302	24.989011	75.46681322	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	407	5.21e-109	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g584	i0	94.382	317.370860927152	267	12	88	3	1	265	338300	338035	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	95846	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
23328384	23328384	PRJNA306153_S_NODE_1679_length_189_cov_23.162500_g1666_i0	PRJNA306153	1679	189	23.1625	43.777125	Hymenobacter sp. 5317J-9	2932250	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|2221939013\|gb\|CP095050.1\|	2932250	g1666	i0	94.18	208.820105820106	189	11	100	0	1	189	596322	596510	Hymenobacter sp. 5317J-9 chromosome, complete genome	blastn	39467	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5317J-9
24014117	24014117	PRJNA306153_S_NODE_1299_length_211_cov_14851.500000_g1286_i0	PRJNA306153	1299	211	14851.5	31336.665	Flavobacterium	237	Bacteria	Bacteria	285	1.68e-72	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g1286	i0	99.363	361.488151658768	157	1	74	0	1	157	1416601	1416445	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	76274	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
25288375	25288375	PRJNA306153_S_NODE_280_length_405_cov_7325.047872_g268_i0	PRJNA306153	280	405	7325.047872	29666.4438816	Cloacibacterium	501783	Bacteria	Bacteria	652	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g268	i0	100	416.118518518518	353	0	87	0	53	405	130571	130219	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	168528	652	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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