metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax_phylum = "Bacillota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1092513	1092513	PRJNA450343_P_NODE_4221_length_258_cov_2.488038_g4153_i0	PRJNA450343	4221	258	2.488038	6.41913804	Streptococcus	1301	Bacteria	Bacteria	475	1.1799999999999999e-129	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g4153	i0	100	325.732558139535	257	0	99	0	2	258	625488	625232	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	84039	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
3643528	3643528	PRJNA450343_P_NODE_4103_length_262_cov_3.089202_g4035_i0	PRJNA450343	4103	262	3.089202	8.09370924	Streptococcus	1301	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g4035	i0	100	342.290076335878	262	0	100	0	1	262	1568714	1568975	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	89680	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
4266057	4266057	PRJNA450343_P_NODE_14004_length_161_cov_0.910714_g13936_i0	PRJNA450343	14004	161	0.910714	1.46624954	Staphylococcus lloydii	2781774	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|1940089751\|gb\|CP064056.1\|	2781774	g13936	i0	98.758	2	161	2	100	0	1	161	1911639	1911799	Staphylococcus lloydii strain 23_2_7_LY chromosome, complete genome	blastn	322	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lloydii
8745487	8745487	PRJNA450343_P_NODE_13267_length_162_cov_0.902655_g13199_i0	PRJNA450343	13267	162	0.902655	1.4623011	Exiguobacterium	33986	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g13199	i0	99.383	231.061728395062	162	1	100	0	1	162	475484	475645	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	37432	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
9366937	9366937	PRJNA450343_P_NODE_10268_length_170_cov_0.900826_g10200_i0	PRJNA450343	10268	170	0.900826	1.5314042	Bacillus mojavensis	72360	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2522078538\|gb\|CP127833.1\|	72360	g10200	i0	100	0.164705882352941	28	0	16	0	14	41	202311	202338	Bacillus mojavensis strain KRS009 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mojavensis
11917749	11917749	PRJNA450343_P_NODE_10550_length_167_cov_1.728814_g10482_i0	PRJNA450343	10550	167	1.728814	2.88711938	Gemella haemolysans	1379	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g10482	i0	99.401	296.634730538922	167	1	100	0	1	167	11010	10844	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	49538	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
11917791	11917791	PRJNA450343_P_NODE_2910_length_315_cov_3.270677_g2842_i0	PRJNA450343	2910	315	3.270677	10.30263255	Streptococcus mitis	28037	Bacteria	Bacteria	577	3.9299999999999986e-160	NTclustered	gi\|1894799594\|dbj\|AP023349.1\|	28037	g2842	i0	99.683	337.984126984127	315	1	100	0	1	315	1849149	1848835	Streptococcus mitis Nm-65 DNA, complete genome	blastn	106465	577	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
13846041	13846041	PRJNA450343_P_NODE_711_length_677_cov_2.041401_g655_i0	PRJNA450343	711	677	2.041401	13.82028477	Bacillales	1385	Bacteria	Bacteria	1127	0	NTclustered	gi\|1784319663\|gb\|CP045137.2\|	1283	g655	i0	96.522	481.825701624815	690	9	100	4	1	677	2511361	2510674	Staphylococcus haemolyticus strain VB5326 chromosome, complete genome	blastn	326196	1127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
14467724	14467724	PRJNA450343_P_NODE_8512_length_186_cov_1.489051_g8444_i0	PRJNA450343	8512	186	1.489051	2.76963486	Terribacillus aidingensis	586416	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2766236627\|gb\|CP159996.1\|	586416	g8444	i0	100	0.161290322580645	30	0	16	0	11	40	1731566	1731537	Terribacillus aidingensis strain AR507 chromosome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Terribacillus	Terribacillus aidingensis
17016361	17016361	PRJNA450343_P_NODE_3174_length_301_cov_1.992063_g3106_i0	PRJNA450343	3174	301	1.992063	5.99610963	Staphylococcus lloydii	2781774	Bacteria	Bacteria	540	4.899999999999999e-149	NTclustered	gi\|1940089751\|gb\|CP064056.1\|	2781774	g3106	i0	99.003	530.584717607973	301	3	100	0	1	301	813205	812905	Staphylococcus lloydii strain 23_2_7_LY chromosome, complete genome	blastn	159706	540	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lloydii
19564824	19564824	PRJNA450343_P_NODE_12256_length_164_cov_0.886957_g12188_i0	PRJNA450343	12256	164	0.886957	1.45460948	uncultured Anaeropeptidivorans sp.	2997364	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|2817958208\|gb\|PQ455366.1\|	2997364	g12188	i0	86.061	125.90243902439	165	18	100	4	1	164	55	215	Uncultured Anaeropeptidivorans sp. clone d 23S ribosomal RNA gene, partial sequence	blastn	20648	172	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaeropeptidivorans	uncultured Anaeropeptidivorans sp.
22769440	22769440	PRJNA450343_P_NODE_11238_length_166_cov_0.871795_g11170_i0	PRJNA450343	11238	166	0.871795	1.4471797	Veillonella	29465	Bacteria	Bacteria	272	9.8e-69	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g11170	i0	96.364	551.867469879518	165	6	99	0	1	165	1075	1239	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	91610	272	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
24044353	24044353	PRJNA450343_P_NODE_10639_length_167_cov_1.144068_g10571_i0	PRJNA450343	10639	167	1.144068	1.91059356	Streptococcus	1301	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|285801502\|gb\|GU411484.1\|	28037	g10571	i0	100	100	167	0	100	0	1	167	291	125	Streptococcus mitis clone LA030 16S ribosomal RNA gene, partial sequence	blastn	16700	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
24044358	24044358	PRJNA450343_P_NODE_13959_length_161_cov_0.910714_g13891_i0	PRJNA450343	13959	161	0.910714	1.46624954	Staphylococcus	1279	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2624851299\|gb\|CP120073.1\|	29385	g13891	i0	100	53.1242236024845	161	0	100	0	1	161	2362612	2362452	Staphylococcus saprophyticus strain Dog122 chromosome, complete genome	blastn	8553	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saprophyticus

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