RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA702290" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA702290 · 7 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
683764 683764 PRJNA702290_P_NODE_881_length_191_cov_11.118421_g873_i0 PRJNA702290 881 191 11.118421 21.23618411 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 137 4.41e-28   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g873 i0 100 1.0261780104712 74 0 78 0 112 185 5615 5542 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 196 137 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
4511838 4511838 PRJNA702290_P_NODE_1544_length_159_cov_15.266667_g1536_i0 PRJNA702290 1544 159 15.266667 24.27400053 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 139 9.82e-29   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g1536 i0 97.531 0.509433962264151 81 2 51 0 79 159 7891 7971 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 81 139 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
5787297 5787297 PRJNA702290_P_NODE_445_length_212_cov_41.537572_g437_i0 PRJNA702290 445 212 41.537572 88.05965264 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 359 9.81e-95   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g437 i0 97.608 1.92924528301887 209 5 99 0 1 209 476 268 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 409 359 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
7062365 7062365 PRJNA702290_P_NODE_1806_length_157_cov_6.398305_g1798_i0 PRJNA702290 1806 157 6.398305 10.04533885 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 135 1.25e-27   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g1798 i0 97.468 0.993630573248408 79 2 97 0 78 156 8170 8248 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 156 135 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
14712755 14712755 PRJNA702290_P_NODE_1392_length_172_cov_18.135338_g1384_i0 PRJNA702290 1392 172 18.135338 31.19278136 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 303 3.61e-78   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g1384 i0 100 0.953488372093023 164 0 95 0 7 170 5887 6050 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 164 303 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
17261697 17261697 PRJNA702290_P_NODE_1114_length_191_cov_5.157895_g1106_i0 PRJNA702290 1114 191 5.157895 9.85157945 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 89.8 1.25e-13   NTclustered gi|2754691654|gb|PP872616.1| 3003959 g1106 i0 94.737 0.596858638743455 57 3 30 0 11 67 6420 6364 MAG: Picornavirales sp. isolate TC-PLV-60 MR233-17E/328 genomic sequence blastn 114 89.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30240802 30240802 PRJNA702290_P_NODE_1852_length_156_cov_12.341880_g1844_i0 PRJNA702290 1852 156 12.34188 19.2533328 Qianjiang dicistro-like virus 78 3347494 Viruses Viruses 47 3.76e-4   NR XHA87859.1 3347494 g1844 i0 72 0.480769230769231 25 7 48.1 0 82 156 571 595 XHA87859.1 MAG: polyprotein [Qianjiang dicistro-like virus 78] diamond 75 47 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 78

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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