metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB6054" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB6054" and tax_phylum = "Rotifera"

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
25523107	25523107	PRJEB6054_S_NODE_3313_length_256_cov_56809.135747_g3224_i0	PRJEB6054	3313	256	56809.135747	145431.38751232	Philodina roseola	96448	Rotifera	other_Eukaryota	254	5.94e-63	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g3224	i0	90.576	23.5859375	191	18	75	0	66	256	39932	39742	Philodina roseola guanylyl cyclase gene, complete sequence; and TAR-protein (TAR_2), U1-like Zn-finger-containing protein (U1Zn_2), unknown (PruORF0001_2), unknown (PrPCG0001_2), methione sulfide reductase B (MSRB_2), Strabismus, serine-threonin kinase copy 2, plasma membrane calcium-dependent ATPase (CAse_2), myosin essential light chain (MELC_2), 82 kDa heat shock protein (hsp82_4), FBox-LRR protein (FBoxLRR_2), TPRA_2 (TPRA_2), phosphoribosylaminoimidazole carboxylase (PAICS_2), and unknown (PruORF0002_2) genes, complete cds	blastn	6038	254	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
25659050	25659050	PRJEB6054_S_NODE_4802_length_227_cov_65905.687500_g4713_i0	PRJEB6054	4802	227	65905.6875	149605.910625	Adineta vaga	104782	Rotifera	other_Eukaryota	246	8.639999999999999e-61	NTclustered	gi\|194500447\|gb\|EU850438.1\|	104782	g4713	i0	93.452	21.784140969163	168	8	73	2	63	227	26051	26218	Adineta vaga hypothetical protein 18 gene, partial cds; hypothetical protein 19, coatomer, GPCR, beta-transducin repeat, speckle-type POZ, adenosine kinase, prefoldin subunit, translation initiation factor eIF-4E, rho GTPase activating protein, histone H4, histone H3, histone H2B, and histone H2Av genes, complete cds; and mitochondrial ribosomal protein s22 gene, partial cds	blastn	4945	246	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
25659153	25659153	PRJEB6054_S_NODE_7474_length_194_cov_2.264151_g7385_i0	PRJEB6054	7474	194	2.264151	4.39245294	Rotaria rotatoria	231624	Rotifera	other_Eukaryota	348	1.91e-91	NTclustered	gi\|109892410\|gb\|DQ656785.1\|	231624	g7385	i0	98.969	84.5721649484536	194	2	100	0	1	194	11	204	Rotaria rotatoria isolate TH 28S ribosomal RNA gene, partial sequence	blastn	16407	348	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
25931114	25931114	PRJEB6054_S_NODE_10996_length_171_cov_1.088235_g10907_i0	PRJEB6054	10996	171	1.088235	1.86088185	Adineta ricciae	249248	Rotifera	other_Eukaryota	257	2.83e-64	NTclustered	gi\|37675448\|gb\|AY394701.1\|	249248	g10907	i0	94.083	8.11695906432749	169	10	99	0	1	169	479	647	Adineta ricciae 82kD heat-shock protein gene (hsp82), partial sequence	blastn	1388	257	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
26023966	26023966	PRJEB6054_S_NODE_9996_length_177_cov_2.267606_g9907_i0	PRJEB6054	9996	177	2.267606	4.01366262	Ploima	84394	Rotifera	other_Eukaryota	156	1.11e-33	NTclustered	gi\|1859640894\|gb\|MN970216.1\|	360698	g9907	i0	91.304	11.0395480225989	115	8	64	2	50	162	12518	12404	Proales similis mitochondrion, complete genome	blastn	1954	156	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Proalidae	Proales	Proales similis
26295804	26295804	PRJEB6054_S_NODE_14422_length_155_cov_2.816667_g14333_i0	PRJEB6054	14422	155	2.816667	4.36583385	root	1	Root_unresolved	Root_unresolved	287	3.21e-73	NTclustered	gi\|1399047\|gb\|U41281.1\|PAU41281	44582	g14333	i0	100	100	155	0	100	0	1	155	953	1107	Philodina acuticornis 18S rRNA gene	blastn	15500	287	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina acuticornis
26339498	26339498	PRJEB6054_S_NODE_559_length_445_cov_30783.668293_g479_i0	PRJEB6054	559	445	30783.668293	136987.32390385	Philodina citrina	468664	Rotifera	other_Eukaryota	411	6.17e-110	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g479	i0	88.102	12.7011235955056	353	33	78	7	97	445	2393	2046	Philodina citrina complete mitochondrial genome	blastn	5652	411	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
26475697	26475697	PRJEB6054_S_NODE_3208_length_259_cov_56403.071429_g3119_i0	PRJEB6054	3208	259	56403.071429	146083.95500111	Adineta vaga	104782	Rotifera	other_Eukaryota	213	1.02e-50	NTclustered	gi\|259129963\|gb\|GQ398061.1\|	104782	g3119	i0	87.368	18.3706563706564	190	19	72	3	74	259	6540	6352	Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	4758	213	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga

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