metadata: contig_metadata: 16 rows where bioproject = "PRJEB1404" and tax

16 rows where bioproject = "PRJEB1404" and tax_kingdom = "Bacillati"

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
1295285	1295285	PRJEB1404_S_NODE_142_length_453_cov_4700.320574_g122_i0	PRJEB1404	142	453	4700.320574	21292.45220022	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	135	4.2400000000000006e-27	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g122	i0	98.684	15.2494481236203	76	1	17	0	359	434	854663	854738	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6908	135	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
6088829	6088829	PRJEB1404_S_NODE_4765_length_150_cov_2.339130_g4745_i0	PRJEB1404	4765	150	2.33913	3.508695	Trichotorquatus	2056240	Bacteria	Bacteria	78.7	2.02e-10	NTclustered	gi\|2277954471\|gb\|OP058661.1\|	2967162	g4745	i0	91.379	4.05333333333333	58	4	39	1	1	58	2214	2158	Trichotorquatus salinus FBCC-A1483 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	608	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Trichotorquatus	Trichotorquatus salinus
6399241	6399241	PRJEB1404_S_NODE_326_length_378_cov_5287.317784_g306_i0	PRJEB1404	326	378	5287.317784	19986.06122352	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	134	1.25e-26	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g306	i0	98.667	18.4232804232804	75	1	20	0	20	94	854738	854664	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6964	134	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
9913875	9913875	PRJEB1404_P_NODE_2888_length_209_cov_5.191011_g2862_i0	PRJEB1404	2888	209	5.191011	10.84921299	Streptococcus	1301	Bacteria	Bacteria	350	5.799999999999999e-92	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2862	i0	96.698	330.679425837321	212	3	100	3	1	209	1571394	1571604	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	69112	350	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11189045	11189045	PRJEB1404_P_NODE_3169_length_201_cov_1.005882_g3143_i0	PRJEB1404	3169	201	1.005882	2.02182282	Micrococcus	1269	Bacteria	Bacteria	368	1.53e-97	NTclustered	gi\|1147724504\|gb\|KY622466.1\|	1271	g3143	i0	100	100.024875621891	199	0	99	0	3	201	770	572	Micrococcus sp. strain LA401 16S ribosomal RNA gene, partial sequence	blastn	20105	368	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus sp.
11499124	11499124	PRJEB1404_S_NODE_290_length_390_cov_5160.938028_g270_i0	PRJEB1404	290	390	5160.938028	20127.6583092	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	135	3.6e-27	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g270	i0	98.684	17.7538461538462	76	1	19	0	20	95	854738	854663	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6924	135	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
14049230	14049230	PRJEB1404_S_NODE_472_length_347_cov_5849.208333_g452_i0	PRJEB1404	472	347	5849.208333	20296.75291551	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	134	1.14e-26	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g452	i0	98.667	19.8789625360231	75	1	22	0	254	328	854664	854738	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6898	134	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
14049231	14049231	PRJEB1404_S_NODE_512_length_340_cov_5997.721311_g492_i0	PRJEB1404	512	340	5997.721311	20392.2524574	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	135	3.1e-27	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g492	i0	98.684	20.7088235294118	76	1	22	0	20	95	854738	854663	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	7041	135	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
15323267	15323267	PRJEB1404_S_NODE_273_length_395_cov_5123.086111_g253_i0	PRJEB1404	273	395	5123.086111	20236.19013845	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	141	7.840000000000001e-29	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g253	i0	98.734	17.4227848101266	79	1	20	0	298	376	854660	854738	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6882	141	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
22973068	22973068	PRJEB1404_S_NODE_1179_length_266_cov_18.536797_g1159_i0	PRJEB1404	1179	266	18.536797	49.30788002	Streptococcus suis	1307	Bacteria	Bacteria	67.6	8.69e-7	NTclustered	gi\|459214170\|dbj\|AB737826.1\|	1307	g1159	i0	100	14.0075187969925	36	0	14	0	1	36	32868	32833	Streptococcus suis DNA, capsular polysaccharide locus, strain: 86-5192	blastn	3726	67.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
22973082	22973082	PRJEB1404_S_NODE_719_length_309_cov_6702.127737_g699_i0	PRJEB1404	719	309	6702.127737	20709.57470733	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	137	7.74e-28	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g699	i0	97.531	22.2815533980583	81	1	26	1	20	99	854738	854658	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6885	137	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
24246917	24246917	PRJEB1404_S_NODE_720_length_309_cov_6672.835766_g700_i0	PRJEB1404	720	309	6672.835766	20619.06251694	Negativicoccus massiliensis	1702287	Bacteria	Bacteria	135	2.79e-27	NTclustered	gi\|1127912416\|emb\|LT700188.1\|	1702287	g700	i0	98.684	22.2815533980583	76	1	25	0	215	290	854663	854738	Negativicoccus massiliensis strain Marseille-P2082 genome assembly, chromosome: contig00001	blastn	6885	135	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus massiliensis
28833092	28833092	PRJEB1404_P_NODE_4588_length_160_cov_1.302326_g4562_i0	PRJEB1404	4588	160	1.302326	2.0837216	Marmoricola endophyticus	2040280	Bacteria	Bacteria	43.9	0.00457	NR	WP_188779571.1	2040280	g4562	i0	43.5	0.8625	46	26	86.3	0	22	159	99	144	WP_188779571.1 hypothetical protein [Marmoricola endophyticus]	diamond	138	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola endophyticus
29085883	29085883	PRJEB1404_S_NODE_8_length_1003_cov_430.389463_g0_i6	PRJEB1404	8	1003	430.389463	4316.80631389	uncultured Schaedlerella sp.	2676055	Bacteria	Bacteria	49.3	0.0065	NR	WP_331495230.1	2676055	g0	i6	82.1	0.155533399800598	28	5	8.4	0	25	108	1	28	WP_331495230.1 SdpI family protein, partial [uncultured Schaedlerella sp.]	diamond	156	49.3	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Schaedlerella	uncultured Schaedlerella sp.
29559216	29559216	PRJEB1404_S_NODE_2350_length_209_cov_264.919540_g2330_i0	PRJEB1404	2350	209	264.91954	553.6818386	Enterocloster clostridioformis	1531	Bacteria	Bacteria	42	0.0231	NR	WP_289704086.1	1531	g2330	i0	90	0.287081339712919	20	2	28.7	0	1	60	1	20	WP_289704086.1 IS66 family transposase, partial [Enterocloster clostridioformis]	diamond	60	42	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster clostridioformis
32467732	32467732	PRJEB1404_S_NODE_1659_length_239_cov_277.343137_g1639_i0	PRJEB1404	1659	239	277.343137	662.85009743	Enterocloster clostridioformis	1531	Bacteria	Bacteria	42	0.0329	NR	WP_289704086.1	1531	g1639	i0	90	0.251046025104602	20	2	25.1	0	239	180	1	20	WP_289704086.1 IS66 family transposase, partial [Enterocloster clostridioformis]	diamond	60	42	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster clostridioformis

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