metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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
168860	168860	PRJNA1035005_P_NODE_45361_length_263_cov_0.947368_g44955_i0	PRJNA1035005	45361	263	0.947368	2.49157784	Philodina roseola	96448	Rotifera	other_Eukaryota	291	4.67e-74	NTclustered	gi\|209867641\|gb\|EU637019.1\|	96448	g44955	i0	86.792	70.1026615969582	265	29	99	6	2	263	26931	27192	Philodina roseola tyramine beta hydroxylase-like protein, metallophosphoesterase domain containing 1-like protein, transmembrane protein 45b-like protein, solute carrier family 7-like protein, G protein-coupled receptor-like protein, serpin 6 precursor, molybdenum cofactor-like protein, hypothetical protein, ankyrin repeat containing protein, neuronal calcium sensor family member 2-like protein, HSP70-like protein, hypothetical protein, Hox-5b, Smc-like protein, and golgi autoantigen golgin subfamily a4-like protein genes, complete cds	blastn	18437	291	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
2719427	2719427	PRJNA1035005_P_NODE_6043_length_435_cov_1.077348_g5643_i0	PRJNA1035005	6043	435	1.077348	4.6864638	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	298	4.89e-76	NTclustered	gi\|402761877\|gb\|JX184070.1\|	104788	g5643	i0	79.499	4.19310344827586	439	74	99	13	5	435	361	791	Macrotrachela quadricornifera isolate MM NADH dehydrogenase subunit 5 (ND5) gene, complete cds; mitochondrial	blastn	1824	298	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
6546732	6546732	PRJNA1035005_P_NODE_16506_length_314_cov_2.215768_g16100_i0	PRJNA1035005	16506	314	2.215768	6.95751152	Philodina roseola	96448	Rotifera	other_Eukaryota	292	1.59e-74	NTclustered	gi\|187936090\|gb\|EU652318.1\|	96448	g16100	i0	85.211	27.2929936305732	284	42	90	0	1	284	3540	3823	Philodina roseola 7TM protein 66, histone H4, histone H3, histone H2B, osteopetrosis associated transmembrane protein, cleft lip and palate associated transmembrane protein, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, filament protein, hypothetical protein 21, putative GPCR, and hypothetical protein 22 genes, complete cds	blastn	8570	292	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
6547020	6547020	PRJNA1035005_P_NODE_55506_length_252_cov_1.810056_g55100_i0	PRJNA1035005	55506	252	1.810056	4.56134112	Adineta vaga	104782	Rotifera	other_Eukaryota	185	2.16e-42	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g55100	i0	89.189	2.20634920634921	148	16	100	0	105	252	30100	30247	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	556	185	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
9096204	9096204	PRJNA1035005_P_NODE_11048_length_353_cov_1.625000_g10643_i0	PRJNA1035005	11048	353	1.625	5.73625	Adineta ricciae	249248	Rotifera	other_Eukaryota	368	2.92e-97	NTclustered	gi\|62362193\|gb\|AY942836.1\|	249248	g10643	i0	85.96	0.988668555240793	349	44	98	3	1	346	13	359	Adineta ricciae 60S ribosomal protein L37-like protein mRNA, complete cds	blastn	349	368	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
9935913	9935913	PRJNA1035005_P_NODE_3108_length_624_cov_6.279492_g2719_i0	PRJNA1035005	3108	624	6.279492	39.18403008	Philodinida	104783	Rotifera	other_Eukaryota	691	0	NTclustered	gi\|402761757\|gb\|JX184010.1\|	104786	g2719	i0	87.234	49.1041666666667	611	73	97	5	17	624	623	15	Habrotrocha constricta cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	30641	691	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
12922829	12922829	PRJNA1035005_P_NODE_76051_length_245_cov_0.906977_g75645_i0	PRJNA1035005	76051	245	0.906977	2.22209365	Adineta vaga	104782	Rotifera	other_Eukaryota	219	2.0599999999999993e-52	NTclustered	gi\|188501709\|gb\|EU643496.1\|	104782	g75645	i0	83.404	0.959183673469388	235	39	96	0	1	235	17217	16983	Adineta vaga clone 210L7 retrotransposon Juno1.3, complete sequence; pentapeptide repeat protein-like protein, NHL repeat containing cell surface protein-like protein, gastrin releasing peptide receptor-like protein, and integral membrane protein-like protein genes, complete cds; major facilitator superfamily permease AmpG-like protein gene, partial cds; and genes	blastn	235	219	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
16745755	16745755	PRJNA1035005_P_NODE_3054_length_632_cov_1.611807_g2665_i0	PRJNA1035005	3054	632	1.611807	10.18662024	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	758	0	NTclustered	gi\|402761793\|gb\|JX184028.1\|	104788	g2665	i0	88.449	56.4161392405063	632	68	99	5	1	630	247	875	Macrotrachela quadricornifera isolate CR cytochrome b (CYTB) gene, complete cds; mitochondrial	blastn	35655	758	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
19294486	19294486	PRJNA1035005_P_NODE_1996_length_843_cov_2.363636_g1641_i0	PRJNA1035005	1996	843	2.363636	19.92545148	Adineta vaga	104782	Rotifera	other_Eukaryota	547	8.879999999999998e-151	NTclustered	gi\|402761723\|gb\|JX183993.1\|	104782	g1641	i0	83.087	0.722419928825623	609	95	72	8	179	783	26	630	Adineta vaga ATP synthase F0 subunit 6 (ATP6) gene, partial cds; mitochondrial	blastn	609	547	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
20569813	20569813	PRJNA1035005_P_NODE_13697_length_332_cov_0.888031_g13291_i0	PRJNA1035005	13697	332	0.888031	2.94826292	Philodina roseola	96448	Rotifera	other_Eukaryota	414	3.46e-111	NTclustered	gi\|183178949\|gb\|EU432548.1\|	96448	g13291	i0	89.362	22.8012048192771	329	35	99	0	3	331	39273	39601	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	7570	414	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
20569948	20569948	PRJNA1035005_P_NODE_3297_length_602_cov_4.294896_g2907_i0	PRJNA1035005	3297	602	4.294896	25.85527392	Habrotrocha constricta	104786	Rotifera	other_Eukaryota	656	0	NTclustered	gi\|402761773\|gb\|JX184018.1\|	104786	g2907	i0	86.5	1.96843853820598	600	77	99	4	5	602	614	17	Habrotrocha constricta cytochrome c oxidase subunit 3 (COX3) gene, complete cds; mitochondrial	blastn	1185	656	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Habrotrochidae	Habrotrocha	Habrotrocha constricta
23960119	23960119	PRJNA1035005_P_NODE_2259_length_776_cov_26.011380_g1886_i0	PRJNA1035005	2259	776	26.01138	201.8483088	Philodinidae	44580	Rotifera	other_Eukaryota	776	0	NTclustered	gi\|270267490\|ref\|NC_013568.1\|	231624	g1886	i0	85.128	17.8827319587629	780	92	99	22	5	775	2423	1659	Rotaria rotatoria mitochondrion, complete genome	blastn	13877	776	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria rotatoria
24395189	24395189	PRJNA1035005_P_NODE_7820_length_394_cov_1.813084_g7418_i0	PRJNA1035005	7820	394	1.813084	7.14355096	Adineta vaga	104782	Rotifera	other_Eukaryota	289	2.64e-73	NTclustered	gi\|187936040\|gb\|EU652315.1\|	104782	g7418	i0	95.556	8.81472081218274	180	8	69	0	4	183	17294	17473	Adineta vaga speckle-type POZ protein gene, partial cds; and adenosine kinase, prefoldin subunit 1, translation initiation factor eIF-4E, Rho GTPase activating protein, histone H4, histone H3, histone H2B, histone H2Av, mitochondrial ribosomal protein s22, ribosomal protein s15a, hypothetical protein 20, START domain containing protein, arginine vasopressin receptor, filament protein, and nucleolar complex associated-like protein genes, complete cds	blastn	3473	289	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);;