metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_kingdom = "Orthornavirae"

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
904042	904042	PRJNA928559_P_NODE_41_length_9217_cov_33.662620_g30_i0	PRJNA928559	41	9217	33.66262	3102.6836854	Betacoronavirus pandemicum	3418604	Viruses	Viruses	17016	0	NTclustered	gi\|1884529248\|gb\|MT831364.1\|	2697049	g30	i0	99.989	100	9217	1	100	0	1	9217	20466	29682	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WA-S2106/2020, complete genome	blastn	921700	17016	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
2179339	2179339	PRJNA928559_P_NODE_402_length_4247_cov_11.198610_g301_i0	PRJNA928559	402	4247	11.19861	475.6049667	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	5941	0	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g301	i0	93.662	2.53590769955263	3976	246	94	5	274	4247	7789	3818	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	10770	5941	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
2179707	2179707	PRJNA928559_P_NODE_70622_length_419_cov_1.511561_g69053_i0	PRJNA928559	70622	419	1.511561	6.33344059	Sopaded virus	3131761	Viruses	Viruses	97.1	1.84e-15	NTclustered	gi\|2717323334\|gb\|PP174062.1\|	3131761	g69053	i0	78.947	4.00954653937947	152	24	35	8	28	175	482	335	MAG: Sopaded virus isolate SP1C_k141_196651 genomic sequence	blastn	1680	97.1	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopaded virus
4731570	4731570	PRJNA928559_P_NODE_185284_length_254_cov_10.353591_g183715_i0	PRJNA928559	185284	254	10.353591	26.29812114	Ripaglys virus	3130696	Viruses	Viruses	196	1.01e-45	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g183715	i0	84.5	497.007874015748	200	30	79	1	31	230	2694	2496	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	126240	196	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
8557369	8557369	PRJNA928559_P_NODE_7_length_19459_cov_38.316569_g2_i0	PRJNA928559	7	19459	38.316569	7456.02116171	Betacoronavirus pandemicum	3418604	Viruses	Viruses	35918	0	NTclustered	gi\|2054207027\|emb\|OU183464.1\|	2697049	g2	i0	99.985	100.005139010227	19460	2	100	1	1	19459	34	19493	Severe acute respiratory syndrome coronavirus 2 isolate hCoV-19/Iceland/836/2020 genome assembly, chromosome: hCoV-19_Iceland_836_2020	blastn	1946000	35918	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
9830104	9830104	PRJNA928559_P_NODE_132168_length_308_cov_14.906383_g130599_i0	PRJNA928559	132168	308	14.906383	45.91165964	Chrocagost virus	3129398	Viruses	Viruses	311	4.3e-80	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g130599	i0	85.522	294.142857142857	297	43	96	0	1	297	5566	5862	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	90596	311	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
11107080	11107080	PRJNA928559_P_NODE_211989_length_243_cov_0.917647_g210420_i0	PRJNA928559	211989	243	0.917647	2.22988221	Ripaglys virus	3130696	Viruses	Viruses	261	3.34e-65	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g210420	i0	86.307	240.584362139918	241	31	99	2	1	240	171	410	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	58462	261	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
11107918	11107918	PRJNA928559_P_NODE_69489_length_422_cov_1.762178_g67920_i0	PRJNA928559	69489	422	1.762178	7.43639116	Chrocagost virus	3129398	Viruses	Viruses	483	1.22e-131	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g67920	i0	87.952	478.682464454976	415	43	97	7	1	411	5451	5862	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	202004	483	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
11108236	11108236	PRJNA928559_P_NODE_93789_length_368_cov_1.579661_g92220_i0	PRJNA928559	93789	368	1.579661	5.81315248	Ripaglys virus	3130696	Viruses	Viruses	250	1.15e-61	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g92220	i0	86.996	40.0788043478261	223	27	60	2	129	350	952	1173	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	14749	250	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
12381092	12381092	PRJNA928559_P_NODE_10150_length_963_cov_13.192135_g8951_i0	PRJNA928559	10150	963	13.192135	127.04026005	Betacoronavirus pandemicum	3418604	Viruses	Viruses	1755	0	NTclustered	gi\|2125806870\|gb\|OK670657.1\|	2697049	g8951	i0	100	98.5597092419522	950	0	99	0	14	963	20448	19499	Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/MN-MDH-14344/2021 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), and membrane glycoprotein (M) genes, complete cds; ORF6 gene, complete sequence; ORF7a protein (ORF7a) and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds	blastn	94913	1755	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
14932226	14932226	PRJNA928559_P_NODE_632_length_3457_cov_11.764775_g482_i0	PRJNA928559	632	3457	11.764775	406.70827175	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	4723	0	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g482	i0	91.502	1.3153022852184	3436	286	99	6	26	3457	1	3434	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	4547	4723	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
16205737	16205737	PRJNA928559_P_NODE_160893_length_276_cov_5.014778_g159324_i0	PRJNA928559	160893	276	5.014778	13.84078728	Sopazov virus	3131687	Viruses	Viruses	313	1.05e-80	NTclustered	gi\|2717323152\|gb\|PP173988.1\|	3131687	g159324	i0	87.546	40.018115942029	273	31	98	3	1	271	53	324	MAG: Sopazov virus isolate SP1B_k141_222276 genomic sequence	blastn	11045	313	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopazov virus
16206427	16206427	PRJNA928559_P_NODE_206913_length_245_cov_0.906977_g205344_i0	PRJNA928559	206913	245	0.906977	2.22209365	Chrocurosk virus	3129322	Viruses	Viruses	274	4.34e-69	NTclustered	gi\|2717317280\|gb\|PP171770.1\|	3129322	g205344	i0	87.712	227.959183673469	236	27	96	2	5	239	1662	1896	MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence	blastn	55850	274	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Chrocurosk virus
18756115	18756115	PRJNA928559_P_NODE_88755_length_377_cov_6.108553_g87186_i0	PRJNA928559	88755	377	6.108553	23.02924481	Chrocaferb virus	3129387	Viruses	Viruses	316	1.15e-81	NTclustered	gi\|2717317453\|gb\|PP171835.1\|	3129387	g87186	i0	82.4	13.0238726790451	375	54	98	11	1	369	68	436	MAG: Chrocaferb virus isolate CC1A_k141_77359 genomic sequence	blastn	4910	316	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocaferb virus
20030172	20030172	PRJNA928559_P_NODE_218976_length_235_cov_14.888889_g217407_i0	PRJNA928559	218976	235	14.888889	34.98888915	Ripaglys virus	3130696	Viruses	Viruses	213	9.13e-51	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g217407	i0	86	408.340425531915	200	27	85	1	31	230	2694	2496	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	95960	213	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaglys virus
22580751	22580751	PRJNA928559_P_NODE_220038_length_233_cov_5.725000_g218469_i0	PRJNA928559	220038	233	5.725	13.33925	Sopidub virus	3131684	Viruses	Viruses	180	9.169999999999999e-41	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g218469	i0	91.538	24.6351931330472	130	11	56	0	104	233	2130	2259	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	5740	180	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Sopidub virus

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