metadata: contig_metadata: 26 rows where bioproject = "PRJEB58983" and tax

26 rows where bioproject = "PRJEB58983" and tax_phylum = "Chordata"

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
1399664	1399664	PRJEB58983_P_NODE_6962_length_468_cov_6.665823_g6548_i0	PRJEB58983	6962	468	6.665823	31.19605164	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	211	4.86e-64	NR	NP_001091345.1	8355	g6548	i0	65.8	12.9935897435897	158	50	98.7	1	6	467	1	158	NP_001091345.1 uncharacterized protein LOC100037184 [Xenopus laevis]	diamond	6081	211	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
2267389	2267389	PRJEB58983_P_NODE_29742_length_248_cov_1.640000_g29327_i0	PRJEB58983	29742	248	1.64	4.0672	Metazoa	33208	Chordata	Chordata	52.8	0.022	NTclustered	gi\|1910335650\|ref\|XM_016135462.2\|	9407	g29327	i0	100	1.24193548387097	28	0	11	0	90	117	3486	3459	PREDICTED: Rousettus aegyptiacus adenylate kinase 9 (AK9), transcript variant X1, mRNA	blastn	308	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Pteropodidae	Rousettus	Rousettus aegyptiacus
2675139	2675139	PRJEB58983_P_NODE_33603_length_234_cov_3.111801_g33188_i0	PRJEB58983	33603	234	3.111801	7.28161434	Goniurosaurus araneus	449388	Chordata	Chordata	52.8	0.021	NTclustered	gi\|164457670\|dbj\|AB308468.1\|	449388	g33188	i0	100	0.239316239316239	28	0	12	0	14	41	1255	1228	Goniurosaurus araneus mitochondrial ND1, tRNA-Ile, tRNA-Gln, tRNA-Met, ND2, tRNA-Trp, tRNA-Ala, tRNA-Asn, tRNA-Cys, tRNA-Tyr, COX1 genes, partial and complete cds and sequence	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Eublepharidae	Goniurosaurus	Goniurosaurus araneus
5227580	5227580	PRJEB58983_P_NODE_29445_length_249_cov_0.886364_g29030_i0	PRJEB58983	29445	249	0.886364	2.20704636	Saccopteryx leptura	249018	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2756211817\|ref\|XM_066357328.1\|	249018	g29030	i0	100	0.116465863453815	29	0	12	0	220	248	1228	1200	PREDICTED: Saccopteryx leptura uncharacterized protein (LOC136386014), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Emballonuridae	Saccopteryx	Saccopteryx leptura
9052172	9052172	PRJEB58983_P_NODE_25968_length_260_cov_4.139037_g25553_i0	PRJEB58983	25968	260	4.139037	10.7614962	Phalacrocorax carbo	9209	Chordata	Chordata	56.5	0.002	NTclustered	gi\|2716838714\|ref\|XM_064442533.1\|	9209	g25553	i0	100	0.576923076923077	30	0	12	0	165	194	1866	1837	PREDICTED: Phalacrocorax carbo ubiquitin conjugating enzyme E2 W (UBE2W), transcript variant X1, mRNA	blastn	150	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Suliformes	Phalacrocoracidae	Phalacrocorax	Phalacrocorax carbo
10328262	10328262	PRJEB58983_P_NODE_7969_length_439_cov_2.101093_g7555_i0	PRJEB58983	7969	439	2.101093	9.22379827	Ornithorhynchus anatinus	9258	Chordata	Chordata	62.1	7.05e-5	NTclustered	gi\|49292283\|emb\|CR456637.3\|	9258	g7555	i0	95	0.507972665148064	40	1	9	1	281	320	87374	87412	Platypus DNA sequence from clone XX-104A18, complete sequence	blastn	223	62.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Monotremata	Ornithorhynchidae	Ornithorhynchus	Ornithorhynchus anatinus
11195459	11195459	PRJEB58983_P_NODE_32049_length_243_cov_0.917647_g31634_i0	PRJEB58983	32049	243	0.917647	2.22988221	root	1	Root_unresolved	Root_unresolved	174	4.48e-39	NTclustered	gi\|54035089\|gb\|BC084061.1\|	8364	g31634	i0	79.918	8.90123456790123	244	43	99	5	1	241	2326	2086	Xenopus tropicalis eukaryotic translation elongation factor 2, mRNA (cDNA clone MGC:79628 IMAGE:6979948), complete cds	blastn	2163	174	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
14153521	14153521	PRJEB58983_P_NODE_34832_length_223_cov_19.986667_g34417_i0	PRJEB58983	34832	223	19.986667	44.57026741	Polypterus senegalus	55291	Chordata	Chordata	270	5.02e-68	NTclustered	gi\|1993937637\|ref\|XM_039741126.1\|	55291	g34417	i0	90.385	15.7668161434978	208	17	92	3	1	206	1379	1173	PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA	blastn	3516	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
14153617	14153617	PRJEB58983_P_NODE_7472_length_452_cov_2.918206_g7058_i0	PRJEB58983	7472	452	2.918206	13.19029112	Xenopus laevis	8355	Chordata	Chordata	372	2.96e-98	NTclustered	gi\|157423658\|gb\|BC153797.1\|	8355	g7058	i0	84.533	1.69026548672566	375	58	83	0	12	386	604	978	Xenopus laevis hypothetical protein LOC100126647, mRNA (cDNA clone MGC:181736 IMAGE:8824068), complete cds	blastn	764	372	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
15020006	15020006	PRJEB58983_P_NODE_34672_length_227_cov_2.610390_g34257_i0	PRJEB58983	34672	227	2.61039	5.9255853	Lampetra	13103	Chordata	Chordata	52.8	0.02	NTclustered	gi\|2805715542\|emb\|OZ078415.1\|	7748	g34257	i0	100	0.39647577092511	28	0	12	0	195	222	12274400	12274427	Lampetra fluviatilis genome assembly, chromosome: 12	blastn	90	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
17976571	17976571	PRJEB58983_P_NODE_27695_length_253_cov_2.544444_g27280_i0	PRJEB58983	27695	253	2.544444	6.43744332	Oikopleura dioica	34765	Chordata	Chordata	119	2.89e-29	NR	CAG5090479.1	34765	g27280	i0	68.8	2.73913043478261	77	24	91.3	0	2	232	461	537	CAG5090479.1 Oidioi.mRNA.OKI2018_I69.PAR.g12618.t1.cds [Oikopleura dioica]	diamond	693	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
19250167	19250167	PRJEB58983_P_NODE_10016_length_394_cov_7.679128_g9601_i0	PRJEB58983	10016	394	7.679128	30.25576432	Mus musculus	10090	Chordata	Chordata	324	7.23e-84	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g9601	i0	84.639	8.1497461928934	332	43	84	8	44	372	384	58	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	3211	324	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19250403	19250403	PRJEB58983_P_NODE_20636_length_286_cov_2.417840_g20221_i0	PRJEB58983	20636	286	2.41784	6.9150224	Lampetra planeri	7750	Chordata	Chordata	52.8	0.026	NTclustered	gi\|2814985437\|emb\|OZ078366.2\|	7750	g20221	i0	100	0.195804195804196	28	0	10	0	6	33	2979784	2979757	Lampetra planeri genome assembly, chromosome: 43	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
20525640	20525640	PRJEB58983_P_NODE_1457_length_1052_cov_78.716037_g1157_i0	PRJEB58983	1457	1052	78.716037	828.09270924	Mus musculus	10090	Chordata	Chordata	331	1.23e-85	NTclustered	gi\|2904935199\|gb\|PQ738121.1\|	10090	g1157	i0	74.885	0.82509505703422	868	149	81	52	4	856	15	828	Mus musculus lncRNA, complete sequence	blastn	868	331	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
24350727	24350727	PRJEB58983_P_NODE_23980_length_270_cov_1.137056_g23565_i0	PRJEB58983	23980	270	1.137056	3.0700512	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	119	8.489999999999999e-31	NR	XP_003409146.1	9785	g23565	i0	62.8	53.7	86	31	95.6	1	12	269	82	166	XP_003409146.1 thioredoxin-dependent peroxide reductase, mitochondrial [Loxodonta africana]	diamond	14499	119	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Proboscidea	Elephantidae	Loxodonta	Loxodonta africana
27349937	27349937	PRJEB58983_P_NODE_6663_length_477_cov_7.757426_g6249_i0	PRJEB58983	6663	477	7.757426	37.00292202	Erpetoichthys calabaricus	27687	Chordata	Chordata	132	2.75e-34	NR	XP_051791274.1	27687	g6249	i0	77.8	5.14465408805031	90	19	56	1	78	344	115	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2454	132	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
27847962	27847962	PRJEB58983_P_NODE_21764_length_280_cov_3.173913_g21349_i0	PRJEB58983	21764	280	3.173913	8.8869564	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.2	5.35e-7	NR	XP_066287101.1	7740	g21349	i0	37	1.95	92	48	98.6	2	3	278	33	114	XP_066287101.1 large ribosomal subunit protein uL6-like [Branchiostoma lanceolatum]	diamond	546	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
28075786	28075786	PRJEB58983_P_NODE_19505_length_293_cov_0.977273_g19090_i0	PRJEB58983	19505	293	0.977273	2.86340989	Panthera uncia	29064	Chordata	Chordata	46.6	0.00296	NR	XP_049490775.1	29064	g19090	i0	40	0.716723549488055	70	35	68.6	4	62	262	572	637	XP_049490775.1 ubiquilin-4 isoform X1 [Panthera uncia]	diamond	210	46.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera uncia
28795107	28795107	PRJEB58983_P_NODE_35607_length_199_cov_4.055556_g35192_i0	PRJEB58983	35607	199	4.055556	8.07055644	Metazoa	33208	Chordata	Chordata	55.1	9.35e-7	NR	XP_039615133.1	55291	g35192	i0	53.8	14.1105527638191	39	16	55.8	1	25	135	74	112	XP_039615133.1 nephronectin a isoform X1 [Polypterus senegalus]	diamond	2808	55.5	0.992792792792793	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
28826683	28826683	PRJEB58983_P_NODE_33248_length_237_cov_2.079268_g32833_i0	PRJEB58983	33248	237	2.079268	4.92786516	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	3.21e-4	NR	XP_067980085.1	7769	g32833	i0	42	5	50	26	59.5	1	237	97	205	254	XP_067980085.1 transcription factor E2F8-like isoform X2 [Myxine glutinosa]	diamond	1185	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
29875719	29875719	PRJEB58983_P_NODE_15431_length_325_cov_4.607143_g15016_i0	PRJEB58983	15431	325	4.607143	14.97321475	Engystomops pustulosus	76066	Chordata	Chordata	47.4	2.34e-4	NR	KAG8536220.1	76066	g15016	i0	67.9	0.775384615384615	28	9	25.8	0	84	1	43	70	KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus]	diamond	252	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
30406343	30406343	PRJEB58983_P_NODE_29333_length_249_cov_1.573864_g28918_i0	PRJEB58983	29333	249	1.573864	3.91892136	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	4.68e-6	NR	XP_067886081.1	7792	g28918	i0	38	1.89156626506024	50	31	60.2	0	90	239	1663	1712	XP_067886081.1 proprotein convertase subtilisin/kexin type 5b isoform X2 [Heterodontus francisci]	diamond	471	53.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Heterodontiformes	Heterodontidae	Heterodontus	Heterodontus francisci
31993398	31993398	PRJEB58983_P_NODE_3118_length_700_cov_2.556619_g2727_i0	PRJEB58983	3118	700	2.556619	17.896333	Hypanus sabinus	79690	Chordata	Chordata	72.8	9.09e-11	NR	XP_059816063.1	79690	g2727	i0	37.6	0.934285714285714	109	62	44.6	2	587	276	110	217	XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus]	diamond	654	72.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
32303346	32303346	PRJEB58983_P_NODE_29359_length_249_cov_1.346591_g28944_i0	PRJEB58983	29359	249	1.346591	3.35301159	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.4	1.0399999999999997e-23	NR	XP_029442562.1	194408	g28944	i0	85.4	2.8433734939759	48	7	57.8	0	1	144	12	59	XP_029442562.1 coatomer subunit alpha-like [Rhinatrema bivittatum]	diamond	708	98.2	0.991853360488798	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Rhinatrematidae	Rhinatrema	Rhinatrema bivittatum
32745239	32745239	PRJEB58983_P_NODE_7660_length_447_cov_1.938503_g7246_i0	PRJEB58983	7660	447	1.938503	8.66510841	Metazoa	33208	Chordata	Chordata	45.8	0.0262	NR	XP_014393696.1	109478	g7246	i0	39.4	1.67785234899329	66	30	38.3	3	444	274	418	482	XP_014393696.1 PREDICTED: LOW QUALITY PROTEIN: latent-transforming growth factor beta-binding protein 3 [Myotis brandtii]	diamond	750	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis brandtii
32902438	32902438	PRJEB58983_P_NODE_25340_length_263_cov_2.621053_g24925_i0	PRJEB58983	25340	263	2.621053	6.89336939	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	135	3.0599999999999997e-35	NR	XP_033373003.1	9157	g24925	i0	74.7	60.5247148288973	87	22	99.2	0	2	262	408	494	XP_033373003.1 lysine--tRNA ligase isoform X3 [Parus major]	diamond	15918	135	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Paridae	Parus	Parus major

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